To be able to update datasets with the same tables at once
As a pro user,
I want the enterprise gateway to update all tables across published datasets on the cloud from the same database,
so that I have the flexibility to publish variable subsets of my database as self-contained unique datasets.
Fahd EL YOUBI commented
I built a dataset that is comprised of factual data such as Marketing, Financials and transactional, etc... They all share the same common dimension such as Accounts, its Contracts, its Organizations and its Customers.
The sales department wants to see all in the same dataset.
The accounting department would like see financials and transactional only.
Given that each department would like to take ownership of their own dataset, we will need to create two different datasets with common data dimension.
So far so good, except when it comes to refreshing the data because we need to set up two different refresh cycles and pretty much update the same data twice.
Why not update the data once because they belong to the same underlying database?