SAP Knowledge Base Article - Public

3024154 - HANA view variable is ignored when it is set to hidden in dimensions of the model in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • A variable hidden at model level is ignored in the story

Environment

  • SAP Analytics Cloud (Enterprise) 2021.14.31
  • Live HANA Data Connection

Reproducing the Issue

  1. Create a model based on Live HANA Data Connection
  2. Create a variable based on 0CALDAY
  3. Flag the variable as hidden
  4. Create a story based on the above model
  5. The variable is not applied
  6. Open the model in edit mode
  7. Flag the variable as visible
  8. Refresh the story, the variable is applied 

Cause

The behavior is as designed:

The "Hiding of dimensions" was explicitly designed and implemented as performance improvement to reduce the size of metadata.

However,

variable is always connected to a dimension, which is then used for filtering (but a "hidden" dimension is not available for filtering).

parameter can have its own value help, it does not need a dimension.

Resolution

A possible workaround could be to replace in HANA a variable by a parameter (may not work in all scenarios)

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0