Skip to Content
0

How to select multiple key figures in Lumira Designer 2.1?

Apr 23 at 06:21 PM

126

avatar image

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

10 |10000 characters needed characters left 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?

0

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mustafa Bensan Apr 24 at 10:36 AM
3

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you so much Mustafa

It is perfectly working.

1