Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Opportunity data as shown. Each opportunity has a closed date and a created date. Also a day of quarter.
Oppty Created Dt Closed Dt Created Day of Qtr Closed Day of Qtr
111 1/1/17 31/1/17 1 31
222 1/31/17 2/15/17 31 46
333 1/25/17 1/31/17 25 31
444 2/2/17 2/20/17 33 51
User wants to make 1 selection on a 'Day of Quarter' e.g. 31 and that should give him the 1st 3 rows above.
Is there a way to achieve this?
May be create a link table
Fact:
LOAD Oppty,
Created Dt,
Closed Dt,
Created Day of Qtr,
Closed Day of Qtr
FROM ....
LinkTable:
LOAD Oppty,
Created Day of Qtr as Day of Qtr,
'Created' as Flag
Resident Fact;
Concatenate (LinkTable)
LOAD Oppty,
Closed Day of Qtr as Day of Qtr,
'Closed' as Flag
Resident Fact;
And now select in Day of Qtr field
Is created and closed day of qtr created in script or are they expressions?
They are readily available in the source table.
May be create a link table
Fact:
LOAD Oppty,
Created Dt,
Closed Dt,
Created Day of Qtr,
Closed Day of Qtr
FROM ....
LinkTable:
LOAD Oppty,
Created Day of Qtr as Day of Qtr,
'Created' as Flag
Resident Fact;
Concatenate (LinkTable)
LOAD Oppty,
Closed Day of Qtr as Day of Qtr,
'Closed' as Flag
Resident Fact;
And now select in Day of Qtr field