I haven't implemented this yet, but am trying to think through how it would be set up.
Say there is a typical data model for a service busines - a dashboard set up based on a service history table linked to an employee dimension table and a customer dimension table. Next we want to survey customers to rate our employees on service quality (excellent/good/fair/poor). There might be multiple individuals at a customer (company) rating employees.
The end-result is that the dashboard would have two slicers so that you would see the customers who have given an employee a particular rating, along with some existing measures. But as the survey results would be another fact table, what would be the advisable technique to allow for filter according to rating?
Say there is a typical data model for a service busines - a dashboard set up based on a service history table linked to an employee dimension table and a customer dimension table. Next we want to survey customers to rate our employees on service quality (excellent/good/fair/poor). There might be multiple individuals at a customer (company) rating employees.
The end-result is that the dashboard would have two slicers so that you would see the customers who have given an employee a particular rating, along with some existing measures. But as the survey results would be another fact table, what would be the advisable technique to allow for filter according to rating?
