WHAT IS INFOCUBE AND INFO OBJECTS

WHAT IS INFO CUBE AND INFO OBJECTS:

Info cube:

               Info cube is data storage area in which we maintained data which we are extracting from source system physically. It is a data target for the data which we are extracting source system and info provider quires.

               To create an info cube we require minimum of 1 fact table surrounded by 4 dimensions. Out of which 3 are fixed dimensions

                                                1.  TIME

                                                 2.  UNIT

                                                 3.  DATA PACKAGE

A cube can have maximum of 1 fact table surrounded by 16 dimensions (13+3)

 In this 3 are fixed dimensions

             13 are custom defined dimensions

NOTE: 1

             In SAP plat form a Table can have maximum of 16 primary keys

NOTE: 2

            In any Business scenario we request to maintain more than 16 dimensions in an Info cube we can use Snowflake Schema 

  

Facts:

          Measurement:- used to measure transactions can be called as “facts”, these facts in BW terminology ‘key figures’ [KEY FIGURES].

Fact Table:

                   Will be used to maintain transaction data in an info cube, It consist of dimension tables we called as DIM ID’s and key figures,

Dim Id’s will be join fact table with dimension table.

A fact table can have maximum of 16 dim id’s and 233 key figures.

Fact table: 255 columns =16 dim ids+ 233 key figures+ 6 (Reserve SAP)

Dimension:

                      Given description of business object, this description will be maintain using proportions are attributes in BW terminology “Characteristics” [CHAR] mean properties.

In the context of Extended Star schema a dimension consist of dimension tables, SID tables and master data tables.

Dimension Table:

                                 It is system generated table will get generated along   with tact table for every dimension defined in Info cube definition.

It consists of dimension table keys and Dim ID’s. Sid’s of characteristics organize in the dimension.

It will be used to join fact table with master data table using SID table it will get populated automatically when every time we load transaction data into info cube.

SID TABLES:

                      Will get generated automatically along with master data tables, when we activate structure of characteristics, it structure consist of characteristics and SID of characteristic. It will be used to join master data tables with fact table via dimension table.

NOTE:

             In case of line item dimension type, dimensions SD table will be used to join master data tables directly with fact table. Without using dimension table in Joins.

Sid table will get populated automatically whenever we load master data into characteristic master data table.

A dimension can have maximum of 248 characteristics.

255 columns= 6 reserved+ 1 DIM ID + 248 characteristics.

Master data table consist of;

1.       Master data table.

2.       Text data table.

3.       Hierarchy table.

Info objects:

                       Characteristics and Key figures will be called as Info objects. Info objects are similar to fields of source system using which we organize data in different info provider in BW.
The properties of info objects will be always determine based on the source field properties of which, we want to maintain data in info object.
Data types of characteristic:
CHAR-60
NUMC-60
DATS-8
TIMES-6
Key figure:
                Quantity
                Amount
                Number
                Integer
                Date
                Time

 Naming convention of BW objects:

0-      Standard delivered object

Z/Y- User or Custom defined object

Y/Z- Temporary testing

 B- Super user (Reporting user)

Technical name: Alpha Numeric, length- 3 to 8

Data dictionary naming convention:

Standard objects: /BIO/<XXXXXX>

Custom objects : / BIC/<XXXXXX>