Symptom
- The table structure appears visually correct, but when expanding a node, all xxx accounts are displayed instead of only those defined in the restricted measures.
- Restricted measures do not consistently honor their assigned xxx account filters during expansion.
- When null suppression is ON: the table structure looks correct, but expanding a line shows all xxx accounts rather than the filtered set.
- When null suppression is OFF: only the restricted xxx accounts are shown, but the table structure and local formulas/totals become misaligned or incorrect.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Log in to the tenant and open the affected story that uses an import model.
- Navigate to the xxx page in the story.
- Turn ON null suppression for the table columns (Table > Show/Hide > select “Nulls in Table Column”).
- Expand a xxx line that is built from a restricted measure; observe that all xxx accounts appear instead of only those included in the restriction.
- Turn OFF null suppression for the table columns.
- Expand the same xxx line; observe that only the restricted xxx accounts are displayed, but the xxx structure and local formulas/totals become misaligned or incorrect.
Cause
This issue is currently under investigation by development.
Resolution
This issue is currently under investigation by development.
See Also
Keywords
sac, restricted measures, gl account filter, null suppression, table expansion, p&l structure, local formulas, totals misaligned, show/hide nulls, import model, story table, account dimension, optimized story experience, classic design, row expansion , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public