Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I already have the SDC or slowly changing dimension application, but my problem is, how can I show reports depending on selected date,
These are the data:
NameNo | Name | Status | MostRecent | ValidFrom | ValidTill |
10001 | Bill | Married | 1 | 10/5/2012 | 10/5/2012 |
10001 | Bill | Single | 0 | 10/3/2012 | 10/4/2012 |
10002 | Rea | Married | 1 | 10/5/2012 | 10/5/2012 |
10002 | Rea | Single | 0 | 10/3/2012 | 10/4/2012 |
10003 | Ludy | Single | 1 | 10/3/2012 | 10/5/2012 |
10004 | Khen | In Relationship | 1 | 10/5/2012 | 10/5/2012 |
10004 | Khen | Single | 0 | 10/3/2012 | 10/4/2012 |
10005 | Lhai | In Relationship | 1 | 10/5/2012 | 10/5/2012 |
10005 | Lhai | Single | 0 | 10/3/2012 | 10/4/2012 |
10006 | Pye | In Relationship | 1 | 10/5/2012 | 10/5/2012 |
10006 | Pye | Single | 0 | 10/3/2012 | 10/4/2012 |
10007 | Mark | Single | 1 | 10/5/2012 | 10/5/2012 |
10008 | Bamboo | Single | 1 | 10/5/2012 | 10/5/2012 |
10009 | Jhing | Single | 1 | 10/5/2012 | 10/5/2012 |
10010 | Eliza | In Relationship | 1 | 10/5/2012 | 10/5/2012 |
10011 | Kirk | In Relationship | 1 | 10/5/2012 | 10/5/2012 |
10012 | Charm | In Relationship | 1 | 10/5/2012 | 10/5/2012 |
I just don't know how can I show the status if I want to see employee status as of
1. Oct 3, 2012
2. Oct 4, 2012
3. Oct 5, 2012
Will you help me how to show the as of reports?
Thanks,
Bill
Hi Bill,
Here it sounds to me like you could intervalmatch() your calendar to the ValidFrom - ValidTill fields so when a user picks Oct 3rd from the calendar it will match against the ValidFrom-ValidTill ranges that cover this date.
Hi Johannes,
Do you have any idea how to do that? Will you help me doing intervalmatch? Thanks.
Hey Bill,
Try searching the forums. Should be plenty of different examples floating around.
Here's one I found (see John W's post):
Thanks will check that!
Hello Bill,
Check out this
First load the two tables (Ex: Tabel 1 and Table 2) as usual at script area, then link the field (Common) to the intervals defined by the fields Valid from and Valid Till:
Select * from Table1;
Select * from Table2;
IntervalMatch ( Your common field) select Valid from, Valid Till from Table2;
I hope this will help you out, i have just highlightes the overview of intervalmatch.
Thanks
Advait
I have tried doing SCD in hundred thousand rows. It sucks! How can I do SCD having of that kind of records? Any suggestions?
Hi Bill,
Have you found a solution to your problem?
Please shared if you have th solution.
Best regards,
Emteam
Yup Farid, have the solution for this (but it's not really mine, I just modified or add some modification), I hope you can open the attach file, it's like what the actual requirement is.
Hi Bill,
Many thanks for your answer.
i will check it.
Best Regards,
Emteam