I am trying to generate a subset based on two hierarchy from same dimension.
I am trying this in PAW. I have dimension Name 'Product'.
This dimension has two hierarchies.
'Product' and 'Leaves'
On 'Product' hierarchy I have subset name 'Engineering'.
Now I would like to apply this subset on 'Leaves' hierarchy and generate a dynamic subset through MDX in which it all leaf level members from 'Engineering' hierarchy.
Is this possible. I have tried using different approaches like TM1SubsetTo function or Generate function but everytime I get the CellsetMismatch: error.
For Eg.
Code: Select all
TM1SubsetToSet([Product].[Product],"Engineering","Public")
Code: Select all
{Intersect(
[Product].[Product].[Engineering],
[Product].[Leaves].Members
)
}
provide a title
Validation failed.
Could not execute MDX expression. Error Code:rte295. Error:INTERSECT: Sets have incompatible dimensionality
Any help How can I achieve the same?
Regards,
Lav