Subscribe to this blog
Archives: October 2011
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used.
For example:
Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount])
This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users a message informing them about this and hide the calculation… Read more
0 comments, 688 reads
Posted in Mike Davis SQL on 28 October 2011
Setting up SSIS Auditing Part 2
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You can also see this post and more at SQL… Read more
1 comments, 680 reads
Posted in Mike Davis SQL on 20 October 2011
Setting up SSIS Auditing Part 1
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You can also see this post and more at SQL…
1 comments, 435 reads
Posted in Mike Davis SQL on 16 October 2011
Using Configuration Tables in SSIS 2008/2005
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations start out creating SSIS package one by one until they have dozens, hundreds, or even thousands of packages. I have worked with one client that ran over 4,000 packages. This…
0 comments, 391 reads
Posted in Mike Davis SQL on 3 October 2011