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

[YanGerzon]

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:

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.

[Ivan-Mirisola]

Hi 101ger,

I believe you are missing some annotation files so the Fiori Template will works as you would expect.

To better understand how templates work with OData services, I highly recommend you to follow the bellow tutorial as I explains the basic concepts involved and then goes deep into the project structure to provide the look-and-feel using just annotations.

https://learning.sap.com/learning-journey/build-side-by-side-extensions-on-sap-btp/getting-started_f...

Hope this helps you creating the necessary annotations on your project.

Best regards,
Ivan

[YanGerzon]

Thank you for the quick reply.

Yes I did do that one.
But that one uses local data files and has a lot of files added automatically.
Its all just different enough for me to not really understand the problem with what i am doing now.

My problem is also kind of strange because the app works fine if i try to import Odata from BYD business Objects Odata since there its just one collection you specify as a service in the initial setup.
The problem with my current case is that the service is a catalogue of entity sets and im not sure why its not working.