Skip to Content
0

Lumira designer get top/bottom 10

Jan 19 at 08:36 AM

356

avatar image
Former Member

Dear all.

I need to show top/bottom 10 of a dimension,And I can realize it if I action as follow picture.The datasource will auto to get top/bottom 10. But I can't understand it,where I have set top/bottom filter in designer ? and I haven't find reference component to change this datasource.Or just it can realize in discovery?

Waiting for your help.

Thanks.

Jing

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jan 19 at 10:38 AM
0

Hello Jing - maybe it's me, but your first screen shot looks like it is from Lumira Discovery?

I assume with Lumira Designer at run time you can select following these steps - https://blogs.sap.com/2015/11/27/ranking-top-n-in-sap-businessobjects-design-studio-16/ - but I haven't tried it with the recent version - I will try that soon, depending on work demands

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tammy!

I tried your link and can't build the solution in Lumira Designer 2.1 (

https://blogs.sap.com/2015/11/27/ranking-top-n-in-sap-businessobjects-design-studio-16/).
I am urgently seeking a solution to the problem of rank. In the meantime, have you been able to solve this for yourself?
Will the rank function come back with version 2.2?

Currently we have only found a solution for us via scripting, but this is not the optimal solution.
Chart Type: Bullet Chart
DS = Hana / CalculationView

0

Hi - I don't use HANA, so I am not sure. As for 2.2 I have no details other than there is an upcoming webcast What’s new in SAP Lumira 2.2

0
Tammy Powlas
Jan 19 at 11:07 AM
0

For me this worked as expected; right click on the dimension (my example is Product Group) and select Rank

I enter bottom 2


jing1.jpg (28.4 kB)
jing2.jpg (10.7 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tammy.

I‘m sorry I haven't made it clear.My first screen shot comes from Lumira discovery.

And Maybe I have got what you said.But as comments that you linked blog,Whether can I use script to set top N/bottom N.As your blog,I can just in crosstable realize top N/bottom N.But in most 3/5000 scenario,we are used in column/bar chart ,and our customer also want to get top/bottom N immediately when open a report.

Can I realize it?

Thanks.

Jing

0

Hi Jing - I am not sure it can be done via script

The only way I know for sure is if you set up the BEx query to capture top n/bottom n - then Lumira Designer should automatically open the report that way

0