Cacluclated Member issue

Last Post 02 Aug 2004 12:34 PM by Vinay Dharmik. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Sam001
New Member
New Member

--
13 Jul 2004 10:56 AM
Hi,

I have a cube with 3 dimensions. I have 1 year worth of Data in the cube. yr 2003

1. Product
2. Time (Yr , Qtr, Month)
3. Measures [ # of Items Sold - Src Measure, Avg # of Items Sold - Calculated]

I have problem in my calculation. The formulae is as follows.

Avg # of Items Sold = [Measures].# of Items Sold / [Time].[Month].Members.Count

Case 1:

When i select the whole year, the formulae works good. It divides the [# of Items Sold] by 12 (Total no of months in the year)

When i select Quarter 1 or Quarter 2 it still divides the [# of Items Sold] by12 instead of 3. Looks like it is acting like a static formulae instead of resolving itself to the number of months in the selected quarter.

Can some body help with the formulae?

Thanks,

Sam001
Vinay Dharmik
New Member
New Member

--
02 Aug 2004 12:34 PM
Use this
Count (Descendants([Time].CurrentMember, [Month]))
instead of Time].[Month].Members.Count in u'r Calculated Member
You are not authorized to post a reply.

Acceptable Use Policy