Based on the transaction data available in the cube my hierarchy structure gets changed. I want the structure to be static.
Say for example I have account hierarchy, when I run it for different business area the account hierarchy structure changes as there is no data for that account and business area combination in the cube.
Is there a way to make the hierarchy struture static eventhough if there is no data in the cube the account in the hierarchy should display with zero.
Edited by: araj123 on Mar 5, 2012 8:06 PM
Is there a solution without creating custom hierarchy in the BEx query designer, as I want the hierarchy created in SAP ECC to be leveraged.
Edited by: araj123 on Mar 5, 2012 8:08 PM