SAP Knowledge Base Article - Public

3284583 - User not able to activate OData and Entity Set while creating Smart Business KPI for data source C_SalesAnalyticsQry_1


  •  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



Reproducing the Issue

  1. Go to Manage KPIs and Reports App
  2. Go to KPI tab and Click on Create KPI 
  3. Select the Group
  4. In Define Data Source Details click on Define button
  5. Select the CDS view as C_SalesAnalyticsQry_1
  6. OData Service and Entity Set not activated with default set.


While creating the KPI for Data source C_SalesAnalyticsQry_1, the user must assign it to the required business catalog.


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.


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


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


SAP S/4HANA Cloud all versions