3 Replies Latest reply: Mar 7, 2012 6:43 PM by Arvind Sundar RSS

Not to Supress Hierarchy Structure

Arvind Sundar
Currently Being Moderated



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