How to Create a single Master Calendar

[#1]

Hi All,

Can you please advise me how to create a Single MASTER calendar for the below data model. All the tables are have own date fields but dates are not common, My output is in front end side if I select Year and Month all the charts are need to display the values .

Regards,

Sunni

[santiago_respane]

Hi,

i recommend you to start from here Creating A Master Calendar

Kind regards,

[marcus_sommer]

I think you will need several calendars and also a canonical calendar:

Canonical Date

Why You sometimes should Load a Master Table several times‌

- Marcus

[#4]

Hi Marcus ,

I have tried to apply the given concept but no use ,nothing will come up  as my expectation . Can you please guide me or provide any one of example so that I can correct it where did I wrong .

[marcus_sommer]

That is definetely not a easy task especially by such a complex datamodel like yours. I suggest that you try to implement it step by step at first with only two single calendars which you then merged into a canonical calendar to understand better how it worked and what is possible then quite probably won't be all wished views possible. A big topic here is if you have for all calendars the right keys and those have then all needed values?

You will need some time to play with these concepts. Here is another one which might more suitable for you: Linking to two or more dates.

- Marcus

[#6]

Marcus ,

I completely agree with you ,it is very hard to implement single master calendar for this type of data model and more over the date filed values are not common.Yes,I have created calendar separateley and merged together and based on that field using to generated canonical calendar but when I selecting the calendar dates charts are behaving strangely 

I am not getting any idea out of it and tried many ways but no luck