on 01-07-2011 10:14 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.