Calculated Members - any good books out there?

• petedoyon

  SSC Enthusiast

  Points: 188

  More actions

  January 22, 2004 at 5:27 am

  #106863

  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

• hoosierpride

  Mr or Mrs. 500

  Points: 565

  More actions

  January 22, 2004 at 8:25 am

  #491137

  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

  steve.hughes@magenic.com