0 Replies Latest reply: Apr 20, 2017 12:03 PM by Виталий Чуприна RSS

    Data model

    Виталий Чуприна

      In my data model I have two facts table, every table has own date field. I need to create chart that should show data from each table on one time axes. Originally those tables was linked by Item - Warehouse key, but when I created link table I found that in this case I will have incorrect data because one Item-Warehouse combination can have more than one row with data, so I created key based on three field Warehouse, Item and Date

       

      Item Warehouse Quantity                Item Warehouse Date Quantity

      1111  US1           10                           1111  US1          20170401  2

                                                                1111  US1          20170402  5

                                                                1111  US1          20170311  3

       

       

       

      Link table also contains type(table1 or table2 ) and calendar.

      My problem: when I use such key I can build necessary chart , but this key cut part of data from second table.

      For example:

      Dimension is Transaction and I want to show sum of Table2.Quantity. If I use ItemWarehouse I see all data, but if I use itemWarehouse Date I see only piece of data

       

      Simple example

      2017_04_20_18_50_59_Scrap_total_fitings_housings_another_2016_Read_Only_Compatibility_Mode_.png