Hi
We have datamarts built and there is a Finance DM coming soon. However there are other teams who require Fin data in their report while Fin team do not want to share all data to all teams and they have rules on who should see what. Below are the suggestions what we have
1. Build Finance datamodel (dataset) and apply RLS and make it as shared model so that other teams can see only data what they want based on the Fin dataset. The only disadvantage what i see here is, Fin DS can have 40 tables. Even if other teams need only one Fin table, they may need to use the entire model
2. Share only that table to the other teams and they will apply RLS for that table. The other teams developers will be able to see all data but end users may not (though this is not recommended by the Fin team. They do not want anyone to see all data)
3. Have dataflows so that they can have RLS and Fin team can apply RLS and share individual tables to other teams. If other teams need Fin DS they can have the complete DS also. But Dataflows do not have RLS.
Do you have any suggestions as to how to handle the pros and cons or any other options..
TIA.
