cancel
Showing results for 
Search instead for 
Did you mean: 

Workbook having same query in multiple sheets

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

bharathsap
Employee
Employee
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member182516
Active Contributor
0 Kudos

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?

Former Member
0 Kudos

-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

former_member182516
Active Contributor
0 Kudos

Hi Kaur,

So its better to create separate DP for each sheet.

Regards

KP

yasemin_kilinc
Active Contributor
0 Kudos

Hi Kaur,

You need seperate dataprovider. Because if you use same dataprovider when you navigate or filter one characteristic in all sheets same will be applied. You can try and see.

Regards

Yasemin..

umashankar_poojar
Active Contributor
0 Kudos

Hi Kaur,

         Why don't you try creating a query views for each (5 variations of same query) and save as query views. Then attach these views to 5 sheets, transport both views, query and workbook.

         Performance wise this works better than creating 5 DPs.

Thanks,

Umashankar

yasemin_kilinc
Active Contributor
0 Kudos

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...