dbTalk Databases Forums  

how to get percent contribution of a measure

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


Discuss how to get percent contribution of a measure in the microsoft.public.sqlserver.olap forum.



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

Default how to get percent contribution of a measure - 11-02-2004 , 05:11 PM






I wish to build a calculated measure who's value is the percent of the total
for a given measure.

For example I have a dollars measure. I want a measure that is "dollars
share", which would yeild dolllars/"total dollars".

I have a measure that will do this properly with respect to a particular
dimension, but I wish to have a generic measure that will work regaurdless of
which dimension I slice it by.

Here is the query that works for a dimension "Brand"

[Measures].[Dollars] / ([Measures][Dollars], Ancestor([Brand].CurrentMember,
[Brand].[(All)])

this calculated member works for brand, but if I try to use another
dimension it does not automatically switch to that dimension.

Is there a way to do this?

Thanks.

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.