Supposed as an Administrator in Marketing, you have to prepare queries that include other or additional dimensions and measure than the standard dimensions. For doing so, the “Custom Analytical Queries” App enables Administrators in Marketing to create Custom Queries.
What are the Preconditions for using the “Custom Analytical Queries” App?
As a prerequisite you have to prepare your administrator user in a way that the business catalog “Analytics – Query Design” is assigned to your business roles. Your user administrator can take care on this.
Secondly you might already have created custom fields, for example in the corresponding data base tables for Interactions and Contacts, by means of the app “Custom Field and Logic”, and some of the attributes shall be exposed to the custom queries.
Note, the creation of calculated fields like calculated key figures is not possible as of now.
Apply “Customer Analytical Queries” App to create you own Query
First launch the “Custom Analytical Queries” App from the Fiori Launchpad.
You will see the list of existing standard queries, which can be used for copying of maintained as well.
However in order to create a new “Custom Query” you must use the “New” or “Copy” button.
After that you must specify the name of the CDS cube view, on which the new Custom Query shall be built on. You need to place the necessary entries for the name of the Data Views, which can be retrieved from the search dialog.
On the next screen you must review and if needed, change the general information of the query.
In the area of “Field selection” you are able to choose the required fields for the custom query.
Note, that your Custom Fields shall appear in the list of available fields.
Using the display screen you are able to set display attributes for fields in the selection list. You can, for example redefine the label or specify that the field shall be hidden.
In the Filters screen you are able to define filter conditions for this query.
Finally you have to activate the Query in order to be able to use the query.
Before doing so it is also possible to save an inactive state and to use the “Preview” button to navigate to Analytics Query UI for testing the query.
Provision of Custom Query to Business User
In order to provide the custom query, you have to assign the Business Catalog “Analytics – Query Design” for the required Business Role, e.g. “Marketing Expert” to grant access to the custom queries for the Marketing Business User