EPCM - Multiplication and percentage consolidation operator in dimension hierarchy
I am trying to multiple 2 members using multiplication consolidation operator in dimension hierarchy, but not working as expected. Required output is ABC:=Child 1 * Child 2.
Tried below options and still not working
- Changing order of children
- adding a dummy child as 1st member with addition as operator and changing both child 1 and child 2 to multiplication.
Can anyone help with me to understand what part of configuration could be the wrong? Same issue with percentage operator as well.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):