Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IA85


IA85.1 - 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.


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



    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



Use Year Variances (IA85.3) to add variance calculations for the year
dimension.


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