on 04-27-2016 11:58 AM
Hi,
I have created a workbook with different queries in BEx Analyzer 7.0
Now when I open the workbook a single variable screen appears with all the dataprovider variables.
But, I need individual selection screen for different queries present in my workbook.
Thanks in advance,
Avinash.
you should filter same infobject on different queries with different technical name variables..
hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Avinash
SAP created a detailed documentation about how to setup and all necessary notes to implement that.
Please, check this wiki:
Single Data Provider Refresh - SAP NetWeaver Business Warehouse - SCN Wiki
Best Regards,
Edward
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use different variables for different queries used in the workbook or
Goto Workbook Settings --> Goto Variables Tab --> and Untick the option Display Duplicate Variables Only Once.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sucheta,
Thanks for your reply.
The settings which you have proposed will get all the dataprovider variables on a single variable screen.
But my point is, Suppose I want to execute the query which is in the 1st tab alone. So, the variable screen which appears contains all the dataprovider variables.
Hence, I can't get a variable screen which contains only the variables for 1st tab & If I execute this the whole workbook gets executed.
And more over I have checked "Allow refresh of individual queries". But it doesn't prompt the variable screen for that query.
Thanks for your help,
Avinash.
Hi Avinash,
In the workbook settings --> under General --> Check the option Allow refresh Function of Individual Queries
Now select the cell on say grid 1 and click on Chnage variable Values, the screen contains only teh variables for the dataproviders assigned to grid1
Hope this helps.
Thansk, Sushma
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.