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. |