Linking two fields with two different calendar

[raju_salmon]

Hi,

I have two DateID fields (in Fact table) where i need to map both ID's to different dimension tables available.

FACT:

DateID_Local,

DateID_TimeZone,

Fact1,

Fact2

DateTimeLocal:

DateID_Local,

Date,

Month,

Year etc

DateTimeTimeZone:

DateID_TimeZone,

Date,

Month,

Year etc

My requirement is to link two calendars to provide filter (always one selected value either  DateTimeLocal or DateTimeTimeZone)... here i cannot able to concatenate these dim tables, because i need to link to two different UID field from Fact table.

Anyway to achieve the requirement?

Thanks for time.

[sunny_talwar]

Not sure I understand but are you wanting to have a single date (or other date related fields) control both these two dates field? Try this -> Canonical Date if that is what you are looking for.

[raju_salmon]

Thanks Sunny... My requirement to map two different calendar tables to two different Keys in Fact...

Since i am going to show month and year list box, i am looking to concatenate the both calender's...

I will check the above link.. thanks...