Run Variable values out of the "variable values window" in a excel workbook

[Former Member]

Dear experts,

I am working on BI 7.10.

Our workbooks are made of several data providers based on the same query and require many different variable values, which give us a long and unconvenient (for the users) "select values for variables" window (ex : we have a Profit and Loss report to run on different consolidation versions, fiscal years etc...)

So I wonder if there is another way to enter these values, out of this window...(macro?)

Many thanks for your help.

Armelle

[Former Member]

my variables are global for all data providers since I use the same query for my data providers.

It's just the values (some of them : ex: conso version) that differ from one data provider to another.

ex : here for 2 diff Data providers based on the same query i need to enter the following values for mandatory variables

Different versions / different years but same conso group / data entry year/ posting period.

i would like to have the possibility to enter these values out of the "select values for variable" window (not convenient when we have 7 or 8 DP...), but directly in the workbook.

But maybe this is not possible...

In DP1

conso version = A_PL

conso group = FR01

data entry year = 9999

fiscal year = 2010

Posting period = 12

In DP2

Conso version = P4_MAG

Conso group = FR01

Data entry year = 9999

fiscal year =2011

Posting period = 12

[Former Member]

it's not possible, this is why I suggested to remove variables from query

conso version

conso group

(you can copy this query)

and do restriction directly in workbook for every DP

Regards,

DL

[Former Member]

Dear Dariusz,

Thanks for your prompt answer.

I tried to use filtering with dropdown boxes for each data providers but this does not work.

What i want to do is not a filter since the basic query behind the workbook requires 5 mandatory variables values to be run and each variable requires one single value.

So for each Data provider, i have to fix 5 mandatory single values.

[Former Member]

But you can use variable for characteristics which are global for all data providers, and use just filters for those which are data provider relevant. Then In selection screen you will see variable for global setting, and then do local adjustment for every single data provider directly in workbook.

Regards,

DL

[Former Member]

Hi Armelle,

Do you need to input all these values in selection screen?

Can you create filter tab for every data provider?

For example for every tab in workbook, you can creat drill down box for version and year, and then end user will be able to udjust the view himself and save his own version.

Regards,

DL