SAP - BI
What Is an Infocube in SAP BI/BW? How To Create One?
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
Info-Objects take information from the source, then adjust and arrange the information into either a standard or customized report. Infoobjects are the smallest available information modules/fields in BI. It is needed in info-providers like InfoCubes, DSOs, MultiProviders, Queries etc... These Info-Providers are made up of Info-objects.
Info-object gives all information about the business. For instance company ‘XYZ’ is interested in finding out how much of “product x” shipped on “date x” to “factory x”. By defining Info-object for specific function like “0MATERIAL”, “0DATE” and “0LOCATION” all the information can be retrieved.
InfoObjects can be classified into the following types:
Characteristics:
Characteristics are Business reference objects used to analyze key figures.
Examples of characteristics InfoObjects:
Key figures provide the values to be evaluated. They are numeric information that is reported in the query.
Examples of key figure InfoObjects:
Units:
Units are paired with Key figure values . They provide assign a unit of measurement to a Key Figure Value. For instance 10 Kg where 10 is the KeyFigure and Kg is the unit
Other Examples of Unit Characteristics:
Time Characteristic:
Time characteristics give time reference to data.
Examples of Time Characteristics:
Technical characteristics are SAP standard objects having their own administrative purposes.
Examples of Technical Characteristics:
Before creating an Info Object, Info Area and Info Object Catalog need to be created.
There are 2 types of Info Object Catalog.
Here is the RoadMAP to create an Infoobject
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
Download PDF 1) What is SAP BW/BI? What is the purpose of SAP BW/BI? SAP BW/BI stands for Business...
We will learn the load with the help of a scenario - Load Master data to InfoObject ZMAT (Material...
What is Schema ? In database management system (DBMS), the schema represents relational database. It...
Go to RSA1 -> Modeling ->Infoobjects Right click on the Infoarea -> Click on Create Infoobject...
Step 1) Go to transaction code RSA1 to go to the Data Warehouse Workbench. Click the OK button....