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)
 calculated members

Author  Topic 

Christina Agyeman
Starting Member

15 Posts

Posted - 2002-02-13 : 11:05:32
I am using Excel 2000 and after defining a Pivot Table, my calculated members from a cube I created in SQL Server Analsis Services
are outputting as 0. This is the formula I am using for the calcualted memeber in the cube.
IIF(Consultant.currentMember.level.name = "Full Name",Consultant.CurrentMember.properties("Salary"),"")


   

- Advertisement -