Question Re: Webi: Dynamic Multi-Select Input Control in Technology Q&A

Webi: Dynamic Multi-Select Input Control

jonathan_g1 — Thu, 13 Jul 2017 19:37:42 GMT

How are dynamic multi-select input controls created?

The goal of this piece of the report is to have a multi-select input control (such as the checkbox) drive whether or not a few measures are included in a calculation.

I did check this document here: https://blogs.sap.com/2015/12/03/dimensions-as-input-control-dynamic-control/
However, that is focused on a single-select input control.

Let me state the goal using a fictionalized example.

If I have three 4 choices of gum flavors: Cinnamon, Spearmint, Peppermint, and Watermelon, I want the user to select which flavors will be accounted for in a calculation. Let's say it is for # of packs sold per week. If Cinnamon and Spearmint are selected, then just those two numbers will go into the calculation. We do not have an object that has these flavors listed in it.

1. Creating a string dimension to base the input control after:

*I am not sure if this first input control is correct, but only using one string value, such as ="Cinnamon" resulted in the next step not allowing for selecting a multi-select input control.

2. Set up the multi-select input control:

3. Created a custom list of values (List of Values ...)

The result of the input control:

4. Next, I created a dimension to capture the user's input, using ReportFilter([ObjectName])

5. Adding a table and selecting a couple of flavors results in no values being displayed:

6. Created a formula to test if it would return a 1 if cinnamon is selected. The result here is 0:

So at this point I am stuck, as I do not know how to utilize what the user has selected.

Thanks in advance for your ideas.

Version: BI Platform 4.1 Support Pack 5

Re: Webi: Dynamic Multi-Select Input Control

jyothirmayee_s — Thu, 13 Jul 2017 20:49:22 GMT

Hi,

1. Your "Flavor Input Control" formula should be " " instead of values in there

2. Create a custom list within Input Control wizard.

3. Use Reportfilter([Flavor Input Control])

this link might be helpful

https://wiki.scn.sap.com/wiki/display/BOBJ/Creating+a+dynamic+report+using+Input+Controls

Thanks,

Jothi

Re: Webi: Dynamic Multi-Select Input Control

jonathan_g1 — Thu, 13 Jul 2017 23:45:45 GMT

Thanks for the reply.

I updated the Flavor Input Control to = " "

Then rebuilt the input control. It now only allows for a simple selection input control:

This results in only being able to select one value. The goal is to be able to use a multi-select checkbox.

Re: Webi: Dynamic Multi-Select Input Control

Abhilasha — Fri, 14 Jul 2017 08:56:48 GMT

Hi,

In the above screenshot I see that in FIlter operator you have selected "Equal to".

So instead of that select option like "IN" or "In List".

Equal to will only take single value.

-Abhilasha

Re: Webi: Dynamic Multi-Select Input Control

jonathan_g1 — Fri, 14 Jul 2017 15:09:14 GMT

That is correct, Abhilasha. With simple selection input controls, only "equal to" is allowed for the operator. You might see that when the variable that is used to create the input control is just a single string, such as = " ", only the simple input control is allowed. Is it possible to create a dynamic multi-select input control?

Re: Webi: Dynamic Multi-Select Input Control

jyothirmayee_s — Fri, 14 Jul 2017 16:36:51 GMT

Hi,

May be you can try this to get multiple values selected which are dynamic.

=If (RowIndex() =1) Then "YES" ElseIf (RowIndex() =2) Then "NO"

Thanks,

Jothi

Re: Webi: Dynamic Multi-Select Input Control

jonathan_g1 — Thu, 20 Jul 2017 23:10:38 GMT

Thanks Jothi. It is unclear to me how or where to use that row index formula.

Re: Webi: Dynamic Multi-Select Input Control

kohesco — Tue, 25 Jul 2017 13:56:00 GMT

hi,

if you select cinnamon and spearmint you will have to be able to see: "cinnamon;spearmint" like this concatenated in one string.

to show the values, do not use reportiflier() formula, just use your variable in the table .. other aspect can you check if the input control is set to whole document?

Re: Webi: Dynamic Multi-Select Input Control

jonathan_g1 — Wed, 02 Aug 2017 14:24:01 GMT

Ok, so far I have not been able to figure out how to get a variable to show the items selected. Regarding the input control, it is set to that specific tab, since apply to whole document is not available in the version of BOE that we are on (Version: BI Platform 4.1 Support Pack 5).

Re: Webi: Dynamic Multi-Select Input Control

kohesco — Thu, 03 Aug 2017 06:44:37 GMT

if you add the variable flavor input control to your table/result and you play with your input control, you must see the variable showing the values your selected

Re: Webi: Dynamic Multi-Select Input Control

mhmohammed — Thu, 03 Aug 2017 12:12:38 GMT

Hi Jonathan,

You can't use a Multi value select input control with Custom LOVs, I've BO 4.2 SP2, and the option to create Multi value select input control is grayed out as soon as I begin creating an input control on a dummy variable which I created to capture the value selected.

So, the workaround may be to have Custom LOVs as below, and you'll have to calculate by using substr to find which values were selected (as an LOV will have multiple values in an LOV)

Custom LOVs:
Cinnamon, Spearmint
Cinnamon, Spearmint, Peppermint
Cinnamon, Spearmint, Peppermint, Watermelon
Spearmint, Peppermint, Watermelon
Peppermint, Watermelon
and so on, this looks ugly though!!

So, a better solution would be to bring these values from another data provide like excel, that way have a dim object for them, and when we create an Input Control on that object, we can select multiple values.

Thanks,
Mahboob Mohammed