Between ODS and InfoCube and MultiProvider

[Arthur Wang]

What is the difference between ODS and InfoCube and MultiProvider?

—

Answer:

ODS: Provides granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI.

CUBE: Follows the star schema, we can only append data, ideal for primary reporting.

MultiProvider: Does not have physical data. It allows to access data from different InfoProviders (Cube, ODS, InfoObject). It is also preferred for reporting.

[Author]

Posts