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