Skip to Content
avatar image
Former Member

Lumira designer get top/bottom 10

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 19 at 10:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 11:07 AM

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

    I enter bottom 2

    Add comment
    10|10000 characters needed characters exceeded

    • 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