Use a masterDateDimension table to link to more than 1 field

[#1]

Is it possible to link different fields in the same fact table (like orderdate and deliverydate) to the same masterDate table?

I'm trying to load a starscheme into qlikview, but don't suceed to link both dates to the same table without having either:

• having a circle reference
• or duplicating the table

How is this solved?

[Gysbert_Wassenaar]

See this discussion.

[rwunderlich]

See also

"Using Common Date Dimensions and Shared Calendars" at http://robwunderlich.com/tutorials/.

-Rob

[nirav_bhimani]

Hi,

See the below Thread:

http://community.qlik.com/message/301488#301488

Regards,

Nirav Bhimani