SAP Knowledge Base Article - Public

2797850 - Cannot edit CDS view set as Analytical as Cube error Invalid entry

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

  1. Enter in Fiori Launchpad
  2. Select 'Custom CDS Views' tile
  3. Search of a View that has been created as 'Cube' but the Source Data View is Demension 
  4. Select Edit
  5. In the field 'As' you if you select the drop-down you get Invalid entry error
  6. 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

Creating a Dimension

2540696 - Custom CDS Views – Content Rules

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

Product

SAP S/4HANA Cloud 1905