SAP Knowledge Base Article - Public

3008882 - Custom Analytical Queries created in SAP Marketing Cloud are not visible in SAP Analytics Cloud


Custom Analytical Queries created in SAP Marketing Cloud are not visible in SAP Analytics Cloud (SAC).


  • SAP Analytics Cloud 
  • SAP Marketing Cloud

Reproducing the Issue

  1. Create a Custom Analytical Query in SAP Marketing Cloud
  2. In SAP Analytics Cloud create a Model with Live Data Connection / BW that connects to the SAP Marketing Cloud system
  3. The list of available queries does not show the Custom Analytical Query of step 1


Missing steps in the publishing of the Custom Analytical Query in SAP Marketing Cloud


To display Custom Analytical Queries from SAP Cloud Marketing in SAP Analytics Cloud, follow the steps below:

In SAP Cloud Marketing:

  1. Choose the View Browser tile on the SAP Fiori launchpad to open the application.

  2. Search for and select the custom query which you want to view in the SAP Analytics Cloud system.

  3. Choose Create Application and select Multi-Dimensional Report from the list.

  4. In the resulting Maintain Languages dialog box, fill in all the required fields and choose OK.

  5. Choose the Application ID of the query and select View in Catalog.

  6. In the Custom Catalog Extensions screen, choose Add and assign the application to a catalog from the list and choose OK.

  7. From the Custom Catalog Extensions list on the left hand side, select the Query you want to consume in SAP Analytics Cloud

  8. On the right panel click on Add

  9. Add the Business Catalog named "Analytics - Query Design" with ID: SAP_CA_ANA_AQD_PC

  10. Click on Publish (wait a few minutes until the status is Published)

After publishing is successful, the user should be able to see the query in SAC.

See Also

Your feedback is important to help us improve our knowledge base.


SAC Custom Query not showing, User Authorizations missing in Production for Planning Model, scope item 1YB , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-LDC , SAC Live Data Connection , How To


SAP Analytics Cloud 1.0 ; SAP S/4HANA Cloud 1808