Symptom
- Trying to create the KPI using the Data source C_SalesAnalyticsQry_1
- Unable to activate OData and Entity Set for Smart Business KPI while creating the KPI tile using the Data source C_SalesAnalyticsQry_1
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Go to 'Manage KPIs and Reports' App
- Go to 'KPI' tab and Click on Create KPI
- Select the Group
- In 'Define Data Source Details' click on 'Define' button
- Select the CDS view as 'C_SalesAnalyticsQry_1'
- OData Service and Entity Set not activated with default set.
Cause
While creating the KPI for Data source C_SalesAnalyticsQry_1, the user must assign it to the required business catalog.
Resolution
For CDS View C_SalesAnalyticsQry_1 required business catalog is "SAP_SD_BC_SALES_ANALYTICS"
- Search for an existing business role which contains business catalog "SAP_SD_BC_SALES_ANALYTICS" and assign it to the user role.
OR
- Create a new business role based on business role template SAP_BR_SALES_MANAGER
Refresh and try creating the KPI for CDS View ( C_SalesAnalyticsQry_1 )
Keywords
Manage KPIs and Reports, KPI tile, Smart Business, KPI Design, KPI, Fiori, Launchpad, OData Service, Entity Set, C_SalesAnalyticsQry_1, SAP_SD_BC_SALES_ANALYTICS, Data source, S4_PC, S4_1C , KBA , SD-ANA-2CL , Analytics (Public Cloud) , Problem
Product
SAP S/4HANA Cloud Public Edition all versions