-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|