Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to link two Star Schemas?

Hi, I have two similar datasets (Dataset1 and Dataset 2) and I created two separate star schemas. The resulting tables are:   Dataset 1 DimDataset1_Clients DimDataset1_Products DimDataset1_For...
Need Help
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello Anonymous ,

 

when you have two datasets that you want to filter, you should have the same dim tables that are connected to both facts.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Idrissshatila 

    thanks for your rapid feedback!

     

    How can I have the same Dim tables if I have two datasets, two star schemas and starting from the tables below?

     

    If this tables created is wrong, could you please tell me step by step the right method to use? Is there also a video on youtube that explain step by step this problem?

     

    Dataset 1

    DimDataset1_Clients

    DimDataset1_Products

    DimDataset1_Formats

    FactSalesDataset1

    Dataset2

    DimDataset2_Clients

    DimDataset2_Products

    DimDataset2_Formats

    FactSalesDataset2

    Dim_Calendar

     

    Thanks

    • Idrissshatila's avatar
      Idrissshatila
      Super User
      2 years ago

      Hello Anonymous,

       

      it should be something like this

       

      dims

      Dim_Clients

      Dim_Products

      Dim_Formats

      Dataset 1

      FactSalesDataset1

       

      Dataset2

      FactSalesDataset2

       

      Dim_Calendar