Hi Team, I’m applying a workspaceDataFilter using...
# gooddata-cloud
v
Hi Team, I’m applying a workspaceDataFilter using the column organizationId, which is present in a dataset named warehouseOrganization. There is another dataset, warehouseCompanies, that does not contain the organizationId column directly. However, the two datasets are connected through a one-to-many (1:N) relationship. Given this setup, I’d like to confirm: Will the workspaceDataFilter applied on warehouseOrganization.organizationId also apply to the related records in warehouseCompanies? Appreciate your insights on this.
👀 1
j
It will apply only in case warehouseCompanies are inner joined with warehouseOrganization in a query so not always. If you need to apply WDF always, you need to add organizationId column into warehouseCompanies as well and add mapping rule for WDF in logical data model.
v
ok Thanks, Jakub
j
You can also do so using
wdf__
prefix on this column in your database to avoid unnecessary duplicity in your analytics. The attribute wouldn’t be visible or usable in analytics diretcly, it will only serve for workspace data filters purpose. Feel free to check the below doc: https://www.gooddata.com/docs/cloud/workspaces/workspace-data-filters/#how-workspace-data-filters-work
Or alternatively, you can use User Data Filters: https://www.gooddata.com/docs/cloud/workspaces/user-data-filters/ UDFs are distributed through the LDM connections and don’t have to be necessarily set on dataset level. However, these are applied on specific users or whole user groups