Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IA85


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