I have a main workspace that contains all of the data for my company. I have need to allow users to build dashboards and reports for their departments, BUT I can't give them access to the main workspace as it contains all the company financial and employee personal information.

I have tried to create a workspace by using Anaytics as a datasource, but it doesn't carry over the relational table links.

I have tried to create a linked workspace - but it seems to link all of the data, which gives me the same security concerns as above.

How can I create a linked child workspace with only selected tables/reports ?