sap lumira designer replace measure value

So while preparing food, we think of preparing 3 to 4 items or even more or less. While we enter the kitchen premises inside our house, our first intention is to 'PREPARE' the food. So now i want to relate this Food preparation with SAP Lumira tool. Every one of us like to eat food as it gives us energy and few of us even have a hobby or passion to cook and call some one and offer them the food that they have prepared. Attached files contain the scripts for reference.To understand the concept of SAP Lumira or i can say that to get a overview of lumira before starting this blog i want to give an illustration so that all of who view this can easily understand the concept and followed by it you can get an interest for working in Lumira. The screen shot below shows the result for Top 8 Countries by Sales.Īt the end I would definitely recommend you to use the Top/Bottom N feature from the back end.īack end in the above example is SAP BW. The screen shot below shows the result for Bottom 5 Countries by Sales. The screen shot below shows the result for Top 5 countries by sales, after making changes in the selectors above and applying it to the data source using the script. The chart always shows the Top N/Bottom N items and for reference the table below shows all the data with a rank for each member.

Here are a few screen shots of the application in runtime. Members.forEach(function(element, index) ).value Var members = DS_1.getMembers('ZPRDCT', 100000) Now in the On Startup event we can write the following script to open the report to show only the Top 5 products by sales on initial load by default. In the following example “0MEASURES0000000000000009_Formula1” is the Rank Measure created and used.Ĭreate Rank in Initial view of the data source You can add the Rank Number for the measures in the source query (back end) itself and then create a data source on this query. The dynamic calculation feature was added in the Design Studio 1.6 release. We need to add a dynamic calculation on the desired measure and select Rank Number. For simplicity the example here demonstrates Top 5 and Bottom 5 for a dimension and measure combination.Īfter we create a data source in an application we have the option of creating simple calculations in the data source. Using this method, it is also possible to display the total of the selected measure for the top N members of the selected dimension. The best way recommended and many will agree is to have conditions in the back end to handle the Top/Bottom N requirement.īut, just in case if you still need to do it in Design Studio, here is one way to implement Top N or Bottom N using BIAL script for any combination of a dimension and a measure. Many people ask whether this Top N or Bottom N is possible by default or in Design time or in script. We know now we have Top N and Bottom N feature in Run time in the context menu of the Cross tab as Filter by Measure.

Sap lumira designer replace measure value