Need a help to create a Master calender

[#1]

Dear,

Community.

I need a help in creating Master calender.

I have 4 main Tables 

1) Organization

2)People

3)Subject

4)Report

one Fact table

all the main tables are connceted by fact table.

                    kindly find the atachement .

and all the main tables contains Date Field ,  so now i want to create a master calender which contain all the dates from all the tables.

Can i use DateIsland ?

thanks,

mukram.

[#2]

Dear,

Community Members

Is their any possibility to keep to calender separate without linking to the model.

but when ever i select like year 2012 i should show all the dataRelated  of that Year,

Thanks,

Mukram.

[giakoum]

Hi

use attached file to create a calendar. Not developed by me, it is available in the community.

use different names in calendar than in tables for the same field (i.e Year could be CalendarYear in calendar) and then set analysis to make the association for example :

sum({<[Year]=[CalendarYear]>} [Sales])

[#4]

Dear,

giakoum

Thanks for your help.

but

some times i need to select day and month .

and defalut selection sholud be 2012.

so some body help me to solve this issue.

Thanks,

Mukram.

[#5]

Hello Mukram,

Try using the possible() function as below:

sum({$<StartDate = P(CalendarDate)>} Sales)

You can select a year, month or any other field from the Calendar and you should get the related records in your tables.