on 06-05-2013 8:47 AM
Hi,
I am making a workbook which will have 5 sheets in it. All 5 sheets have to get data from same BEX Query. The BEX query does not have any variables.
Do I still need to create multiple DATA PROVIDERS in workbook or I can just re-use same data provider on different sheets with different data-view.?
Please suggest as I think with just one data provider, performance of workbook will be better.
Thanks
Hi Kaur,
I assume that you would want the data in these 5 sheets to be independent. i.e any change made to the grid in sheet 1 shouldn't reflect in the grids in rest of the sheets.
In that case you need to create 5 dataproviders (DP_1, DP_2..... DP_5) and assign them to the grids accordingly.
Talking about performance: Yes, having a single DP will perform better than having 5 DPs.
But, this would mean that if you collapse a hierarchy node in sheet1, then this will reflect in all 5 sheets. If you are fine with this, then you can use a single DP and attach it to the components in all 5 sheets.
Regards,
Bharath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1.Execute the query
2.Insert the sheet for the result of the query and there include the analysis grid in design mode and mapped it with repective query(DP).
3.Change the layout as you needed(i.e different columns) from properies of the query
4.This process repeat for next 3 sheets and save it as workbook
5. Note: as above said no meaning if you maintained same columns in all 5 sheets.
Hope it helps!
Thanks,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why you want to have same data with out any restrictions in 5 sheets? Whats the requirement?
Better to create separate Data providers for each sheet.if at all there are no restrictions used in the sheets it would be better to go with single DP.
But there should be some restrictions without restrictions whats the use of having the same data in all the sheets?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-Only BEX Query has hard coded filters so no variables have been used in Query/workbook.
- The reason for having 5 sheets in one workbook is to have different characteristic in row in every sheet but same key figures in columns. I want to drill down different row in every sheet but from same BEX Query. Is it still possible using ONE data provider as ultimately data is coming from one BEX Query. For Example:
Sheet 1 will have PRODUCT in ROW; COST and SALES as Key figures.
Sheet2 will have REGION in ROW; COST and SALES as Key figures.
----
All these charactristics and Key figures are available in one BEX Query. Still I need to call that one bex query as a separate data provider on every sheet?
Thanks
Hi,
I am very fine with what Bharath explained. Just an addition. If you are planning to add different filters in each tab, after a navigation all your sheets would change accordingly. So it is better to go with 5 dataproviders...
Regards
Yasemin...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.