04-24-2024 04:59 AM
Hi All,
I 'm trying to build a cube view report, it has numerous rows in it, However I need only TOP10 results. Could you please help me how do I select only Top10 results based on the total value?
Assume that it is sales related information, Report has the details about all location sales. However, I would like to see only TOP10 location results (Based on the total sales)
It would be helpful if anyone could assist on this ASAP.
Thanks,
Bharath
04-24-2024 07:09 AM - edited 04-24-2024 07:29 AM
A cubeview is not the best for this sort of requirement. You could, in theory, write a custom Member List that does all calculations and returns the ordered list of members to display, but it feels overkill and it's likely to contain mistakes.
I would suggest the following instead:
A similar alternative is to write a Dashboard DataSet rule that will do the filtering, and again wire it to a Report or BiViewer component through a Data Adapter (of type Method/Business Rule). That's fairly easy if you're familiar with that sort of thing (there are examples on the blog), but if you don't want to write code, the suggestion above is probably the best approach.
04-24-2024 10:34 AM - edited 04-24-2024 10:35 AM
Similar approach using Report Component, which is more print-oriented than BiViewer (you will still need to configure a Data Adapter first):