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 section of the application wizard, select a Base Time Period option to set how calendars roll up:
Note:
If your application type is Project Financial Planning, and you selected to create an industry sample application, the calendar properties are set automatically and cannot be changed.
-
12 Months: Four quarters per year; months roll up into parent quarters and quarters into years.
-
Quarters: Quarters roll up into years. After you select this option, proceed to step 7 below.
-
Custom: A custom time period, such as weeks or days. After you select this option, proceed to step 7 below.
Note:
You may use only a 12 month calendar range for Project Financial Planning applications.
See the Oracle Hyperion Planning Administrator's Guide for additional information on how to use the application wizard to create Planning applications.
-
-
If you selected the Create New Local Year Dimension option, the First Fiscal Year option is displayed. Use this option to define 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.
Note:
For Project Financial Planning applications, this option is selected by default and cannot be changed.
-
If you selected the Create New Local Year Dimension option, the Number of Fiscal Years option is displayed. Select the Number of Fiscal Years for the application to define the number of years in the calendar. You can add more years to the calendar after the application is created.
Note:
For Project Financial Planning applications, this option is selected by default and cannot be changed.
-
If you set the base time period as 12 Months, 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.
-
If you set the base time period as 12 Months, 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 Jun-10 to May-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 Jun-09 to May-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.