Install and configure Data Links to access source databases or
configure ODBC connections. In Connector the connections to the Data Links are
established by the Data Link service. Only one connection string is required
for the Data Link service. Preset when installed. The business data will be
temporarily stored in the repository of
Infor BI Designer,
before the data are written into the
Infor BI OLAP Server
database. Enable the database connections and the business units whose data you
process.
Check the target structure.
Before you create unified mappings for business groups, check,
whether the target dimensions and target cubes exist. Unified mappings may also
be added and edited later.
Create the business groups.
Create the business groups with the Business Group Wizard. Thus,
you combine the business units, for which you use the same settings. Unified
mappings, currency settings and settings to load business data, are specific to
the business groups.
Check the mappings.
Check the mappings you have created with the Business Group
Wizard. Create further mappings, if necessary. For the unified mappings select
the elements to import later.
Assign elements in the target dimension.
Create the hierarchical structure for the import. Copy the
source elements to the target dimension or create elements that you assign to
the source elements.
Create data connections for cubes.
Create the data connections for cubes for the cubes of the
Infor BI OLAP Server
database. Thus, you determine, which data are loaded into the cube, when the
database is created.
Create the
OLAP Server
database.
Create the database using the menu command
File > Create
Database. In the
OLAP Server
database, the structures are created and the mapped data are imported from the
source database.