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.

FioriLP_App.png

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.

StandardListDataSources.png

If you want to create your own “Custom CDS View use the “Create” button.

DataSourceGeneral.png

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.

F4ListDataSources.png

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.

DataSourceFieldSelection.png

You can also assign and define additional properties to the chosen fields.DataSourceFieldProperties.png

In the last screen it is possible to define parameters and their values, which are applied when executing the view.

DataSourceFieldParameters.png

Using the “Data Preview” Button you can take a look at the data, this view is allowing you to access.CDSViewTesting.png

 

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

 

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply