How to display the Years and months in the master calender that are having data only...

[#1]

Pls anybody let me how how to display the selection for years and months that are having data.how to disable rest of the selection in master calender

[MK_QSL]

For that, dont create master calendar separately

Create Year and Month fields only in the Fact Table directly...

[#3]

If you left join your calendar to your fact then it would display as you require but as Manish said there is no point creating a calendar for that just create the fields directly onthe fact

[djsampat]

Hi Vasudha,

Set a MIn and Max on the Master Calendar to restrict it to the range as per your data.

MinMax:

LOAD      Max(DocDate) AS MaxDate,

               Min(DocDate) AS MinDate

RESIDENT Periods;

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

[Anonymous]

Hi,

Create a resident table with year and month with the Keep syntax option to your fact table.

So that it will load years and months which are having data in FACT,

hope this helps

Regards,

Chinna