Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | Threshold | From Period | To Period |
A | 10 | 201601 | 201601 |
A | 15 | 201602 | 999912 |
B | 10 | 201601 | 999912 |
C | 10 | 201601 | 999912 |
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 |
what is the result you would expect from matching these identical tables?
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
have a look:
this is better: