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.