Forum Discussion

CJ_96601's avatar
CJ_96601
Helper V
6 years ago

DATA MODEL

Hello, 

 

I have 4 facts table and have this model as follows:

 

  Table 1                                     

  Key Index

     - Emp No

     - Hire Date

     - Termination Date

 

Table 2

Key Index

   - Emp No

   - Date

 

Table 3

Key Index

   - Emp No

   - Date

 

Table 3

Key Index

   - Emp No

   - Date

 

Calendar

  - Date

 

below is the diagram for easy understanding.

 

 

 

My question is how can i link table 2 [date] , table 3 [date]  and table 4 [date]  to calendar[date] keeping star schema model.   

 

Or is there a way to do measure keeping table 1 related to calendar and not table 2,3 and 4?

 

Thanks for your help.

 

Regards, 

 

 

11 Replies

  • camargos88's avatar
    camargos88
    Community Champion

    Hi CJ_96601 ,

     

    Can't you just use 1 Emp table (append them)... 

    Also, why do you need those 3 tables, once you have the data on table 1 ?

     

    Ricardo

    • CJ_96601's avatar
      CJ_96601
      Helper V

      Hello camargos88

       

      Thank you for your response.

       

      Tables are from our ERP via ODBC.    I tried append but refresh takes forever.

       

      Is there any other solution, until append is fix.

       

      Regards, 

       

       

       

       

       

       

  • jstorm's avatar
    jstorm
    Resolver III

    Post a screenshot of your 'Model' tab in Power BI.