Hi Bill.

Yes. Definitely "how to do it in ProClarity". I am trying to do is set up a measure for a user.

MDX is new to me - thank you for the explanation. However, I do NOT want to choose columns and rows. The user will select this in Proclarity.


As mentioned earlier, the actual query (a calculated measure)looks like this:

iif(([Measures].[Sales Value], [Item].CurrentMember.parent.parent) <> 0, ([Store Brand].[Shoprite],[Measures].[Sales Value], [Item].CurrentMember) / ([Store Brand].[Shoprite],[Measures].[Sales Value], [Item].CurrentMember.Parent.Parent)*100 , NULL)

So I only need the definition of the calculated member. Not the whole query.

Here we look at a value for Shoprite (1 member) only . I now want to see the COMBINED Values for 2 members.

I manually selected two brands just to see what ProClarity generates so I could use the code. It generates code that uses AGGREGATE, But it seems AGGREGATE can only be used with SELECT (which I don't want to use).


I would have expected something like [Store Brand].[Brand1].&[Store Brand].[Brand2) to work. (Brand 1 and Brand 2 being members of the dimension 'Store Brand')

Thanks!
Berenice