Single Date column with slowly changing dimention.

lylererger — Tue, 03 Dec 2013 17:00:05 GMT

Hi friends.
I've got some problem.
Help me to solve it.

I've got a single Date column and I know that's DateFrom, i'm searching for DateTo.

Some peace of my script:

_____________________________________________________________________

[temp]:

LOAD

Date,

SalesPoint,

Manager

FROM

[$(vData2)\ManagersHistory.qvd](qvd)

Where Date>MakeDate(2013,1,1);

[temp2]:

LOAD

if([Date]=Peek([Date]) and Manager=Peek(Manager),'???',date(Now())) as DateTill;

LOAD

Resident temp

Order by

Manager,

Date desc;

DROP Table temp;

___________________________________________________

??? - I have no any Idea how to get date for those Manager.

For example, as we look above:

For the SalesPoint - X and Manager Y with DateFrom (01.02.2013) i need the Manager Z with DateFrom

(01.04.2013), DateTill should be for Manager Y. For the SalesPoint - X and Manager Y with DateFrom (01.02.2013)

For the SalesPoint - X and Manager Z with DateFrom (01.04.2013)

i need the Manager W with DateFrom (01.05.2013), DateTill should be for Manager Z..

And so on...

Pleace help me with that.
Thnx.

Re: Single Date column with slowly changing dimention.

hic — Tue, 03 Dec 2013 17:05:23 GMT

I think you should take a look at the two following blog posts. I think they are relevant to what you want to do.

HIC