Skip to Content

Re-use of data sources over several sheets

Hi all,

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,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2015 at 10:37 AM

    If I right-click on the crosstab and select copy in the Components tab and insert it to a new sheet, it is retaining the filters.  Maybe you can share screen shots of how this is not working for you?

    Add comment
    10|10000 characters needed characters exceeded