Forum Discussion
ShareDatasets between different workspace
Helenaoliveira Yes you would need to replicate the dataset in each workspace. The only way you can centralize a dataset would be to use Analysis Services. You would still need to deploy to each workspace, but any changes could be managed via the central model and deployment to the model would automatically make it's way downstream to all the datasets.
Anonymous thanks for your response but if I create different workspace I will have the same datasets repeated in different workspaces. It makes sense has the same repeated in different workspace?
In my case, the datasets is the sales map with daily update, if I create different workspaces, I will have the datasets salesmap repeated with the respective update.
Helenaoliveira Yes you would need to replicate the dataset in each workspace. The only way you can centralize a dataset would be to use Analysis Services. You would still need to deploy to each workspace, but any changes could be managed via the central model and deployment to the model would automatically make it's way downstream to all the datasets.
Anonymous but it does not make sense to replicate the dataset in each workspace. If I replicate the dataset in several workspace and schedule daily refresh I will overload the system with these daily updates, right?
Helenaoliveira "It depends" - Are you talking about using imported datasets? How large are they, how long do they take to process? Or are you talking about the SSAS solution? In live connection, the dataset is just a passthrough, there is no data stored in the Service.
Anonymous I have a similar problem.
We are trying to connect to datamarts and create a centralized dataset that can be used by various workspaces. How can we do that?
you mentioned we need to take the centralized dataset and replicate that dataset in all the workspaces (if different workspaces are planning to use the centralized dataset). These workspaces will use a subset of the centralized dataset.
Q. Are the subset datasets simply pointers to the centralized dataset or are the replicated copies of the entire dataset.
Q, Can the individual datasets (the datasets used in different workspaces) be locked down as per the permissions?