SAP Knowledge Base Article - Public

3786279 - Public Dimension Members Not Available During Data Import Mapping; "could not get account members" Error in Model

Symptom

  • Dimension members in a Public Dimension are not showing during data load mapping in the model.
  • Searching for members during mapping returns the error: "Could not get account members".
  • Specific members are not available for selection in the account mapping step.

Environment

  • Product: SAP Analytics Cloud
  • SAC Modelling

Reproducing the Issue

  1. Log on to the tenant.
  2. Open the target model in the modeler.
  3. Confirm the public dimension contains the expected members.
  4. Open Data Management and the draft data import job (based on a query).
  5. In the mapping screen: double-click the Public Dimension, remove it, then open Measures.
  6. Search for a member within the affected Public Dimension.
  7. Observe the error "Could not get account members".
  8. Attempt to map the account dimension: Members within the Public Dimension are not listed for mapping.

Cause

  • For public dimensions, new members cannot be created or surfaced by importing data directly through a model’s data import/mapping. The required account members do not exist in (or are not published from) the public dimension at the time of mapping, which leads to the lookup failure and the "Could not get account members" error.

Resolution

  • Fix is targeted for release in QRC4

See Also

Keywords

public dimension, gl_account, account members, could not get account members, mapping, data import, sac model, dimension members missing, measures mapping, hierarchy, data management, member visibility, data access controls, dac , KBA , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud all versions