Skip to Content
Event Information
Author's profile photo Josef Ehbauer

How to Create Custom Analytical Queries for SAP Marketing Cloud

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 to the Business User you have to apply the following further steps

Open the application “View Browser” to create an “analytical query application” for your custom query

Select the custom query and create the needed “analytcal query application” that is being used to publish the custom query to the business user.

Then navigate to the application “Custom Catalog Extension”, add the desired business catalog to the application and and click on Publish.

When the Business User opens the “App Finder” in the Fiori Launchpad he will find the tile for the custom query and can add it to the desired business group.

When closing the “App Finder” the tile is visible in the business group for opening the query in the design studio.

Note: In order to use the Custom Analytical Query also for SAC stories, follow the following steps:


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Deborah Castle
      Deborah Castle


      A good overview but just makes a reference to adding fields to the analytic view without saying how.  It is not intuitive.  Staring at the screen in edit mode, I have no idea how to get fields from available to selected.

      Author's profile photo Monique Hahn
      Monique Hahn

      Checkmark all fields you want to add to your analytical query in column "Selection" in the list of available fields and they automatically appear in the list of selected fields.


      Author's profile photo Carlos Fernando Rivas
      Carlos Fernando Rivas

      Hi Josef:

      How can i access custom CDS Views o Queries of my SAP Marketing Cloud in SAP Analytics Cloud?

      I already has the integration configure but, i only can create models by the standar CDS views.


      Author's profile photo Josef Ehbauer
      Josef Ehbauer
      Blog Post Author

      Hi Carlos,

      in order to do so, please follow the steps on the slide which I have added as note to the BLOG.

      Kind regards,


      Author's profile photo Minnie Uppal
      Minnie Uppal

      Josef Ehbauer this is really informative. Would I need to create the query in QA and then push into Production? I have the necessary permissions and business roles assigned, but the 'New' button within production is disabled for me so I can't create a new query in prod, but have no issues in QA.



      Author's profile photo Josef Ehbauer
      Josef Ehbauer
      Blog Post Author

      Hi Minnie,

      yes, you need to transport, for doing so please refe to our business scenario for creating custom operational reports which is described here.

      Regards, Josef