Mapping of InfoProvider objects in a universe

[former_member4998]

Hi All,

I am explaining how the BW objects are mapped in a universe.

• To build a universe on SAP NetWeaver BW, We must create a multisource-enabled data foundation based on a secured relational connection to SAP NetWeaver BW in IDT.
• Once you add an SAP NetWeaver BW connection to a data foundation, by default tables and joins are automatically inserted.
• When you create a business layer on the data foundation, by default objects are automatically inserted into the business layer.

The naming convention for the automatically generated data foundation tables are as follows:

• I-Table:   A table with a name prefixed by I (InfoCube) that maps to the InfoProvider fact table.
• D-Table:  A table with a name prefixed by D (Dimension) that maps to an InfoProvider master data table.
• T-Table:  A table with a name prefixed by T (Text) that maps to an InfoProvider text table.

• Data foundation -: To turn off automatic insertion, unselect the Detect table’s option in the advanced properties of the connection when you are adding the connection into the data foundation.

• Business layer -: To turn off automatic insertion of business layer objects, unselect the automatically create classes and objects option when selecting.

• When we include SAP BW as data source, Data Federator displays names of the tables start with prefix that identify the type of object.

• Tables that begin with this letter “I” - This table represents an “InfoCube” or “MultiProvider” in SAP BW. The name of the table is simply the name of the “InfoCube” or “MultiProvider” prefixed by an “I”.
  • Example – An infocube ZINFOCUBE – Display as IZINFOCUBE

• Tables that begin with this letter “D” - This table represents a master data “InfoProvider” in SAP BW.
  • Example – InfoObject  ZIOBJECT -  Display as DZIOBJECT

• Tables that begin with this letter “T”- This table represents a characteristic in SAP BW.
  • Example –  Characteristic  ZMATID – Display as TZMATID

Hope this helpful.

Thanks

Sreeni