cancel
Showing results for 
Search instead for 
Did you mean: 

Re-use of data sources over several sheets

bastian_wormuth
Explorer
0 Kudos

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,

Bastian

Accepted Solutions (0)

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

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?

bastian_wormuth
Explorer
0 Kudos

Hi Tammy,

thanks for your answer, but that's exactly what I do not want: I would like to have one crosstab per sheet, each with a different filter, but all based on the same data source. Not several times the same crosstab.

Regards,

Bastian

TammyPowlas
Active Contributor
0 Kudos

OK - I wonder if a VB script can be written to clear the filters?  Unfortunately that is not my area of expertise, but just a thought.