Skip to Content
0

Different OData service for KPI Tile Drilldown to Generic Report

Jul 12, 2017 at 02:22 AM

172

avatar image

I've found the hardest part about designing KPI Tiles is using the same xsodata end point for both the tile and the underlying report; hence this question.

Say I have a tile which has 3 measures I display like as follows:

And when you click on the report, it returns any position changes:

Now I get each of these working fine separately, but if I want the tile to display correctly, I need to always return a single line with 0 for the 3 dimensions below; but when displaying the report, if there's no data, I should return no data.

This could be solved if I could filter the report by removing all rows that have a null value in one of the fields; but that capability is not present (at least in the version I'm running).

In other words; if there are no upcoming changes for a user, the following should return 0's for the Tile:

/ChangeInPositions?$select=StartDate,PositionChangeIn7Days,PositionChangeIn8To30Days,PositionChangeIn31To60Days

and the following should return no entries for the Report:

/ChangeInPositions?$skip=0&$top=100&$select=PositionChangeText%2cStartDate&$inlinecount=allpages

With 2 xsodata services, this would be easy, but it appears the Tile is linked with the same odata service as the generic report that you can generate.

Any ideas to use a different odata service, or how to configure the xsodata service to return different sets of data like this?

Thanks,

Matt

tile.jpg (14.5 kB)
report.jpg (27.4 kB)
10 |10000 characters needed characters left characters exceeded

I think Parameters would help here (e.g. If parameter is set to X, filter out entries with a null value); but I can't seem to see Parameters when clicking the parameter butt in in the drill-down configuration (I've created a parameter in the Calculation View and tested it using SQL):

capture.jpg (15.6 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Murali Shanmugham
Jul 13, 2017 at 04:04 AM
1

Hi Matt,

Its been more than 2 years since I worked on on-premise KPI Tiles. I found a way earlier to invoke two OData services - one for the KPI tile and the other for the actual drill-down report. The way I achieved it was to create two Evaluations for the KPI. Each of the these evaluations would point to a different OData service. The KPI Tile uses the first evaluation and in the tile configuration I remember providing evaluation ID as parameter.

Regards,

Murali

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Murali - With your help, I could unlock the hidden feature of referring to a different Evaluation Id in the Tile Semantic mapping so it calls the KPI Drill down for the secondary Evaluation; hence works a treat now!

capture.jpg (101.1 kB)
0