SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  • 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

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

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

Product

SAP Analytics Cloud 1.0