Symptom
When trying to make changes to a View that has been created as Analytical 'Cube' it is not possible and you get error Invalid entry, the field 'As' is surrunded of a red box.
Environment
SAP S/4HANA Cloud Public Edition 1905
Reproducing the Issue
- Enter in Fiori Launchpad
- Select 'Custom CDS Views' tile
- Search of a View that has been created as 'Cube' but the Source Data View is Demension
- Select Edit
- In the field 'As' you if you select the drop-down you get Invalid entry error
- It is not possible make any change
Cause
In order to expose a Custom CDS View as Cube please notice the following the primary data source cannot be a Dimension.
Resolution
You are using a primery data source that is a Dimension.
It is not possible to create an Analytical Cube with a primary data source that is a Dimension, refer to SAP note 2657021.
This was possible in the past but currently it is only permitied touse it As Dimension.
If you try to change the already created View to a Dimension it will fail because it has dependencies built on top of it.
To fix this you have either to delete the dependent objects, and then change it As Dimension, or create a new copy of the Custom CDS View stack.
See Also
Keywords
analytical, invalid entry, Custom CDS views, Custom CDS view, annotation, CUBE, campatibility, #Fiori , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem