2395452 - Create a Location Dimension icon disabled when acquiring data from SAP HANA 1.00.102.04

SAP Knowledge Base Article - Public

2395452 - Create a Location Dimension icon disabled when acquiring data from SAP HANA 1.00.102.04

Symptom

Create a Location Dimension icon disabled when acquiring data from SAP HANA 1.00.102.04

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. From the () Main Menu, select Start of the navigation path  Create Next navigation step  Model End of the navigation path.
  2. Select Start of the navigation path  Use a datasource Next navigation step  Live Data connection End of the navigation path to create a new model.
    The Create Model From Live Data Connection dialog is displayed.
    1. From the list under System select the name of the live HANA system containing the calculation views you want to import.

      Provide your access credentials to the system in the displayed Set Credentials dialog.

    2. Select the name of the calculation view you want to import from the Data Source list.
    3. Provide a name for the new model and select OK.

      The calculation view is imported and saved with the new model.

  3. Select the  (Create a Location Dimension) icon.

    The Create Location Dimension dialog is displayed.

  4. In Create Location Dimension map the location identifier for your calculation view with the corresponding location data and mapping identifiers.
    FieldRequired information
    Location Identifier Select the key column which contains the identifier for the locations
    View Name Select the location data view.
    Location Dimension Name This name is automatically generated from the Location Data name.
    Identifier for Mapping Select the name of the key column of the location data view.
    Notethe column names in the calculation view model and the location data view have to be unique.
  5. Save your model.

Cause

SAP Analytics Cloud requires SAP HANA SPS11 revision 112.04 and higher or SAP HANA SPS12 revision 122.02 and higher for this workflow

Resolution

Workaround

  1. Export data from SAP HANA 1.00.102.04 to XLSX or CSV
  2. Use the "Creating a Model with Coordinate Data for Geospatial Analysis" workflow at "https://cp.hana.ondemand.com/dps/d/preview/1949b084ea3343df9e83923e906b7a03/release/en-US/frameset.htm?c52a875d319b4cd1890a52f6286f96bc.html" to create a model with a location dimension

Solution

Upgrade SAP HANA system to SAP HANA SPS11 revision 112.04 and higher or SAP HANA SPS12 revision 122.02 and higher

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, remote HANA, geo, spatial, map, location, longitude, latitude, SAC , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0 ; SAP Lumira, desktop edition 1.0