Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 how to create a calculated members?

Author  Topic 

tyme
Starting Member

10 Posts

Posted - 2007-09-23 : 22:37:36
My olap report contain year,quarter, month,day & sale_value..i will select the date to be 31 dec for each year..now i want to create a calculated member called sale_growth..where the value will be difference of sale_value between years,for example:
sale_growth[2006] = sale_value[31 dec 2006] - sale_value[31 dec 2005]..how can i do that?...can anybody help me how to create the calculated members?
   

- Advertisement -