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
- Open SAP Analytics Cloud and go to the Modeler.
- Open a public dimension of type Account that is used in a planning model configured for seamless planning with data storage in SAP Datasphere.
- In the right pane, check for the "Exposure in Datasphere" option; observe that it is not available.
- Due to this In SAP Datasphere,there are no local table has been generated for this account-type dimension.
- 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
- As product management is aware that this feature would be highly requested, internally work is carried out to have the option available regardless of dimension type.
- Development and product management is always reviewing incoming influence requests and prioritises them according to vote count.
Please consider voting on the influence idea Seamless Planning Account Type Public Dimension stored in DS space to be made available in DS Local to raise awareness.
See Also
- refer to: About Seamless Planning | SAP Help Portal
- refer to: Understand SAP Analytics Cloud Planning Data Storage Configuration in SAP Datasphere | SAP Help Portal
- refer to: About Model Configurations | SAP Help Portal
- refer to: 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
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
SAP Knowledge Base Article - Public