Forum Discussion

JoseAGonzalez's avatar
JoseAGonzalez
New Member
3 years ago

Getting two different date with one relationship

Hi everyone,   Issue: I have a report to present inventory at launch date (ICW) and sales over the next three months (Service Months). When I see the inventory and filter with Fiscal Year/Month sli...
Need Help
Tutorial Requests
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
3 years ago

Hi JoseAGonzalez ,

 

You need to connect both of your tables to Date Table to get your requirement

  • JoseAGonzalez's avatar
    JoseAGonzalez
    New Member
    3 years ago

    Hi mussaenda,

     

    This would create a circular relationship, and by default I can only have one relationship active. This is why I tried USERELATIONSHIP (to select the new Date relationship) but without sucess.

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      3 years ago

      hi JoseAGonzalez,

       

      I understand that.

      And I assumed  that you will remove the relationship between the two fact tables and relate them both to the date.

      • JoseAGonzalez's avatar
        JoseAGonzalez
        New Member
        3 years ago

        Hi mussaenda ,

         

        I have basic information of the products on the inventory table and also particular inventory data I need when reflecting sales. By having the conection through Date I lose this relationship and results showed are not accurate.

         

        I would try to reshape data and have 4 tables to see how it hows in the mean time.