Report with Shared Axist with no data still appears
I have two reports on SAP BPC 10 and they share the same axis. I have found that even if the reports have no data they still show one line with the name of the top node with zeros. This is even if I have set the report to suppress zero and no values in the rows - is this normal?
That is does a report which has no data always show one line even if it is set to suppress rows if zero?
Vadim Kalinin replied
I have created 2 reports with shared page and column axis (with no data):
First report shows parent NETSALESADVCASH and children, second - parent 0 and children.
If I suppress zero and empty for rows using sheet options the result will be:
with hidden rows 8 and 9.
If I unhide rows:
I will see same parents for both reports!
The same picture will be if I suppress zero and empty rows individually for each report.