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
- Use the "Custom Analytical Queries" Fiori App in SAP S/4HANA to create a Custom Analytics Query.
- Create a Live Data Connection to SAP S/4HANA in SAP Analytics Cloud.
- 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
- 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.
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