Using input Control values

[Former Member]

Hi All,

please help I want to get the input control value and use it in a report heading.

for intance I have input control on Profit Center if the user selects a certain profit center I would like to use that value as the report heading.

I am using webi 4.2 as a reporting tool

[rajan_burad]

Hi Thato,

Create a variable for that dimension for which you want to have Input Control.

Now assign that variable to input control and also in the heading part.

Now whenever you'll select any value from input control that same will be displayed as your report heading.

NOTE: If you don't select any filter from input control you'll have #MULTIVALUE error so to eradicate that in report heading mention this condition:

=If (Count([Dimension])>1) Then "'Select only one value" Else [Dimension]

Let us know if it works!

Thanks,

Rajan 🙂