Post reply

invisible member

  • June 20, 2003 at 2:25 pm

    #105878

    Hi, Below is the mdx I need to create a measure. This mdx works for what i need. The problem is that the ,[UNIVERSAL STORE DIM].[store] level in the calculation below needs to be invisible. When I make this level invisible in the cube my mdx below no longer works. Has anyone ran into this problem before?

    sum(descendants([UNIVERSAL STORE DIM].currentmember,[UNIVERSAL STORE DIM].[store]),([Measures].[Standard 2]))

    Elizabeth Lucero


    Elizabeth Lucero

  • July 1, 2003 at 8:12 am

    #463773

    Hi Elizabeth,

    Is there a reason why you are creating a calc measure for this? If not, can't you just use the measure "Standard2" as it is, remove the lowest level from the [Universal store DIM] dimension, and let AS roll up each of the child values to the parent member?

    Steve

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply