Skip to Content
avatar image
Former Member

Map BW Easy Query Key figure to dynamic Fiori Tile?


Hello!

I would like to display a key figure of a BW Easy Query (that I can access via Odata) to my dynamic Fiori tile.

Accessing the Easy Query like this gives the following output

/sap/***/odata/sap/Z*****/<queryname>?$format=json

{
  "d" : {
    "results" : [
      {
        "__metadata" : {
          "id" : "http://<system>/sap/***/odata/sap/Z*****/<query_name>('<parameters>')",
          "uri" : "http://<system>/sap/***/odata/sap/Z*****/<query_name>('<parameters>')",
          "type" : "Z****.<query_name>"
        },
        "ID" : "<id>",
        "TotaledProperties" : "",
        "A0CALWEEK" : "20.2017",
        "0MATERIAL" : "1000005",
        "0MATERIAL__BASEUOM" : "PC",
        "A00O2TPJXEBUT4F4UBQXI2U4EQ" : "71.42857142857143"
      }
    ]
  }
}

I would like to add the value of the key figure "A00O2TPJXEBUT4F4UBQXI2U4EQ" to the Fiori tile.

What Odata Request do I have to configure in the Fiori tile?

If I query the following:

/sap/***/odata/sap/Z******/******/$count

1

The "1" shows up in the Fiori tile correctly.

How can I "navigate down" to my key figure in the Odata query?

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 16, 2017 at 03:25 PM

    Hi, Moritz.

    The standard dynamic tile is expecting a single, numeric result from the odata URL provided in the configuration (i.e. - "$count"). If you want to implement custom text on the tile based on the results of the odata query then you'll want to look into defining a custom tile type. These are based on SAPUI5 views and you can customize them to your needs. You can find information on that here:

    Implementing a Custom Tile Type - help.sap.com

    Thanks,

    Keith Nunn
    SAP Product Support

    Add comment
    10|10000 characters needed characters exceeded

    • Hi, Moritz.

      Could you let me know what URL you tried with the $select keyword? I checked with some BW colleagues and the suggestion was to use the $select keyword but you mentioned that you already tried it. So if you can let me know what the URL was and what result you saw, I can reach out to the BW team again.

      Thanks,

      Keith