SAP Knowledge Base Article - Public

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

Symptom

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

Environment

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

Reproducing the Issue

  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.

Cause

  • 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.

Resolution

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

See Also

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

Keywords

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 , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , LOD-ANA-LDC , SAC Live Data Connection , Problem

Product

SAP Analytics Cloud 1.0