SAP Knowledge Base Article - Public

3481404 - Numeric Fields are imported as text objects in public dimensions in SAP Analytics Cloud (SAC)


When importing data into a public dimension from a BW datasource, dimensions defined as a decimal type in the BW server get imported as text objects instead of decimal or numeric objects.  If those same dimensions are imported into a model, they are correctly imported as decimal type objects.


  • SAP Analytics Cloud (Enterprise) 2024.8.10

Reproducing the Issue

  1. Create a new public dimension
  2. Create a new data import job base on a BW import connection
  3. Select a view that contains decimal objects
  4. import the dimensions and note that they are listed as text objects rather than numeric or decimal


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


Import, BW, public, dimension, decimal, text, importing , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-AQU-BW , Data Acquisition from BW , Problem


SAP Analytics Cloud 1.0