"Failed to Load Metadata" Error in Create KPI --> Entity Set

[Former Member]

Hi All,

In the FIORI Launchpad Designer (KPI Modeler Screen), when trying to create a new KPI Design, as shown below,

Getting error: "Failed to Load Metadata" when the Entity Set is being assigned as shown below.

1) All the necessary Roles are assigned to this FIORI user such as : SAP_BR_ANALYTICS_SPECIALIST, SAP_BR_PURCHASER and SAP_BR_BUYER

2) The CDS view in the background is a standard CDS view: C_OVERDUEPO and OData Service /sap/opu/odata/sap/C_OVERDUEPO_CDS is also published.

Kindly Suggest.

Thanks,

AK

[lgonzalezc]

Hi

You may try refreshing metadata in /iwfnd/maint_service or checking errors in /IWFND/ERROR_LOG in your gateway system. Maybe model changed and has some error to review.

Regards

Luciano

[sudhir_vanap]

Hello,
We are also facing same Issue and below are screenshots from maint service t-code where we are able to see metadata.

And below is the error in Fiori while trying to create the ALP:

And below is our CDS view:

@AbapCatalog.sqlViewName: 'ZSQL_KPI'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Ex CDS for KPI'

@VDM.viewType: #CONSUMPTION

@OData.publish: true

define view ZKPI_TILE as select from ekko as Poh

inner join ekpo as poi on Poh.ebeln = poi.ebeln

{

key Poh.ebeln as ponumber,

poi.werks as plant,

Poh.bukrs as companycode,

poi.mtart as MaterialType,

poi.matkl as MaterialGrp,

@DefaultAggregation: #SUM

poi.netwr as Value

}

OData , SAP Fiori for SAP S/4HANA ,