Skip to Content

Top 5 for every group in SAP Design studio 1.6

Hi,

I have a requirement to show top 5 values for every category in design time. Source for the report is BEx.

My data looks as below:

data.png

For every sponsored prog : I have to show the top 5 sponsored class based on the key figure : Commitments and Actuals

I referred to the below blogs but this was not working in my case.

https://blogs.sap.com/2016/06/14/implement-top-nbottom-n-in-sap-design-studio-using-bial-script/

https://answers.sap.com/questions/217000/top-n-ranking-in-design-studio-by-scripting.html

Could someone please help on this?

Thanks

data.png (35.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 13 at 10:45 AM

    Hi - you can set up the top 5 in the BEx Query and Design Studio should honor it; also see https://blogs.sap.com/2015/11/27/ranking-top-n-in-sap-businessobjects-design-studio-16/

    If these two options don't work please provide more details

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13 at 11:39 PM

    Hi Poojitha,

    In order to achieve your requirement at “design time”, the best approach is to define a Top 5 Condition in your BEx Query as Tammy has pointed out.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded