I am trying to write a "% of Parent" -type of rule in an alternative/virtual (not sure what's the official term...) Hierarchy. Here below is a simplified code of this
The rule for the primary/base dimension looks like this, and works fine:
Code: Select all
[Measures: '% of Parent'] = [Measures: 'Gross Sales'] \ DB('Sales',!Version,!Time,ELPAR('Products',!Products,1),'Gross Sales');
Code: Select all
[Measures: '% of Parent in Bucket1'] = [Measures: 'Gross Sales'] \ DB('Sales',!version,!Time,ElementParent('Products','By Bucket1',!Products,1),'Gross Sales');
Code: Select all
[Measures: 'TestParent'] = S:ElementParent('Products','By Bucket1',!Products,1);
Any help appreciated,
Thank you
Matyas