SAP Knowledge Base Article - Public

3773398 - restricted measures show all g/l accounts when expanding p&l table nodes with null suppression on (SAP Analytics Cloud)

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

  1. Log in to the tenant and open the affected story that uses an import model.
  2. Navigate to the xxx page in the story.
  3. Turn ON null suppression for the table columns (Table > Show/Hide > select “Nulls in Table Column”).
  4. 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.
  5. Turn OFF null suppression for the table columns.
  6. 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