SAP Knowledge Base Article - Public

2467056 - No calculation view shows up in drop-down list in SAP Analytics Cloud using Live Data Connection to SAP HANA

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

  1. From the Main Menu, select Create Model.
  2. Select a Live Data connection for datasource.
  3. 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.
  4. 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

    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

    Product

    SAP Analytics Cloud 1.0