Viewing 7 posts - 571 through 577 (of 577 total)
I think if you tried that SSAS would still know that it is a calculated measure being used in the scope.
I had a quick google search and found this from...
June 9, 2011 at 8:08 am
By default, you can't use drillthrough with calculated measures. There are ways around it though, as is discussed here:
Drillthrough's are expanded upon in the ASSP project on codeplex:
Hope this helps...
June 9, 2011 at 5:27 am
I can't say I've ever seen this done. I'm skeptical that it is even possible but perhaps you are asking the wrong question. You should maybe ask yourself why you...
June 3, 2011 at 10:11 am
Assuming the table is called "Vouchers" and assuming I understand what you're after then this should do the trick:
WHEN Amount < 0
June 2, 2011 at 6:34 am
The maximum length of a variable expression is 4000 as is discussed here: http://consultingblogs.emc.com/jamiethomson/archive/2009/05/27/4000-character-limit-in-ssis.aspx
Your expression is well under that amount unless your count variable is unbelievably massive in which case...
June 2, 2011 at 4:22 am
You need to create another variable to hold the SQL and then pass the value of the existing variable into that.
So create a new variable with a string datatype, in...
May 31, 2011 at 8:17 am
This was a very quick and dirty solution 🙂
April 27, 2011 at 2:04 am