June 29, 2009 at 12:36 pm
The problem that I am experiencing is that the set calculation is done upfront. What I want to do is calculate top 25% faculty earnings based on year but my faculty never changes because the top 25% is only calculated once. Any suggestions?
June 29, 2009 at 1:44 pm
If you have SSAS 2008 you can utilize Dynamic Sets now.
Take a look at this posting and this might help you in resolving this issue - http://www.setfocus.com/technicalarticles/kgoff/mdxnamedsets.aspx
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 30, 2009 at 10:58 am
Hi
Can you explain it bit more clearly?
June 30, 2009 at 11:39 am
Prior to AS 2008, the set logic was evaluated only once, so whoever was int he Top 25 when the script was executed, that's who's there now. What Dan was pointing you to is the ability, in 2008, to specify the set as being Dynamic, so it's evaluated on every use (ie it will return the top 25 using the filters etc that you're supplying).
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply