Skip to Content
Former Member
Dec 27, 2010 at 08:23 AM

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


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,