Forum Discussion
Calendar
Hi cristianml ,
On your YTD measure you need to define the fiscal year ending.
Check this post about issues with time inteligence on fiscal years.
Regards,
MFelix
Hi,
In your Revenue and Forecast tables, there must be a Date field - if it not there, you will have to create one. Even if you have a seperate field for Month and Year in those tables, a Date field can always be created. You must then create a Calendar Table with running dates. Thereafter build a relationship from the Date field of each Table to the Date field of the Calendar Table. You will now be able to use all of the Date and Time Intelligence functions.
Hi Ashish_Mathur,
Not sure if I doing something wrong but I couldn't create a relationship between the calendar I created (calentarauto) with EndMonthDate August (8) and the queries. I created a relationship between the two calendars and do the YTD Measure buy only works from January instead of September that is the begining of the FY.
Hi cristianml ,
On your YTD measure you need to define the fiscal year ending.
Check this post about issues with time inteligence on fiscal years.
Regards,
MFelix
Hi,
I do not understand why there is a bi-directional relationship between the List Period and CalendarAuto Table. There should be a relationship between the Date column of the FT Actuals Table to the Date column of the CalendarAuto Table.