How to Create Custom CDS Views for SAP Marketing Cloud
Supposed, as an Administrator in Marketing, you must prepare custom queries based on custom composite views, which consider other or additional base views than the standard composite views. In order to do so you can also create your own CDS composite views, which are used for custom analytical queries.
What are the Preconditions for using the “Custom CDS View” App?
As a prerequisite you have to prepare your administrator user in a way that the business catalog “Extensibility” is assigned to your business role. Your user administrator can take care on this.
The available attributes in the data base tables, e.g. for Interactions and Contacts, are sufficient for the scope of the desired query.
Apply “Custom CDS View” App to create you own View
To build a Customer CDS View you must launch the “Custom CDS Views” App from the Fiori Launchpad.
It is also possible to change existing Custom CDS Views if they are configured for editing.
You can select one from the list to change and adapt it to your needs by means of the Edit button.
If you want to create your own “Custom CDS View use the “Create” button.
If you want to use the Custom CDS View in Analytical scenarios you have to mark the corresponding check box.
You start your definition by selecting a Primary Data Source. SAP delivered and released basic views of application objects will appear in the list. From this list you must select the desired one.
Associated data sources will be selected and assigned the same way.
After the definition of the set of needed data sources and associations you must specify, which fields shall be included into the Custom CDS view.
In the last screen it is possible to define parameters and their values, which are applied when executing the view.
You can now start to define Custom Analytical Queries, if the new Custom View is defined as CDS Composite View (i.e. CDS Cube View).
To learn more about that, take a look at How to Create Custom Analytical Queries for SAP S/4HANA Marketing Cloud