For applications, you can specify the fiscal start year and start month. When specifying the fiscal start year, consider how much historical data your organization needs and wants in the application. You can add years to the calendar, but you cannot change the fiscal start year.
For the fiscal year, you can set the fiscal year first month and specify whether the fiscal year starts from the same calendar year or the previous calendar year. You can later set up calculations based on the calendar year, for example, using formula expressions. When setting up formulas for Planning applications, keep in mind that formula expressions such as [TPDate] and [FirstDate] produce different results if the application starts in the same calendar year or previous calendar year.
The following table provides examples of how the Fiscal Year First Month and the Fiscal Start Year options affect the calendar for the application, assuming the Fiscal Start Year is 2010.
Table 15. Examples of Fiscal Year First Month and Fiscal Start Year Calendar Options
| Fiscal Year First Month | Fiscal Start Year | Year - Period | Year Dimension |
|---|---|---|---|
| January | Same Calendar Year | Jan-10 to Dec-10 | FY10 |
| July | Same Calendar Year | Jul-10 to Jun-11 | FY10 |
| July | Previous Calendar Year | Jul-09 to Jun-10 | FY10 |
| February | Same Calendar Year | Feb-10 to Jan-11 | FY10 |
| February | Previous Calendar Year | Feb-09 to Jan-10 | FY10 |
| December | Same Calendar Year | Dec-10 to Nov-11 | FY10 |
| December | Previous Calendar Year | Dec-09 to Nov-10 | FY10 |
To set up the calendar:
In the Calendar tab of the Classic Application Wizard, click Calendar.
See the Oracle Hyperion Planning Administrator's Guide for additional information on how to use the Classic Application Wizard.
Select a Base Period option to set how calendars roll up:
12 Months: Four quarters per year; months roll up into parent quarters and quarters into years.
Quarters: Quarters roll up into years.
Custom: A custom time period, such as weeks or days.
Select the First Fiscal Year while creating the new local year dimension.
This selection defines the starting fiscal year for the application. You cannot change it after creating the application. Before specifying the first fiscal year, consider how much historical data your organization needs and wants in the application.
Select the Number of Fiscal Years for the application.
This defines the number of years in the calendar. You can add more years to the calendar after the application is created.
Select the Fiscal Year First Month for a new local period dimension.
This is the first month in the fiscal year for the application, which depends on the First Fiscal Year option.
Select the Fiscal Year Start Date:
Same Calendar Year. Set the fiscal year to start with the current calendar year. For example, selecting the year 2010 with a starting period of Jun creates the starting year as FY10, defined as July-10 to Jun-11.
Previous Calendar Year. Set the year to start with the previous calendar year. For example, selecting the year 2010 with a starting period of Jun creates the starting year as FY10, defined as Jul-09 to Jun-10.
If you set the base time period as 12 Months, select a Weekly Distribution option: Even, 445, 454, or 544.
Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks in a month. This determines how data in summary time periods spreads within the base time period. When users enter data into summary time periods, such as quarters, the value is distributed over base time periods in the summary time period.
If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern. For example, if you select 5-4-4, the first month in a quarter is considered to have five weeks, and the last two months in the quarter have four weeks.