in order to improve performance I would like to define one data source (based on BEx) for the whole XLS that contains all of my product groups, but display a single product group per sheet.
My idea was to re-use the data source that contains all product groups, copy it to several sheets and filter on one of the product groups on each sheet. So far I haven't found any way to do this, it only works if I add a new data source per sheet and apply a filter on each sheet.
In WebI it's quite simple to re-use a data source in different sheets and to apply different filters on different tables or sheets - is there any way to achieve this in AfO?
Thanks in advance,