Re: Rollup in one dimension of calculated members in another...

How about defining a dimension consisting of OrigianalX, PositiveX, and
NegativeX.

Ohjoo


<noel.phillips@xxxxxxxxx> wrote in message
news:1163353166.807778.35940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have seen lots of posts around this topic - but am not sure if they
apply to this specific situation.

I have a dimension with 100 members against which fact data can be
loaded. For each of these members I have two formula members in the
same dimension. The formulas for which are as follows

iif ( [Dimension].&[x] > 0, [Dimension].[x], NULL)
iif ( [Dimension].&[x] < 0, [Dimension].[x], NULL)

So, for each 'input' member, there are two members - one showing the
value if it is positive otherwise NULL, and the other showing the value
if it is negative, otherwise NULL.
Below I will refer to them as OrginalX, PositiveX, NegativeX


The problem occurs when these members are rolled up against another
dimension. Instead of the rollup being the sum of PositiveX or
NegativeX - I am seeing the formulae above being applied to OriginalX.

I have played with the solve_order (but I dont think they are relative
in this context) and the ordering of the dimensions within the cube -
with no success.

I guess I can check of ISLEAF and do the aggregations in the
calculation - but given the total number of dimensions (11) and the
fact that we are using unary operators, this seems to be a no-go.

Any ideas?

thanks



.

Relevant Pages

  • Rollup in one dimension of calculated members in another...
    ... I have a dimension with 100 members against which fact data can be ... Below I will refer to them as OrginalX, PositiveX, NegativeX ... NegativeX - I am seeing the formulae above being applied to OriginalX. ...
    (microsoft.public.sqlserver.olap)
  • RE: Calculating Max Usage with OLAP
    ... to answer your question about how to only build aggregations at ... dimension and then looking at the Advanced tab in the properties pane). ... The combined number of members on both these ... > Max Used Licenses means –how many concurrent licenses have been used during ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem with Member Counts and applying filters using MDX in M
    ... Now i am trying to count the "members" in this big dimension based on ... various possible filters that the user might apply. ... So far i am able to get the count of members on this big dimenion with one ... Here is the MDX i am trying.... ...
    (microsoft.public.sqlserver.olap)
  • Re: MDX Compatibility Property
    ... It looks like a bug. ... Please do not send email directly to this alias. ... The dimension browser forms an integral part of our ... have hidden members work ok! ...
    (microsoft.public.sqlserver.olap)
  • Re: Help Needed with Dynamic Dimension Security
    ... business application for securing members. ... and the point in the hierarchy where the security ... > of using Dimension Security with a Virtual Cube. ...
    (microsoft.public.sqlserver.olap)