Hi team,
Two fold question here.
1. Am I able to have attributes that repeat across the LDM be filtered together?
i.e a dashboard contains two visualisations pertaining to a Tourism Region in Dataset A, and the same Tourism Region in Dataset B.
I would like to be able to filter on both Tourism Regions in both Datasets/Visualisations in the single dashboard using one single filter.
For context, this problem extends out across many aggregation attributes including things like Suburb, State, Local Government Area and more, so it is not just the Tourism Region I am looking to filter across multiple datasets here.
2. In extension to this, are repeated attributes across different datasets of an LDM considered bad practice? The use case is that i have aggregate tables that represent different aggregations of data from much larger raw/source tables.
I don't see a world where combining the aggregate tables into one aggregate table with all the aggregations together being possible, one due to inaccuracy of the aggregations and two due to computation speeds/costs of doing this for our business.