The following behavior occurs in SAP Analytics Cloud (SAC):
- A variable hidden at model level is ignored in the story
- SAP Analytics Cloud (Enterprise) 2021.14.31
- Live HANA Data Connection
Reproducing the Issue
- Create a model based on Live HANA Data Connection
- Create a variable based on 0CALDAY
- Flag the variable as hidden
- Create a story based on the above model
- The variable is not applied
- Open the model in edit mode
- Flag the variable as visible
- Refresh the story, the variable is applied
The behavior is as designed:
The "Hiding of dimensions" was explicitly designed and implemented as performance improvement to reduce the size of metadata.
A variable is always connected to a dimension, which is then used for filtering (but a "hidden" dimension is not available for filtering).
A parameter can have its own value help, it does not need a dimension.
A possible workaround could be to replace in HANA a variable by a parameter (may not work in all scenarios)
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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