SAP Knowledge Base Article - Public

2805925 - Unable to show only parent members of hierarchical structure in table using filter in SAP Analytics Cloud (SAC)

Symptom

  • Unable to show only parent members of hierarchical structure in table using filter in SAP Analytics Cloud (SAC)
  • However, it is possible to show only parent members by default before using filter

Environment

  • SAP Analytics Cloud 2019.8.11
  • SAC BW 7.5

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with Table on Live BW model created on BW query with hierachical structure, in which some child members are set as Hide (Can Be Shown).
    => By default, the child members are not shown in the table but only their parent member(s) are shown.
  3. Open the filter applied on the structure in Builder.
    => Both parent members and child members are selected.
  4. Don't change the filter but click OK button directly.
    => The child members marked as "Hide (Can Be Shown)" are shown in the table now.
    => Unable to show only parent members in table using filter where it is impossible to select parent members only.
    => Same issue could be observed in RSRT (ABAP BICS mode), where even it is possible to select parent members only, the child members will still be shown after applying filter.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, parent, child, structure, hierarchy, hierachical, hide, can be shown, shown, show, filter, selection, select, default, first, second , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0