Hello,
I have a [Product] dimension that is a hierarchy of product groups, sub-groups and families.
I've created a few calculate members, such as:
Along with that, I've created a calculated measure that returns a product's share of its parent's (product family) sales:
The only problem is that I continuously get NULL for "Share of Parent" for all calculated members. I'm suspecting that since the product lost its hierarchy, [Product].CurrentMember.Parent is evaluating to NULL.
Is there any way to preserve the hierarchy when using calculated members that are just a rename of actual dimension members? Or is there a better way to do this?
Thanks!
I have a [Product] dimension that is a hierarchy of product groups, sub-groups and families.
I've created a few calculate members, such as:
Code:
With
Member [Product].[Product 1] as '[Product].[ProductLongName]'Along with that, I've created a calculated measure that returns a product's share of its parent's (product family) sales:
Code:
Member [Measures].[Share of Parent] as 'Iif ([Product].CurrentMember.Parent is Null, Null, (Product.CurrentMember, Measures.Units)/(Product.CurrentMember.Parent, Units))'The only problem is that I continuously get NULL for "Share of Parent" for all calculated members. I'm suspecting that since the product lost its hierarchy, [Product].CurrentMember.Parent is evaluating to NULL.
Is there any way to preserve the hierarchy when using calculated members that are just a rename of actual dimension members? Or is there a better way to do this?
Thanks!