We need to build a flat report with four hierarchies on rows, with a significant total cardinality.
By applying zero suppression to four nested hyperblocks, performance after paging is acceptable, but maintaining four self-referencing zero suppressions is cumbersome and not very scalable. For this reason, we tried to achieve the same result using a zero suppressed slice. However, after paging (only flat), performance degraded significantly, to the point that we had to remove the heaviest hierarchy from the cross join.
It is not entirely clear to us whether this behavior is expected when zero suppression is active.
More generally, the question is how to handle cases like this in order to achieve acceptable performance while keeping maintenance complexity low.
The issue becomes even more impactful in scenarios where zero suppression must be removed to manage combinations not covered by the zero suppression conditions(for example, new business cases). But even the first point is already quite relevant.
What is your experience on this topic?
Thanks in advance.
Alberto
