Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculated members

Status
Not open for further replies.
cagyeman

cagyeman

Programmer
Joined
Feb 13, 2002
Messages
1
Location
GB
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"),"")
 
Status
Not open for further replies.

Similar threads

tarikqazza
  • Locked
  • Question Question
problem with calculated member and currentmember
Replies
0
Views
215
tarikqazza
tarikqazza
Phe0nix
  • Locked
  • Question Question
Dimensions with Inclusive Members
Replies
0
Views
222
Phe0nix
Phe0nix
BSosa
  • Locked
  • Question Question
Calculated member within a hierarchy
Replies
0
Views
128
BSosa
BSosa
thyOdin
  • Locked
  • Question Question
Hide members of snowflake/parentchild dimension when null
Replies
4
Views
238
MDXer
MDXer
Edmand
  • Locked
  • Question Question
How Do I Count Filter Members
Replies
0
Views
108
Edmand
Edmand

Part and Inventory Search

Sponsor

Back
Top