Forum Discussion
Using reference dimension as a slicer with multiple fact tables
Thanks for the response.
To my knowledge, it won't work if you only have one product table unles there is something I am missing?I wouldn't be able to link it to all three using the same field ProductKey, not with active links. Each of the three fact tables can be used separately and they are detail fact records from the main fact table, which is like a header.
In our world, fact is a row that defines a project and fact A/B/C are different types of associated items against that project which all have product names which are linked by ProductKeys on all three tables. On the reference Product table, there is a ProductKey, Product Name and Product Category. But on the slicer we want to add on the Product Category and for us not to have to change the table the Product Category comes from depending on which fact table we want to filter.
Hopefully that make sense?
Hi elliottriley,
In our world, fact is a row that defines a project and fact A/B/C are different types of associated items against that project which all have product names which are linked by ProductKeys on all three tables. On the reference Product table, there is a ProductKey, Product Name and Product Category. But on the slicer we want to add on the Product Category and for us not to have to change the table the Product Category comes from depending on which fact table we want to filter.
Based on my understanding, there is one dimention table listing unique Products and three fact tables in which fields are formatted as such a hierarchy ProjectName -> Category -> ProductName. There existing a one to many relationship from dimention table to each fact table. That case, you just need to drag the Product Category from dimention table into slicer, the records of three fact tables will be updated according to the slicer selection.
If I have something misunderstood, please post sample data of the product dimention table and each fact table, including table structure and detailed records. Also, show us the desired output to make the description clearer. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu