SAP Knowledge Base Article - Public

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


  • 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


  • 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


  • 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.


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


SAP Analytics Cloud 1.0