Symptom
- The list of Calculation Views from SAP HANA, SAP HANA Cloud Platform is not being displayed when try to create a model in SAP Analytics Cloud
Environment
- SAP Analytics Cloud (SAC)
- SAP HANA 2.0
Reproducing the Issue
- From the Main Menu, select Create Model.
- Select a Live Data connection for datasource.
- In the dialog that is displayed, select the System you want to connect to from the dropdown list.
You will be prompted to enter the user ID and password to access the selected system. - The List of Hana Views is not appearing from the dropdown list.
Cause
- There is no Calculation views with the Data Category Type "Cube" in the HANA database.
- See SAP HANA Modeling Guide - Supported Data Categories for Calculation Views.
Supported Data Categories for Calculation Views - Cube :
Calculation views with data category Cube are visible to the reporting tools and support data analysis with multidimensional reporting.
- Dimension :
Calculation views with a data category Dimension are not visible to the reporting tools and do not support data analysis. However, you can use these calculation views as data sources in other calculation views for any multidimensional reporting purposes.
- If it is SAP HANA multi database container (multi tenant), you may connect to the System Database where no calculation view is created.
Resolution
- Create calculation views with the Data Category Type "Cube".
- Configure HTTP(S) Access to Tenant Databases per SAP HANA Administration Guide to ensure that you are connecting to tenant database where there are some calculation views created for your business requirement.
See Also
- Live Data Connections to SAP HANA
- 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 case for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- 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.
Keywords
dimension, webIDE, star-join, startjoin, HANA HDI view, PM, 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, drop-down, HCP, CloudPlatform, calcview,persistenceEncryptionServiceStatus, sap.hana.security.base.persistence , KBA , dimension , calculation view , hana live data connection , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Bug Filed