IA85.1 - Year Definition
Welcome to Year Definition
Use Year Definition (IA85.1) to define the options for the year dimension.
** Process at a glance
1. Load the preassigned data mart types.
2. Create an OLAP destination.
3. Define the data mart.
4. (YOU ARE HERE) Define the dimensions for the data mart.
5. Define the information transfer profile.
6. Load the data mart.
** Field Descriptions
Year Range: You must enter a beginning and ending year. You can enter a
single year or multiple year range.
Name for Prior Years: Type a member name for all prior years to roll up into.
Updated Files
IAYEAR -
IAYEARYR -
Referenced Files
OLAPDIM -
ROLAPDIM -
IA85.2 - Year Definition
Welcome to Year Definition
Use Year Definition (IA85.2) to change the default member names for the year
dimension.
Updated Files
IAYEARYR -
Referenced Files
IAYEAR -
IA85.3 - Year Variances
Welcome to Year Variances
Use Year Variances (IA85.3) to add variance calculations for the year
dimension.
** Field Descriptions
Member Name: Type a member name.
Amt Pct: Select A (Variance Amount) or P (Variance Percent) to determine
which type of calculation the member will contain.
Year 1: Type the beginning year to be included in the calculation.
Year 2: Type the ending year to be included in the calculation.
Updated Files
IAYEARVAR -
Referenced Files
IAYEAR -
IAYEARYR -
INVOKED Programs
IAAP
IFOB
IADE
|
