SAP Knowledge Base Article - Public

3744974 - Account & Version & Time dimensions are missing "exposure in Datasphere" option for seamless planning in SAP Analytics Cloud causing that no local table is created in SAP Datasphere

Symptom

  • An account-type public dimension stored in SAP Datasphere (seamless planning) does not show the "Exposure in Datasphere" option in the right pane of the modeler in SAP Analytics Cloud.
  • Because the dimension cannot be exposed, no corresponding local table is generated in Datasphere.
  • It was noticed that generic-type dimension in it's context menu does show the "Exposure in SAP Datasphere" option and creates a local table when exposed.
  • Apart from Account the same behaviour is observed for version- and time-type dimensions,that the "Exposure in SAP Datasphere" is not available.

Environment

  • SAP Analytics Cloud (enterprise)
  • SAP Datasphere 

Reproducing the Issue

  1. Open SAP Analytics Cloud and go to the Modeler.
  2. Open a public dimension of type Account that is used in a planning model configured for seamless planning with data storage in SAP Datasphere.
  3. In the right pane, check for the "Exposure in Datasphere" option; observe that it is not available.
  4. Due to this In SAP Datasphere,there are no local table has been generated for this account-type dimension.
  5. As a comparison, open a public dimension of type Generic and verify that the "Exposure in SAP Datasphere" option is available and, when exposed, a local table is generated.

Cause

  • Currently the behaviour described in this KBA is a known limitation,namely in seamless planning, only generic-type dimensions are supported for exposure to SAP Datasphere.
  • Account-, version-, and time-type dimensions are not yet supported for exposure and therefore do not create local tables in Datasphere.

Resolution

See Also

Keywords

seamless planning, exposure in datasphere missing, expose to Datasphere, account dimension not exposed, version dimension not exposed, time dimension not exposed, local table not generated, sac modeler, datasphere storage, public dimension, planning model limitation, account type, version type, time type , KBA , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud all versions