Tried to use CHECKBOX instead of dropdown and it doesnt list the values

[Former Member]

I tried to use a check box 1 instead of dropdown 1 where my dropdown 1 is cascaded with dropdown 2 and dropdown 3.

The checkbox doesnt return any value list.

Please advice.

[Former Member]

Hi Sini,

I do not know much about WAD and BEx Analyzer, But if i've got this right, you want to set filters according the checkbox selections you make? if you are using check boxes i think you will be able to set only one filter at a time.

Thanks and regards,

Fazith.

[bharathsap]

Hi Sini,

If I got you right, then you are lookin for a checkbox group, where in you can map a member/charateristic and the values will be listed and could be selected and submitted.

Design Studio doesn't have a checkbox group, but only checkbox. That means you need to map the characteristic values to individual checkboxes and trigger event of filter. This is a tedious procedure.

Until we get a checkbox group item or better way of data mapping to checkbox, I would recommend you to use dropdown as an alternative.

Listbox and Radiobutton group is also an option but they can be used to select single values. As the very need for a checkbox is to do multiple selection you can resort to Dropdown or Filter Panel or Dimension Filter Components.

Regards,

Bharath

[Former Member]

Hi Sini,

Checkboxes can have only two values checked and unchecked, i cannot understand the context you in which you want to use the check boxes, could you elaborate the question?

Thanks,

Fazith

[Former Member]

Eg: Characteristic: Brand

I was expecting to get a Brand list when I use a checkbox so that I can do multiple selection (multiple check) of the brand.

I was looking for the same checkbox functionality in WAD and BEx Analyzer.

Is it replaced by any other functionality.

[murali_balreddy2]

I don't think CHECKBOX can have ValueTextList and so no SETITEMS method.

If you don't plan to select multiple items and have a short list of ValueTextList, try RADIOBUTTONGROUP instead. Multiple radiobuttons of the group can be dynamically created this way.

Alternatively, you can use dimension filter which provides checkbox like feature to select multiple values for filtering a dimension.

Sorry, I don't have an answer for CHECKBOX. Maybe future versions can have them.

[Former Member]

Hi Murali,

I have a dimension "line of business" in which There are Electronics and Sports

I have used two check box one is to filter Electronics and another in to filter Sports. When i check Electronic checkbox i am getting correct value of it to the chart. Now when i check Sports checkbox(without unchecking electronic checkbox)  i need to cumulate both values(electronic and sports) and display in chart.

script what i used in electronic check box is:

DS_1.setFilterExt("LINE", "Electronics");

DS_2.setFilterExt("LINE", "Electronics");

Sports checkbox:

DS_1.setFilterExt("LINE", "Sports");

DS_2.setFilterExt("LINE", "Sports");

Could you please tell me how this can be done!!

Thanks in advance

Regards,

Mathivanan

[Former Member]

If you have 2 checkboxes then you should add the same script into both On Click Events, something like this:

// only 1st checkbox checked
if (CHECKBOX_1.isChecked() && !CHECKBOX_2.isChecked()) {
  // set Filter for Data Sources
}
// only 2nd checkbox checked
else if (!CHECKBOX_1.isChecked() && CHECKBOX_2.isChecked()) {
  // set Filter for Data Sources
}
// both checkboxes checked
else if (CHECKBOX_1.isChecked() && CHECKBOX_2.isChecked()) {
  // set Filter for Data Sources
}
// both checkboxes unchecked
else if (!CHECKBOX_1.isChecked() && !CHECKBOX_2.isChecked()) {
  // set Filter for Data Sources
}

To set multiple filter values for data sources (when both checkboxes are checked) see the documentation page 242 (use semicolon between values): http://help.sap.com/businessobject/product_guides/AAD12/en/ds12SP01_user_en.pdf#page=243

Regards,

David

[Former Member]

Hi David,

Thanks for your reply it helps me to get some ideas!!!

I was looking for more simple script for this and i created a local variable and did this. below are my code which works fine

if(CHECKBOX_1.isChecked())

{var test = CHECKBOX_1.getText();}

else

{test = "";}

if(CHECKBOX_2.isChecked())

{ var test1 = CHECKBOX_2.getText();}

else

{test1 = "";}

if(CHECKBOX_3.isChecked())

{var test2 = CHECKBOX_3.getText();}

else

{test2 ="";}

DS_1.setFilter("LINE",[test, test1, test2]);

DS_2.setFilter("LINE", [test, test1, test2]);

DS_3.setFilter("LINE", [test, test1, test2]);

Once again thanks for your valuable reply and for the link!!

Regards,

Mathivanan M

[Former Member]

Hi Mathivanan,

Thanks for sharing your code. I'm glad that my answer helped.

Another way of writing the upper part of your code is:

// initialize variables with default values
var test = "";
var test1 = "";
var test2 = "";
// if checkbox is checked save the text/value from the checkbox in a local variable
// missing else statements means that the value stays the same as previously initialized to an empty string
if (CHECKBOX_1.isChecked()) {test = CHECKBOX_1.getText();}
if (CHECKBOX_2.isChecked()) {test1 = CHECKBOX_2.getText();}
if (CHECKBOX_3.isChecked()) {test2 = CHECKBOX_3.getText();}

Regards,

David

[Arjun_KT]

Thanks David,

It Helps in my requirement  !!!

Regards

Arjun KT