4 Replies Latest reply: Jan 26, 2018 4:31 AM by Staffan Johansson RSS

    Please assist with linking data or intervalmatch

    Chris Neumann

      Need to link Threshold Dimension to Fact Data between a Period and BU

      Please assist with script

       

      Fact has data per count/date/period/bu

       

      Fact:

        

      BUThresholdFrom PeriodTo Period
      A10201601201601
      A15201602999912
      B10201601999912
      C10201601

      999912

       

       

      Dimension //need to interval match this by period and bu

       

      Dimension:

        

      BUThresholdFrom PeriodTo Period
      A10201601201601
      A15201602999912
      B10201601999912
      C10201601999912
        • Re: Please assist with linking data or intervalmatch
          Marco Wedel

          what is the result you would expect from matching these identical tables?

            • Re: Please assist with linking data or intervalmatch
              Chris Neumann

              Hi Marco

               

              Sorry the tables copied incorrectly for my question.

               

              Fact has BU / Count Actual /  Period / Date

              I want to have a Threshold from Dimension associated with fact by a From and To period (possibly intervalmatch)

               

              i.e if you sum (Threshold) per BU Dimension for BU A your would see a graph of  10 for 201601 and a change to 15 from 201602 for BU = A

               

              Question should have read:

              Need to link Threshold Dimension to Fact Data between a Period and BU                                            

              Please assist with script                               

                                                          

              Fact has data per count/date/period/bu                                                                          

              Fact:                                                                             

              BU          Count-Actual                     Period                  Date

              A             2                                           201601                 2016-01-03

              B             8                                           201601                 2016-01-04

              C             16                                         201601                 2016-01-05

              A             12                                         201602                 2016-02-03

              B             11                                         201602                 2016-02-04

              C             9                                           201602                 2016-02-05

                                                          

                                                          

              Dimension //need to interval match this by period and bu                                         

                                                          

              Dimension:                                                                                 

              BU          Threshold            From Period        To Period

              A             10                          201601                 201601

              A             15                          201602                 999912

              B             10                          201601                 999912

              C             10                          201601                 999912