2650585 - column name and data mixed when importing BW query into a Public dimension in SAP Analytics Cloud (SAC)

SAP Knowledge Base Article - Public

2650585 - column name and data mixed when importing BW query into a Public dimension in SAP Analytics Cloud (SAC)

Symptom

  • When loading BW query into a public dimension, during the data integration stage, the column names do not match with the data
  • Unable to schedule a refresh of query to a public domain

Environment

  • SAP Analytics Cloud 2018
  • SAP Cloud agent 1.0.9X

Reproducing the Issue

  1. Logon to SAC
  2. Create a public dimension : Create > Dimension
  3. Type a name
  4. Save the dimension
  5. Then go back to Browse > Dimensions
  6. Tick the box in front of the newly created dimension and click on the 'Import Data from BW Query' Icon on top right-hand corner
  7. Select the BWconnection
  8. Select the BW query
  9. The query panel displays: select the Dimensions and attributes
  10. Click on 'Create'
  11. Notice the column names do not correspond to the data

Resolution

  • Install the latest SAP Cloud agent version 1.0.101

 

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 feature at the beginning of this article.
Thank you.

Keywords

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, correspond, title, schedule, wrangling, data integration, DI, 1.0.9   , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0