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

/wp-content/uploads/2015/11/1afig_839841.jpg

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.

/wp-content/uploads/2015/11/1figselect_839842.jpg

Notice it remembers my recently used queries

/wp-content/uploads/2015/11/3fig_839864.jpg

Above is the result

/wp-content/uploads/2015/11/4fig_839865.jpg

To select top 5 budgets, as an example, I select desired characteristic (dimension) and select Filter by Measure

/wp-content/uploads/2015/11/5fig_839866.jpg

So now I can select the top 5

/wp-content/uploads/2015/11/6fig_839868.jpg

I select the desired measure

/wp-content/uploads/2015/11/7fig_839869.jpg

I can also select Bottom N

/wp-content/uploads/2015/11/8fig_839870.jpg

In this example, I select top 5

/wp-content/uploads/2015/11/9top5_839871.jpg

The above shows the result – top 5 budgets

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

    1. Karol Kalisz

      Hi,

      in case you are on BW and have BEx conditions defined in the query, then there is a method to

      * list all conditions -> method: getMeasureFilters()

      * activate and deactivate -> method: setMeasureFilterActive()

      of course, for that you have to either:

      * have it defined in the query

      * use Analysis Office and Smart Copy (this one is also for HANA based data sources)

      * use old good Bex Web and define it, saving it as query view

      Karol

      (0) 
  1. Kashif Khan

    Hi,

    can we use ‘Filter by Measure’ in design mode, I want to show Top 10 Customer by default.when report is executed.

    Thanks,

    kashif Ali Khan

    (0) 
    1. Karol Kalisz

      Hi,

      as of today, it is not possible on designtime – this is correct.

      one idea-workaround..

      in 1.6, you can make following.

      * in data source, sort by your Measure descending.

      * take the scorecard component, bind it, define and adjust to have only 10 rows.

      -> now you always will see the top10.

      if you do not want to change pages in scorecard, you can use CSS and make the “Paginator” area invisible by CSS.

      Karol

      (0) 
  2. naveen raju

    Hi,

    i had observed that in crosstab if we enable pixel based scrolling and set row limit to 10 we can display only 10 rows from datasource ,by sorting the DS we can display top N or bottom N. now i wonder if we can take those 10 displayed rows out of crosstab and didsplay in chart..pls give your insights into this

    (0) 
  3. Sreeni Reddy

    Hi,

    If TOP N is static then below code will work.

    var topn=DS1.getMembers(“dimension”,statictopn);

    DS1.setFilters(“dimension”,topn);

    now we can assign DS1 for chart or any other component.

    Please make sure sort function apply in DS1

    (0) 
    1. Mustafa Bensan

      Hi Sreeni,

      By definition a Top N ranking requires a reference to a measure, so I’m not sure how your suggested script would work?

      Regards,

      Mustafa.

      (0) 
    2. Trang Nguyen

      Hi Sreeni,

      I think the way you get members it will return in Alphabetical Order but not in order of the ranking. How does this approach work for you?

      (0) 
      1. Sreeni Reddy

        Yes that’s right Trang Nguyen it is getting Alphabetical order.

        use below code using SDK util package

        Create DATAITERATOR and assign Data source DS1 & Maintain Sorting order in DS1 for measure.

        var rows=DATAITERATOR_1.getRows(0,n);

        var topn=””;

        rows.forEach(function(element, index) { 

        if(index==0)

        {    topn=element.getDimensionValueKey(“DIM”);    }  

        else{    topn=topn+”;”+element.getDimensionValueKey(“DIM”);    } 

        });

        DS1.setFilterExt(“DIM”, topn);

        Thanks,

        Sreeni.

        (0) 

Leave a Reply