Hate to bump but getting close to deadline and I still have no idea how to do this one.
Basically all i want to do is use a value in all of my dimensions that comes from a reference table that has a date range.
I want to use the SPARSE lookup method but it doesn't seem to have any way of selecting from a specific date range.
Neither of these examples help that much.
I understand how the lookup function works but what happens if the lookup table has the following two rows:
EFFECTIVE_FROM EFFECTIVE_TO SECTION SCORE
01/Jan/1900 30/Jun/2013 test 1
01/Jul/2013 06/Jun/2079 test 2
I need to use the following lookup rules:
Business_Date >= Effective_From
Business_Date <= Effective_To
Section = 'Test'
The lookup should therefore only ever return one row as the date is used to find the appropriate range.