SAP Knowledge Base Article - Public

3222351 - Unable to see the newly created dimension value in the story when the data access control is turned on for this dimension in the model in SAP Analytics Cloud (SAC)

Symptom

After adding a new dimension member in the public dimension with data access control turned on in the model, this newly created dimension value could not be seen in the input control established based on this dimension in the story

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Create a model with dimension A
  2. Click on the dimension A
  3. In the Dimension Details Panel, switch on the "Data Access Control" button for the dimension A, and then click "Save"
  4. Click "Add" to add a member for the dimension A
  5. Create the Member ID, Description. Hierarchy for this new dimension member
  6. Click Save
  7. Observe that the message "The model is saved successfully" and the message "The user data access settings will be updated for the dimension Entity in the background. You will be notified once it is complete".
  8. Create a story based on the model.
  9. Create a table and add dimension and measure for this table.
  10. Add an input control based on the dimension A
  11. Click the 3 dot button of this input control and click "Edit Input Control"
  12. In the Set Filter for Entity panel, search the newly created member of dimension A
  13. Observe that the message "No available members" would appear

Cause

  • This issue is caused by the stuck job in the backend system.

Resolution

Raise a support ticket under the component LOD-ANA-ADM-DAC and indicate this KBA

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud
, KBA , LOD-ANA-ADM-DAC , Data Access Control , Problem

Product

SAP Analytics Cloud 1.0