SAP Knowledge Base Article - Public

2710977 - BW Structure is not shown properly in table after filtering structure value with input control from Live BW connection in SAP Analytics Cloud (SAC)

Symptom

  • BW Structure is not shown properly in table after filtering structure value with input control from Live BW connection in SAP Analytics Cloud (SAC)
  • The filtering is working fine in Analysis for Office

Environment

  • SAP Analytics Cloud 2018.18.4
  • Live Data Connection to SAP BW

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a Live Data connection to SAP BW.
  3. Create a model to a BEx query having sturcture with at least 2 levels defined on the connection.
  4. Create a Table Story on the model.
    => All values in the structure will be shown in the table.
  5. Add a new Input Control on the structure object.
    => All values in the structure will be shown in a flat list.
  6. Uncheck any "leaf" value in the stucture.
    => The "leaf" value will be still shown in the table and the filter doesn't take effect.
    => To remove the "leaf" value from table, it is necessary to uncheck its "parent" value as well.
    => It is working fine in Analysis Office.

Cause

The behavior has been identified as limitatio of current product by Development.

Resolution

You can request an enhancement or improvement request that is not currently available in SAP Analytics Cloud (SAC) by accessing SAP Analytics Cloud & SAP Digital Boardroom Customer Influence. Product management is committed to reviewing the most voted improvements in the influence portal.

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, BW, BEx, structure, input control, filter, hide, show, live, table, , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Product Enhancement

Product

SAP Analytics Cloud 1.0