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.

 

EXT_Query_Design_LP.png

You will see the list of existing standard queries, which can be used for copying of maintained as well.

CustomAnaQueryList.png

However in order to create a new “Custom Query” you must use the “New” or “Copy” button.

CreateCustomQuery.png

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.

F4List_StandardCDSCubeViewsList.png

On the next screen you must review and if needed, change the general information of the query.

CustomQueryGeneral.png

 

 

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.

CustomAnaQueryFieldSelection.png

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.

CustomAnaQueryDisplay.png

In the Filters screen you are able to define filter conditions for this query.

CustomQueryFilters.png

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.

TestCustomQuery.png

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

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply