Skip to Content
0
Aug 09, 2023 at 05:39 AM

Create a basic App that shows report Data in a fiori List Report

101 Views

Hi,

I am trying to create a simple app in SAP Application Studio that will get report data using a SAP BYD Odata Query of a report.
I used a fiori template and i specified the service of SAP BYD reports:
https://my******.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/

When I run the app I get the list report fiori UI but it shows no data and no columns except for ID and TotaledProperties(I dont know why these specifically).
If I run a mock run i do see relevant columns.
The problem might be that https://my******.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/ is the catalogue of all entity sets, meaning of all the reports in my BYD tenant instead of just one of them.
Is there some way to make the app only draw the spcific entity set based on a query of a specific report as oppose to the entire cataloge of reports in BYD, is that necessary to make the app run smoothly?

Is there perhaps some example I can use of an app that does something very similar?
I went through the "Building side by side extensions on SAP BTP" but the app used in that learning journey is different enough for me not to be able to rely on it.

These are the files that were generated for the app:

image.png


contents of annotation file, im trying to bring in the field CGLACCT from the report :

<edmx:Edmx xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Version="4.0">
<edmx:Reference Uri="https://sap.github.io/odata-vocabularies/vocabularies/UI.xml">
<edmx:Include Namespace="com.sap.vocabularies.UI.v1" Alias="UI"/>
</edmx:Reference>
<edmx:Reference Uri="/sap/byd/odata/ana_businessanalytics_analytics.svc/$metadata">
<edmx:Include Namespace="sapbyd"/>
</edmx:Reference>
<edmx:DataServices>
<Schema xmlns="http://docs.oasis-open.org/odata/ns/edm" Namespace="local">
<Annotations Target="sapbyd.RPZ3915BF2ADEB97F67950126QueryResult">
<Annotation Term="UI.LineItem">
<Collection>
<Record Type="UI.DataField">
<PropertyValue Property="Value" Path="CGLACCT"/>
<PropertyValue Property="Label" String="{@i18n>cglacct}"/>
<Annotation Term="UI.Importance" EnumMember="UI.ImportanceType/High"/>
</Record>
</Collection>
</Annotation>
</Annotations>
</Schema>
</edmx:DataServices>
</edmx:Edmx>

contents of i18n.properties file:

appTitle=Test
appDescription=A Fiori application.
cglacct=CGLACCT


The metadata file contains the metadata of all the reports in my BYD tenant.

Thanks.

Attachments

image.png (35.0 kB)