SAP Knowledge Base Article - Public

3049528 - Cannot save newly created public dimension

Symptom

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

  • When creating a public dimension with the 'Enable Data Access Control' and 'Hide hierarchy nodes for user without authorization' options active, after a hierarchy is added when trying to save the dimension an error occurs which prevents the dimension from saving.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.6.2

Reproducing the Issue

1. Go to the dimension location within SAP Analytics Cloud.
2. Create a new dimension.
3. Check the 'Enable Data Access Control' and 'Hide hierarchy nodes for user without authorization' options
4. Click create
5. Open the dimension and add a value 01 with a description of 01
6. Save the dimension.
7. Create a hierarchy for this dimension and give it a name H1
8. Save the dimension and this will generate an error.
- Error: "dberror(PreparedStatement.executeQuery): 340 - not all variables bound: unbound parameter : 2 of 3, 1 out of 1 batches"

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

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud 1.0