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 (Web IDE)

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

  • The behavior is the design as in 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.

Resolution

  • As described in HANA Modeling Guide, SAP Analytics Cloud (Reporting application) supports calculation views with the Data Category Type "Cube".

See Also

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 , hana live data connection , calculation view , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Bug Filed

Product

SAP Analytics Cloud 1.0