Context

This note is the entry point for configuring a new AIF_DATA environment. It covers the seed configuration: the tables that must hold correct values before any data is extracted from MFCS or loaded by FTS server.

Everything here runs once per implementation. None of it is part of day to day operation.

Work in progress

Only the three configuration tables below are documented so far. Several further steps are required before the environment is ready, and they are not written up yet. Do not treat this note as a complete initial setup procedure, and do not assume a batch runs once the three tables are done.

Values are client specific

The child notes record the P&C configuration, including currency, language, calendar range and planning levels. Treat them as a worked example to adapt, not as defaults to copy.

Configuration tables

These three are complete. They can be run in any order relative to each other, and all three must be correct before the environment goes any further.

  1. Environment cleanup process
  2. Initial setup - C_ODI_PARAM: the main ODI configuration table, 125 parameters covering currency, language, calendar, item differentiators, CFA visibility, flex facts and planning levels.
  3. Initial setup - W_GLOBAL_CURR_G: the three global reporting currencies.
  4. Initial setup - W_LANGUAGES_G: the supported languages for translatable data.
  5. Business date setup
  6. Calendar initialization using MFCS integration
  7. Check the Interfaces guide in order to load the Dimensions

Still to document

The steps that follow the three configuration tables are not written up yet.