dbTalk Databases Forums  

Calculate Market Shares based on changing totals

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


Discuss Calculate Market Shares based on changing totals in the microsoft.public.sqlserver.olap forum.



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

Default Calculate Market Shares based on changing totals - 01-22-2006 , 09:22 AM






Hi..
I have a major problem with an MDX Calculation. What I try to do define a
calculated member (SSAS) to calculate a market share. So far so good (Value
/ Total *100 = Market Share). My problem is the following:
The specification of the Total in my equation is dynamic and can't be
predefined.
It depends on what dimension is presented on the axis of an MDX query, since
some of the dimensions in my cube can define a market.

So what I have to do is:
- detect, how many dimensions are located on an axis
- detect, whether one of the mensioned "market defining" dimensions are
located on an axis
- detect, whether one of these dimensions is filtered in the slicer

I hope that I was able to describe my problem and hope for some hinds that
can push me in the right direction.
Thanks in advance.

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.