We are working on BPC 10NW SP05
We have built few reports where we are showing different hierarchies. However, eventhough there is data in the backend, it doesn't show the values.
Example A1 is a hierarchy with A11, A12 and A13 accounts having 10, 20, 30 values in these base accounts. When a report is executed for base level accounts, then it displays the value in the report. However, if the report is executed for roll up account (A1) it doesn't display values at base level as well as rolled up level.
Note: We are using H2 hierarchy for ACCOUNT dimension.
Surprisingly, it doesn't work for hierarchy on any of the dimension.
Are we missing any parameters to be set?
Thanks in advance