SAP Knowledge Base Article - Public

2389667 - Dimension members appear as inactive in story / page (input control) / group filter and cannot be selected / planned / booked in SAP Analytics Cloud

Symptom

  • A user wants to select dimension members using a story / page (input control) / group filter.
  • When configuring the story / page (input control) / group filter with multiple dimension values, dimension members without any data (unbooked / unplanned) are shown as inactive (Hide Inactive Values) and cannot be selected.
  • The dimension option Unbooked is turned on in the story builder.
  • You try to input data into an empty version (public or private version) using a story filter or input control with the "unbooked data" option selected but no members can be selected in the story / page (input control) / group filter.

    01-Sep-17 10-01-49 AM.png

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Browse to a story.
  2. Edit filter (story / input control) for dimension.
  3. Turn on the option Unbooked (i.e. Unbooked "On" in the Edit filter screen (Set filters for <Dimension>).
    28-Jul-17 1-17-30 PM.png

  4. Select members:
    For example Time dimension: 2016, 2017, 2018, 2019, 2020 then hit OK
  5. Go back to the Time dimension filter (story or input control) in the same story: only 2016 and 2017 are active, the other years appear as inactive / unselectable.
    Note: Hide Inactive Values (#) also appears in the story or input control filter: 

    28-Jul-17 1-15-03 PM.png

Cause

  • The inactive dimension values do not have data associated with them (unbooked values).
  • There are other story filters defined.
    • When there are other story filters defined, the cascading nature of the filters will hide values in other filters that do not have corresponding values.
    • For example, if you have a filter for a country dimension with "Canada, USA" selected as values and a filter on a city dimension with "Toronto, Seattle", unselecting the "Canada" country will hide (or make inactive) the "Toronto" dimension member because Canada is already excluded.
    • It is redundant to select "Toronto" because that will not bring in results belonging to "Toronto".

Resolution

  • Turn off the "Cascading Effect" option for the story or input control filter.
  • Unbooked values will not be hidden and become active.

    28-Jul-17 1-29-08 PM.png

See Also

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

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Inactive values in filters, empty members,  "unbooked data" option, object is disabled and there is no way for reactivating it, filter is still inactive, Parent Child hierarchy is not working as expected, , KBA , parent child hierarchy is not working , version is not showing in story filter , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0