INFOCUBE / DATAMART

[Former Member]

what would be the difference between infocube anda datamart?

Joseph

[Former Member · Accepted solution]

Hi Joseph,

Infocube: An object that can function as both a data target and an InfoProvider.

From a reporting point of view, an InfoCube describes a self-contained dataset, for example, of a business-orientated area. This dataset can be evaluated in a BEx query.

An InfoCube is a quantity of relational tables arranged according to the star schema: A large fact table in the middle surrounded by several dimension tables.

More about Infocube:

http://help.sap.com/saphelp_nw04/helpdata/en/8d/2b4e3cb7f4d83ee10000000a114084/frameset.htm

Datamart:The data mart interface makes it possible to update data from one data target into another.

More about datamart:

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6110e07211d2acb80000e829fbfe/frameset.htm

You can search SDN for more info as these topics has discussed many times in SDN.

Regards,

KK

[former_member345199]

HI,

Infocube is an object which physically stores data and is used for reporting while Data mart is an object which is used to send data to another object.

An Infocube or ODS can act as a datamart.

Hope this helps.

Thanks,

JituK

[Former Member]

hi,

datamart is the dataprovider for other targets.

incfocube is a data target that stores data, and is one of the datamart.

other data marts were ods,infobjects.

Ramesh