Powered By

Free XML Skins for Blogger

Powered by Blogger

Friday, January 9, 2009

Data Mart Interface in BW BI

Purpose

The data mart interface makes it possible to update data from one InfoProvider to another.

You have the following options:

Data exchange of multiple BI Systems: the data-delivering system is referred to as the Source B; the data-receiving system as the Target BI. The individual BI systems arranged in this way are called data marts. The InfoProviders of the source BI are used as sources of data here.

Data exchange between BI systems and other SAP systems

More information: Data Mart Interface Between Several Systems

Data marts can be used in different ways:

They save a subset of the data of a Data Warehouse in another database, possibly even in a different location.

They are smaller units of a Data Warehouse.

They are stored as intentionally redundant segments of the (logical, global) overall system (Data Warehouse).

Features

A BI system defines itself as the source system for another BI system by:

Providing metadata

Providing transaction data and master data

An export DataSource is needed to transfer data from a source BI into a target BI. Export DataSources for InfoCubes and DataStore objects contain all the characteristics and key figures of the InfoProvider. Export DataSources for master data contain the metadata for all attributes, texts, and hierarchies for an InfoObject.

No comments: