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
