2686844 - SAP S/4HANA or SAP Marketing Cloud Custom Analytical Queries are no longer visible in SAP Analytics Cloud (SAC)

• SAP S/4HANA custom analytical queries are no longer visible in SAP Analytics Cloud (SAC).

• SAP Analytics Cloud
• SAP S/4HANA on-premise 1809 or higher
  or
• SAP Marketing Cloud

1. Use the "Custom Analytical Queries" Fiori App in SAP S/4HANA to create a Custom Analytics Query.
2. Create a Live Data Connection to SAP S/4HANA in SAP Analytics Cloud.
3. Notice that the Custom Analytics Query does not show up after the latest update.

• A new search for queries was developed in BW/4HANA 1.0 SP8 and is also shipped with S/4HANA On-premise 1809 (7.53) and S/4HANA Cloud 1808 (7.73).
• This new stricter search was also adopted by SAC with respect to authorizations given in CDS views.

General roles, more precisely roles like SAP_BR_ANALYTICS_SPECIALIST needed to be enhanced for the Custom Analytical Queries app. (in some other cases the role Analytics - Query Design (SAP_BCR_CA_ANA_AQD_PC) have to be enhanced)

• To see local created custom queries, please ensure that valid authorizations on authorization object SDDLVIEW have been added to the user that is maintained in the connections in SAC:

object SDDLVIEW
with values
DDLNAME = YY1_*, YY9_*
DDLSRCNAME=*
ACT = *

• About the prefixes for DDLNAME please read through our Users' Guide.

For SAP S/4HANA Cloud please follow the steps described in the article 2710858

For SAP Marketing Cloud please follow the steps described in the article 3008882

• 2710858 - Custom Analytical Queries created in SAP S4HANA are not visible in SAP Analytics Cloud
• 3008882 -  Custom Analytical Queries created in SAP Marketing Cloud are not visible in SAP Analytics Cloud
• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

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

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, S4, S/4HANA. CDS, View, 1808, Custom, Analytical, Query, Core Data Services, Custom analytical queries not showing in, Analytical queries for marketing not showing in analytics cloud, Can't see Marketing Queries in SAP Analytics Cloud, custom queries , KBA , permit to access cds views , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , LOD-ANA-LDC , SAC Live Data Connection , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem