Future Target Data Entry
Use
You can enter future target data using an Excel spreadsheet. Target data is defined as the period range from the current period of the Application Server model date range through the end date as long as the end date is after the current period.
Prerequisites
The Target Data link may or may not be visible depending on defaults settings determined by the Entry and Approval administrator.
The Entry and Approval administrator has set the date range to end in a period after the current period.
A measure set should not have more than 500 rows. If you exceed this number, the system disables the Target Data link for the measure set, even if you have permission to enter target data.
You have permission to enter future target data and you can see the Target Data link in the Entry and Approval main window. Entry and Approval administrators activate this option by selecting Input historical data (actual and target) in Set Entry and Approval Defaults. Entry and Approval administrators always have permission to enter historical data, regardless of the settings.
Features
Future target data entry has these features:
-
For the current period and each future period, you enter target data in the Target column. The Actual column has a gray background in the worksheet, and you cannot enter any actual data.
-
If you have many rows, you can organize the rows by column to find the measures using the Sort Rows option in Excel.
-
The Excel spreadsheet acts as a template that holds the data temporarily until it is passed to Entry and Approval.
-
The worksheet heading displays information about the measure set, the start date and end date of the entire period, and the current period.