January 22, 2004 at 5:27 am
I haven't been able to find a good intermediate to expert level book on building calculated members. Help and BOL have no examples that I can find on how to incorporate the functions into the members.
As an example - A simple fact table with total premium and a time dimension with only two years in it. How do a create a calulated member that contains the difference between Year 2 and Year 1?
I intuitively figure it has to be something like
mytimedimension.level.2.myfact.premium - mytimedimension.level.1.myfact.premum
Any help on either the books and a solution to this specific example would be much appreciated.
A 9 year SQL Server zealot.
Pistol Pete
January 22, 2004 at 8:25 am
MDX Solutions by George Spofford is by far the best resource that I have found on MDX.
As far as your calculation goes, check out the Ancestor or Lag functions.
Steve Hughes, Magenic Technologies
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply