Skip to Content

How to select multiple key figures in Lumira Designer 2.1?

Hi

In my data source have 4 Key figures(Revenue,Discount,Qunatity,Margin) and I have tried dynamic single Key figure selection using below script,

Application level script:

RADIOBUTTONGROUP_1.setItems(DS_1.getMemberList("[Measures]", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 10));

I have filtered using Listbox:

Listbox on Select script:

DS_1.setFilterExt("[Measures]", RADIOBUTTONGROUP_1.getSelectedValue());

I created succssfuly using above script.

My issue is how to select 2 key figures at a time.

Ex: In Radio Button Group component inserted 2 items like KEY_FIGURES1 & KEY_FIGURES1

How to show Output When I select KEY_FIGURES1 then shows Revenue and Quantity

Whent I select KEY_FIGURES2 then shows Discount and Margin

I tryied below script in Radio button group but no luck,

if (RADIOBUTTONGROUP_1.getSelectedValue() == "A") {

DS_1.setFilter({"[Measures]":["Sales_revenue","Quantity_sold"]}, RADIOBUTTONGROUP_1.getSelectedValue());

}

else

{ DS_1.setFilter({"[Measures]":["MARGIN","DISCOUNT"]}, RADIOBUTTONGROUP_1.getSelectedValue()); }

Please help on this scenario.

Thanks,

Chandrasekhar .K

Add comment
10|10000 characters needed characters exceeded

  • Hello Chandra - maybe you could share some screen shots? On the surface, the listbox should work. Also which version/SP of Design Studio are you using?

  • Hi Tammy,

    Thanks for quick response.

    Tool Version: Lumira Designer 2.1 SP01

    For single key figure selection screenshots:

    In the output, I have select Sales revenue it shows sales data,

    Select Quantity shows Quantity related data,

    Above process developed successfully.

    Now how to select 2 Key figures at a time:

    I need below scenario:

    select KEY_FIGURE1 then shows Sales revenue & Quantity and KEY_FIGURE2 then shows Margin and Discount.

    Plese, help me in the above process.

    Thanks,

    Chandrasekhar.K

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 24 at 10:36 AM

    Hi Chandrasekhar,

    Here are the steps you should take to achieve the desired result:

    1. Create the following Global Variables:

    vKeyFigures1: Type String, Array true

    vKeyFigures2: Type String, Array true

    vMeasuresDimension: Type String, Array false

    2. In the "On Startup" event of the Application apply the following script code:

    vMeasuresDimension = DS_1.getMeasuresDimension().name;
    
    vKeyFigures1 = ['Sales_revenue','Quantity_sold']; // Array of Key Figure 1 Measures
    vKeyFigures2 = ['MARGIN','DISCOUNT'];             // Array of Key Figure 2 Measures
    
    

    Make sure the key figure arrays reference the technical names of the measures.

    3. In the "On Select" event of component RADIOBUTTONGROUP_1 apply the following script code:

    var mySelection = me.getSelectedValue();
    
    if (mySelection == "A") 
    
    	{
    		DS_1.setFilter(vMeasuresDimension,vKeyFigures1);
    	}  
    
    else
    
    	{
    		DS_1.setFilter(vMeasuresDimension,vKeyFigures2);
    	
    	}
    

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded