Ranking (Top N) in SAP BusinessObjects Design Studio 1.6
A common question here on SCN is how can I rank in Design Studio? The community has offered options, but now you can do it easily in Design Studio 1.6 at runtime.
Below I am using the new Ready-to-Run template
I’ve selected “Data Discovery and Visualization” ready to run template. Notice on the right of the above it describes the options with this template.
Notice it remembers my recently used queries
Above is the result
To select top 5 budgets, as an example, I select desired characteristic (dimension) and select Filter by Measure
So now I can select the top 5
I select the desired measure
I can also select Bottom N
In this example, I select top 5
The above shows the result – top 5 budgets