Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have multiple date fields coming from different table ......
in such kind of scenario can i crate create master calendar and connect all the date fields
Will this work properly ?
Thanks in advance
I worked around 19 Fields which has different source with different data formats. Try this?
Using Multiple Dates With Master Calendar
Yes you can ...
You have to build your data model using Concatenation after that you can take Dates from your data model to create master calendar .
Yes, It is and Make sure, you must load different times for that dates and concatenate them then use Same Field Name. Off course, Here master calendar can work like charm if you follow same and used same field for that
Like below
DATE:
LOAD
MIN(Date) AS MIN_DATE,
MAX(Date) AS MAX_DATE
Resident (Your concatenate fact table );
LET vDataMax= PEEK('MAX_DATE','0','DATE');
LET vDataMin= PEEK('MIN_DATE','0','DATE');
MasterCalendar:
Script....
Hi Anil
Thanks for the reply ....
consider an exmaple shown below i have three tables if i connect using Date then there will be sysnthetic keys formed
how do i deal with this ? can u please explian me how do i deal with master calaendar in such scenario?
TableA:
Date
CstmID
Dept
TableB:
Date
CstmID
HR
TableC:
Date
HR
Employee
TRY like this
TableA:
Date
CstmID
Dept
'Dept' as Flag
Concatenate
TableB:
Date
CstmID
HR
'HR' as Flag
Concatenate
TableC:
Date
HR
Employee
'EMP' as Flag
Hi PM ,
it was just a exampl i will be having many fields in realtime scenario anf concatenating may not be right way of doing this....
Can i have different deffirent madtercalendar ?
I dont understand this how to do
I worked around 19 Fields which has different source with different data formats. Try this?
Using Multiple Dates With Master Calendar
As Suggested by Mr. Anil please check
Hi John,
You should consider multiple calendars. In the app I use most often I have three, for Order Entry Date, Due Date and Invoice Date. This pic shows part of the data model.
cheers
Andrew