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.