Info objects
Definition:
Info objects are business evaluation objects in BI/BW. Info objects are the smallest information units in BW. They structure the information needed to create data targets. Info objects with attributes or text can be either data target's or info providers
They are divided in to Five types:
Characteristics
Key figures
Unit
Time
Technical
Characteristics:
This type of InfoObject symbolizes a business entity that you are likely going to be analyzing. Such as: material, customer, or region.
Key Figures:
This type of InfoObject provides numeric measures of business entities. We chose to implement these to examine characteristics by weight, quantity, price, amount, etc…
Time Characteristics:
This particular type of InfoObject provides when a transaction takes place. As an option, fiscal year, month of sale, day of sale, quarter in which something sold.
Unit InfoObjects:
This kind of InfoObject provides what unit of measure a key figure is using. For instance, we might be using the metric system to gauge weights for our clients, so as a substitute for pounds we will be using kilograms.
Technical Characteristics
SAP internal InfoObjects that retain information containing automatically generated IDs that are being used for monitoring and administration of the SAP BW system. For example, every individual load into SAP BW involves a unique request ID that ties back to a exclusive load so administrators can diagnose inaccuracies or take out a bad data load.
Types of Characteristic info objects
Display Attribute :A display attribute provides supplemental information to a characteristic.
Time dependent Display attribute
Time independent Display attribute
Navigational Attribute : A navigational attribute indicates a characteristic-to-characteristic relationship between two characteristics. It provides supplemental information about a characteristic and enables navigation from characteristic to characteristic during a query. Time independent Navigational Attribute and Time dependent navigational attribute .
Text
Hierarchy : version dependent, time dependent , interval hierarchies
Compound attribute : A compound attribute differentiates a characteristic to make the characteristic uniquely identifiable. For example, if the same characteristic data from different source systems mean different things, then we can add the compound attribute 0SOURSYSTEM (source system ID) to the characteristic; 0SOURSYSTEM is provided with the Business Content.
Different tables created while activating Info objects are as follows :
Master data table
Text Table
SID table
Hierarchy table
Attribute table
Below are the Tables Naming Convention:
/BI0/S<IO Name> - SID table
/BI0/P<,,,,> - master data table
/BI0/T<,,.>- Text Table
/BI0/X<,,. SID Table for attributes
/BI0/M<,,> View of Master data tables
/BI0/Q<...> Time dependant master data table
/BI0/Y<..> Time Dependant SID table for attributes
The above table gets created if you have time dependent attributes
If the Infoobject have hierarchies
/BI0/H<...>Hierarchy Table
/BI0/K,...> Hierarchy SID table
/BI0/I<..> SID Hierarchy structure
Different Data types allowed for creating a characteristic info object are
CHAR, NUMC, DATE, TIME
Different Data types allowed for creating Key figure info object are
Amount, Quantity , Number, Interger, date , time
Definition:
Info objects are business evaluation objects in BI/BW. Info objects are the smallest information units in BW. They structure the information needed to create data targets. Info objects with attributes or text can be either data target's or info providers
They are divided in to Five types:
Characteristics
Key figures
Unit
Time
Technical
Characteristics:
This type of InfoObject symbolizes a business entity that you are likely going to be analyzing. Such as: material, customer, or region.
Key Figures:
This type of InfoObject provides numeric measures of business entities. We chose to implement these to examine characteristics by weight, quantity, price, amount, etc…
Time Characteristics:
This particular type of InfoObject provides when a transaction takes place. As an option, fiscal year, month of sale, day of sale, quarter in which something sold.
Unit InfoObjects:
This kind of InfoObject provides what unit of measure a key figure is using. For instance, we might be using the metric system to gauge weights for our clients, so as a substitute for pounds we will be using kilograms.
Technical Characteristics
SAP internal InfoObjects that retain information containing automatically generated IDs that are being used for monitoring and administration of the SAP BW system. For example, every individual load into SAP BW involves a unique request ID that ties back to a exclusive load so administrators can diagnose inaccuracies or take out a bad data load.
Types of Characteristic info objects
Display Attribute :A display attribute provides supplemental information to a characteristic.
Time dependent Display attribute
Time independent Display attribute
Navigational Attribute : A navigational attribute indicates a characteristic-to-characteristic relationship between two characteristics. It provides supplemental information about a characteristic and enables navigation from characteristic to characteristic during a query. Time independent Navigational Attribute and Time dependent navigational attribute .
Text
Hierarchy : version dependent, time dependent , interval hierarchies
Compound attribute : A compound attribute differentiates a characteristic to make the characteristic uniquely identifiable. For example, if the same characteristic data from different source systems mean different things, then we can add the compound attribute 0SOURSYSTEM (source system ID) to the characteristic; 0SOURSYSTEM is provided with the Business Content.
 |
Different tables created while activating Info objects are as follows :
Master data table
Text Table
SID table
Hierarchy table
Attribute table
Below are the Tables Naming Convention:
/BI0/S<IO Name> - SID table
/BI0/P<,,,,> - master data table
/BI0/T<,,.>- Text Table
/BI0/X<,,. SID Table for attributes
/BI0/M<,,> View of Master data tables
/BI0/Q<...> Time dependant master data table
/BI0/Y<..> Time Dependant SID table for attributes
The above table gets created if you have time dependent attributes
If the Infoobject have hierarchies
/BI0/H<...>Hierarchy Table
/BI0/K,...> Hierarchy SID table
/BI0/I<..> SID Hierarchy structure
Different Data types allowed for creating a characteristic info object are
CHAR, NUMC, DATE, TIME
Different Data types allowed for creating Key figure info object are
Amount, Quantity , Number, Interger, date , time
No comments:
Post a Comment