0 Replies Latest reply: Nov 10, 2015 5:21 AM by Arjan IJlenhave RSS

    2 facts with different jobdate --> Set analysis?

    Arjan IJlenhave

      Hi all,

       

      I have the following issue

       

      Fact1 is the head fact table with a linked DimDate dimension see below.

      I want to create a straight table object that compares Amount_fact1, Amount_fact2 and Amount_fact3 bases on de date selection in the DimDate dimension. Can I solve this with Set Analysis in all the expressions?

       

      Selections: (18-5-2015 - 24-5-2015)

      Year = 2015

      Month = sep

      Week = 21

      Product = VPB

       

      Example:

      Best regards,

       

      Arjan