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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AVG age calculated member

Status
Not open for further replies.
alexaweb

alexaweb

Programmer
May 11, 2001
12
CL
Hi, I have A dimension such as UserAge, where the age is in a field like [UserAge].[age].

How can I create a calculated member which displays the average age of the current set??

I tried
avg([userage].[age]) but OLAP manager won't accept it.
avg([userage].[age].members) is ok at first, but after processing the cube and browsing the data I it only displays err!!
 
Sort by date Sort by votes
Please help, I also need to count the number of distinct members of a dimension given a slice.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tarikqazza
  • Locked
  • Question
problem with calculated member and currentmember
Replies
0
Views
79
tarikqazza
tarikqazza
BSosa
  • Locked
  • Question
Calculated member within a hierarchy
Replies
0
Views
40
BSosa
BSosa
Phe0nix
  • Locked
  • Question
Dimensions with Inclusive Members
Replies
0
Views
78
Phe0nix
Phe0nix
lidsurfer
  • Locked
  • Question
Current Month Calculated Member
Replies
0
Views
28
lidsurfer
lidsurfer
venetianjigsaw
  • Locked
  • Question
A member with key '' was found in the fact table but was not found in 2
Replies
7
Views
60
venetianjigsaw
venetianjigsaw

Part and Inventory Search

Sponsor

Back
Top