Skip to Content
0
Jun 16, 2011 at 07:36 AM

Default 0 instead of "no data available"

38 Views

Dear Expert,

How to display 0 value inside a Circle hierarchy which has no applicable data found in BW Report? I have created queries with Bank Hierarchy and inside this hierarchy there are several Circles. Based on data in BW Cube some of the Circles doesnt have any applicable data for a given period. Right now when i am exwcuting the query, it is showing "no data available" for that Circles. But my report should display all the Circles 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 Circle so that my report will be display all Circle in that hierarchy?

Best regards and thank you,

Bikash