It has been observed that when customer is seeing issue with simple crosstab while changing data levels- sample/full data.
When viewing a crosstab with just one column and one row in Sample Data mode, it looks fine. If you switch to Full Data mode, all values disappear with only the bottom totals value. The field and measure used here is simple, not calculated ones. They are on JRS 8.0.3.
Upon doing some investigation it is found that this happens because of axis node limit. When this limit is reached Crosstab will show only totals instead of all nodes. So, there is no way end user would understand the reason behind this behavior.
So, it should show some message like below on UI:
"Axis node limit has been reached. Crosstab will show only totals instead of all nodes. Please increase axis node limit to see more data."
Ref: JS-68698
Components | AdHoc |