07-12-2017 3:22 AM - edited 02-03-2024 11:24 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.