Handling and Tuning Really Large Analysis Services Cubes
October 14, 2014 Leave a comment
Just trying to speed up our cubes at the moment and found this blog post really useful, thanks!
Comparing strings with trailing spaces
June 30, 2014 Leave a comment
select top 1 * from database.dbo.table WHERE 1=0 — returns no results
— makes sense
select top 1 * from database.dbo.table WHERE 1=1 — returns 1 row
— yep
select top 1 * from database.dbo.table WHERE ‘frog’ = ‘frog’ — returns 1 row
— cool
select top 1 * from database.dbo.table WHERE ‘frog’ = ‘frog ‘ — returns 1 row
— eh!!?
Apparently it’s by design – http://support.microsoft.com/kb/316626
I didn’t know that!
Exporting user list from SharePoint 2010
June 27, 2014 Leave a comment
Here’s the magic URL – Just replace the bits in square brackets with the appropriate values for your site
[YOURSITE] – This is the main root of your SharePoint url
[LISTID] and [VIEWID] – Get these by going to ‘Site Actions’ -> ‘Site Settings’ -> ‘People and Groups’. Click on ‘Settings’ -> ‘List Settings’ then down at the bottom under ‘Views’ click on ‘List View’. Now look in your URL and you will see ‘List=’ and ‘&View=’ – These are the GUIDS you need for LISTID and VIEWID.
Once you have constructed your URL in notepad, paste it into internet explorer and hit enter – This should then prompt you to open or save the results – Click open and follow the instructions in Excel.
Changing object ID in SSAS BIDS
June 24, 2014 1 Comment
Developing an analysis services database in BIDS – You have created a dimension for example based on a table in your dsv called frog
You now want to rename this (for reasons that are entirely your own!) – Changing the name is easy via the properties but changing the ID is a bit trickier.
The trick is to right click the object (in this case the frog dimension) in BIDS and select ‘view code’ – You can then edit the ID here in the first couple of lines.
Resources for BI Strategy
March 13, 2014 Leave a comment
B eye Network – http://www.b-eye-network.com
http://www.b-eye-network.com/view/8137 (part 1) + http://www.b-eye-network.com/view/8360 (part 2)
The four best and worst practices in Business Intelligence
http://www.itbusinessedge.com/slideshows/show.aspx?c=83418
The data warehouse institute – http://tdwi.org
http://tdwi.org/blogs/wayne-eckerson/2010/03/high-performance-teams.aspx
http://tdwi.org/whitepapers/2013/03/process-driven-bi-building-smarter-business-processes.aspx
http://tdwi.org/portals/agile-bi.aspx
Kimball – http://www.kimballgroup.com/
Self Documenting Cubes
June 11, 2013 Leave a comment
How cool is this!
http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-2/
Getting your SQL Server databases under source control
February 8, 2013 Leave a comment
Here’s a tip – There is a free download available called SQL Server Data Tools that lets you put your databases into source control (I’m using TFS).
Check it out here – http://msdn.microsoft.com/en-gb/data/tools.aspx
It comes with the facility to do a schema compare which is useful just in itself if you havent shelled out for Redgates SQL Compare. It only compares schemas though, not data. However it will apply changes to a database for you, so for example you can compare your files in source control with the dev/live database and then apply any differences with the click of a button.
I’m hoping to use this to facilitate continuous integration and have an automated test build of our data warehouse databases – I will post back with details when it’s all set up and running.
Populate/maintain a sharepoint list using SSIS
September 28, 2012 Leave a comment
Ever wanted to get data from your database onto sharepoint? Need to populate a list fast? Here’s how…
Firstly you need an addin for BIDS – http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
Add this to your toolbox items and you can create SharePoint lists as source / destination.
Dont have much time to flesh this out but wanted to keep the link above for future reference. 🙂
Hello world!
October 8, 2010 1 Comment
Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!
Dan's BI Braindump 