Display 0 value for not applicable data found in Company Code Hierarchy

[Former Member]

Dear Expert,

How to display 0 value inside company code hierarchy which has no data applicable data found in BW Report? I have created queries with Profit Center(PC) Hierarchy and inside this hierarchy there are several PC. Based on data in BW Cube some of the PC has no applicable data found. But my report should display all the PC inside this hierarchy with 0 value for no applicable data found. What should i do to default 0 value for no applicable data found for that PC so that my report will be display all PC in that hierarchy?

Best regards and thank you,

Lin

[Former Member]

Hi Lin,

Right now what value you are seeing when executing the query?

Thanks & Regards,

Vipin