Hi,

May I know whether is it possible to create a workbook which contains multiple pivot tables and cube functions that are using the same offline cube data connection?

This is because when I tried to add a new pivot table and cube function into the workbook, I will get error message "Offline OLAP cubes cannot be created when multiple items (Cube Functions, Pivottablesl, Filter controls) share the same connection.


The reason I ask this as I am trying to create a template report which will use an offline cube. This offline cube will be send to the user whenever there is a new updates to it.

Please help.

Thank you!