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