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

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

• SAP Analytics Cloud

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

   Field	Required 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.

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

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

• Help resources
• Help portal
• SAP Community ( Questions & Answers / Direct Link to Create Question / Blogs )
• SAP community wiki
• Ideaplace forum ( for enhancement requests & new features )
• Video tutorials 
• Videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
• Training events
• Past event recordings
• New user handbook
• Roadmap
• How to connect to on-premise data
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
• Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)

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.

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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem