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 Mike Lewis 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
0
0
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
47
tarikqazza
tarikqazza
BSosa
  • Locked
  • Question
Calculated member within a hierarchy
Replies
0
Views
20
BSosa
BSosa
Phe0nix
  • Locked
  • Question
Dimensions with Inclusive Members
Replies
0
Views
31
Phe0nix
Phe0nix
lidsurfer
  • Locked
  • Question
Current Month Calculated Member
Replies
0
Views
9
lidsurfer
lidsurfer
venetianjigsaw
  • Locked
  • Question
A member with key '' was found in the fact table but was not found in 2
Replies
7
Views
27
venetianjigsaw
venetianjigsaw

Part and Inventory Search

Sponsor

Back
Top