Hello Gurus,
I'm looking for a solution to find the total Sales at the Market level. Based on the dimensional hierarchy below, the user will be prompted to multi-select Products.
Market
Product Group
Product (parameter level)
The tuple function only works for a single-select product selection.
tuple([TRx_sales],ancestor([Commercial Performance Cube].[Products].[Products].[Product]->?Product?, 2))
Applying the set() syntax throws an invalid coercion error from 'memberSet' to 'member'.
tuple([TRx_sales],ancestor(set([Commercial Performance Cube].[Products].[Products].[Product]->?Product?), 2))
ANY thoughts?
thanks!!!
kado
You can not use a set inside a tuple
If you want to find the sales you try summary function
Like
total([Sales] within set [Ansestors])
So what you really want is the summary of the Sales measure across all of the selected products?
This should give you the result:
Aggregate([Sales] within set [your selected products])
This assumes that [your selected products] is defined as a set of members. If not, you may have to wrap it in a set() function, so your expression would be
...within set set([your...
MF.
Sent from my iPad using Tapatalk HD