BW Training Basics 1

A)     Info Object : This is like a column / field in general DB table . basic modelling starts with Info Object creation

B)      Info Cube : This is a multi dimensional model An object that can function as both a data target and an InfoProvider. 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.

C)      Data Store Objects (DSO’s)[2 Dimensional]: This is like a flat table in normal DB terms .

D)     Multi providers: This is like view’s in normal data base terms. If you want to create data from two cubes, we will be using Multi Providers  . There is no physical data storage of data in Multi provider (Virtual)

E)      Info Sets : These are like JOINS in normal DB terms , Like Multi providers there is no physical data storage of data in Info sets (Virtual) .This brings intersection data from tables .

 Info providers :

An InfoProvider is an object which sends data for reporting .The below objects will be called as Info providers

·          InfoCubes

·          Data Storage Objects

·          Multi Providers

·         InfoSets