IA11.3 – Olap Database Profiles

System
Analytic Architect (IA)
Type
Online screen — form 11
Updates
2 tables
References
3 tables

IA11.3 (Olap Database Profiles) is a Lawson Analytic Architect online screen (form 11, subform 3). It updates OLAPPROF and PROFDIMREL and references APPLICTYPE, OLAPDBM and OLAPDIM.

About IA11.3

Use Olap Database Profiles (IA11.3) to define profiles that specify how the how the data mart is built and loaded. You can set up multipleprofiles, each for a different purpose. **Process at a Glance 1. Load the preassigned data mart types. 2. Create an OLAP destination. 3. Define the data mart. 4. Define the dimensions for the data mart. 5. (YOU ARE HERE) Define the information transfer profile. 6. Load the data mart. Profile Name: Type a profile name and description that represents the type of information transfer you are defining. Fact Table Options: Options are: - N (No load) - I (Incremental Load) - Only data values that have changed since the last data mart update are loaded. - C (Complete Load) - If this is the first time you are creating your data mart, select this option. If you choose this option for a data mart that already contains data, all data values will be overwritten. Dimensions: If you chose Yes to create all dimensions, leave this field blank. If you chose No, select Data Mart Dimensions from the drop down list and choose the dimensions you want to create.

Updated files (2)

TableDescriptionSystem
OLAPPROFData Mart ProfilesIA
PROFDIMRELNo description in the Lawson data dictionaryIA

Referenced files (3)

TableDescriptionSystem
APPLICTYPEApplication TypeIA
OLAPDBMData Mart ManagerIA
OLAPDIMData Mart DimensionsIA

Program calls

Invoked programs (1)

IACP