dbTalk Databases Forums  

Calculate the total in Claculated measures

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Calculate the total in Claculated measures in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ian
 
Posts: n/a

Default Calculate the total in Claculated measures - 09-04-2003 , 06:26 AM






I am having a tough time in building a calculated members in summing
up the Average price(another calculated members).

The cube data I have with me is look like this

kg(MEASURE) price(measure) Average(cal. measures
=price/kg)
Category
Item 1 3 18 6
Item 2 3 27 9
Item 3 4 16 4
Total 10 61 19


The problem I am having is I want to total-up all the average price
(6+9+4=19), the 19 will be used the total for the percentage each
Item's Average Price contribute.

For the total Average Price,I am using the following MDX in the
calculated measures

sum({[Product].currentmember.parent.children,[Measures].[Average]}


The result I got is 6.1 (60/10) instead of 19. Is there any
solutions for this problem? Please help me

Thank you very much in advance!
Ian

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.