SAP Knowledge Base Article - Public

3006282 - Text type Presentations are replaced by DISPLAY_KEY when importing data from SAP BW Query in SAP Analytics Cloud (SAC)

Symptom

The following behavioroccurs in SAP Analytics Cloud (SAC):

  • Text type Presentations are replaced by DISPLAY_KEY when importing data from SAP BW Query

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.14

Reproducing the Issue

  1. Create a query in SAP BW,  retrieving a CHAR - Character String Object
  2. In SAP Analytics Cloud: Create a Dimension based on the query
  3. Click on Import Data, Select Data Source, import the query
  4. Click on Data Management
  5. Select  the Source
  6. Click on Import Data and  select Data Source
  7. Select the SAP BW (Including BW/4HANA) option
  8. In the Dialog "Import Data from SAP BW"
    - Select the Connection
    - Check Copy a query from a Dimension
    -  Select the Model Query you have created earlier
    -  Click on Next
  9. The "New Query for SAP BW" dialog window opens, click on Next
  10. From the Available Data panel, select the Object that should come with TEXT, MIDDLE_TEXT, SHORT_TEXT, drag it, drop it in the Selected Data panel
  11. Click on the Select Presentations (wrench icon) , verify that all available presentations are selected:
    -  Key (DISPLAY_KEY  - checked
    - Medium Text (MIDDLE_TEXT)
    - Short Text (SHORT_TEXT)
    - Text (TEXT)
  12. Click on OK, to close Select Presentations dialog
  13. In the Build SAP BW Query dialog window, click on Create
  14. Observe the columns for the Medium, Short, Text, they have the DISPLAY_KEY instead of the expected text

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0