11-01-2016 8:17 PM - edited 02-03-2024 7:05 PM
Hi Experts,
I have created a CDS view and the service got created based on @Odata.publish: true. I am able to see the CDS view in the Create KPI tile and also the service but not the Entity Set.
I have gone through the blog and it is mentioned how to get the CDS view but it did not mention whether we have to perform any activity in SEGW or any specific coding in CDS view. there are similar questions on this subject but there are no specific answers.
Do we have to create the Entity set separately in SEGW. or how is the KPI modeler identify the entity set.
i have checked standard CDS views(example C_OVERDUEPO) and they donot have any configuration in SEGW. but the entity set C_OverduePOResult is available.
The following are the screen shots or the CDS view created.
the following is the screen shot of the service. as shown below in the metadata i am able to see the entity Set Z_CDZ_PODISPLAY but not in KPI modeler.
Hi,
when i add this below default Aggregation , then Entityset is showing in KPI Design(DataSource). - Working fine.
@DefaultAggregation: #SUM
Sample CDS Below:
@AbapCatalog.sqlViewName: 'ZPODISPLAY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'PO DISPLAY'
@VDM.viewType: #CONSUMPTION
@OData.publish: true
define view Z_CDS_PODISPLAY 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
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
See the CDS view creation given here https://blogs.sap.com/2016/05/21/build-chart-and-table-representation-via-analytics-path-framework/
If you follow these directions Entity Set is generated as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I can see entity set in APF, but not in KPI modeler. What could be the reason? Do I have to implement class in the Entity set separately in SEGW?
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.