Question Re: Using input Control values in Technology Q&A

Using input Control values

Former Member — Thu, 15 Nov 2018 10:18:35 GMT

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

Re: Using input Control values

rajan_burad — Thu, 15 Nov 2018 11:04:05 GMT

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 🙂

Re: Using input Control values

kohesco — Thu, 15 Nov 2018 14:45:42 GMT

just create a table - insert your "profit center" dimension and set your input control to interact with that table.

You can format your table like something cool, set it as a horizontal table: change header, set some horizontal spacing at your table, add an selection image in the header removeheader text

Re: Using input Control values

yorur_oz — Fri, 16 Nov 2018 09:56:31 GMT

Hi Thato,

You can use ReportFilter function:

=ReportFilter([Your Input Control Object])

reportfilter.jpg

Re: Using input Control values

Former Member — Fri, 16 Nov 2018 13:24:17 GMT

.. Right