Symptom
- User is 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
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 , CA-GTF-SB-S4H-DT , SAP Smart Business S4H - Design Time , Problem
Product
SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions