I mean that we have one Workbook based on one query, but we would like to use a several dataproviders via the "analysis grid", in order to have a lot small boards (tables) filtered every time on one (0Comany) value ==> Static table structure with dynamic data refresh.
The problem is we have a runtime issue, and we would like to know if SAP recommend a MAX NUMBER of dataproviders (not queries) in the same workbook, in order to avoid the runtime issue.
We have to use more than 50 dataproviders (every DP contain less than 10 records), is it a lot for you ?
Other thing, instead our solution (using dataprovider to filter data), do you know another way to have several boards (tables) filtered every time on the same object value (0Company).
In other words, we would like to have one independant board (table) per 0COMPANY value.
Each tab (copy of the query) would have distinct filter value(s). In workbook settings, Uncheck "Allow Refresh of Individual Queries". Also in WB settings, Do Not Refresh at Opening. For the entire 50-tab workbook, the filter is limited to a minimum: company code and the date range because the other filters are hardcoded in each tab. When you refresh and change variable values at opening the file, all you enter is the company code value and the date
You might also want to change the Grid Properties: Uncheck Apply Formatting (for performance); and Uncheck Allow Navigation. You can add these back later. Might as well uncheck Sort.
I have my own question about the DPs. Can you rename them from the generic Data Provider 1 or copy of Data Provider 1?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.