Date

[smilingjohn]

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

[prma7799]

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 .

[Anil_Babu_Samineni]

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

[prma7799]

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....

[smilingjohn]

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

[prma7799]

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

[smilingjohn]

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

[Anil_Babu_Samineni · Accepted solution]

I worked around 19 Fields which has different source with different data formats. Try this?

Using Multiple Dates With Master Calendar

[prma7799]

As Suggested by Mr. Anil please check

Using Multiple Dates With Master Calendar

[effinty2112]

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