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

Not to Supress Hierarchy Structure

Arvind Sundar
Currently Being Moderated

Hi,

 

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.

 

Thanks,

 

Anand

 

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

Actions