Multiple Datasets to be connected/join like star/snowflake schema

Question & Answer
, ,
1

Hi,

There are 2 dimension tables(Date and Product) and 2 fact tables (Returns and Sales).
I have to connect/join first dimension table with the other 2 fact tables and similarly for the other Dimension table.
I have succeeded in joining one dimension table. But unable to connect the second.

image
image954Ă—246 13.8 KB

Can I implement this?
Thanks

2

You might need to separate this into two datasets and then join those two datasets.

You would create one dataset that joins Date & Product. You would then create a separate dataset that joins Returns and Sales. Finally you would create a dataset that joins the two separate datasets together.

1 Like
3

Hi, @Abhilash_Pandey. We hope Max’s solution worked for you. Let us know if this is resolved. (And if it is, we’d love it if you could mark his answer as a “Solution.”) Thanks!