Tuples and Set

[kado]

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

[pricter]

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])

[MFGF]

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