Hi Akshay, I would like to recommend that you take a look at User Data Filters (UDF), also referred to as user data permissions or row-level security, allow you to restrict data that are available for specific users in specific workspaces.
By setting a UDF, you can define what subset of the data in a workspace will be available for individual users or user groups.
As opposed to
workspace data filters (that point to a specific column in a specific table), user data filters use
MAQL expressions. This offers you more flexibility in creating complex conditions because UDFs are applied to any connected data rather than specific database columns.
More details can be found here:
https://www.gooddata.com/docs/cloud/workspaces/user-data-filters/
Or perhaps better for your particular use-case might be Workspace Data Filters (WDF) which allow you to limit the data available in child workspaces. By setting a WDF, you can define what subset of the data from a parent workspace will be available in its child workspaces. For example, a parent workspace may contain a visualization displaying the data from all company departments, but a child workspace will see only the Sales department-related data in this visualization.
Child workspaces inherit the WDFs from their parent workspace the same way they inherit any other entity through the
workspace hierarchy.
More details on this can be found here:
https://www.gooddata.com/docs/cloud/workspaces/workspace-data-filters/