What are the types of InfoObjects?

What are the types of InfoObjects?

InfoObjects can be classified into the following types:

• Characteristics (for example, customers)
• Key figures (for example, revenue)
• Units (for example, currency, amount unit)
• Time characteristics (for example, fiscal year)
• Technical characteristics (for example, request number)

What are InfoCubes in SAP?

An InfoCube is defined as a multidimensional dataset which is used for analysis in a BEx query. An InfoCube consists of a set of relational tables which are logically joined to implement the star schema. A fact table in the star schema is joined with multiple dimension tables.

How do you create an information object?

Creating InfoObjects

1. You are in the BW Modeling tools.
2. Select an InfoArea.
3. Enter a technical name and a description.
4. By choosing Copy from…, you can select an object template.
5. You can reference an InfoObject.
6. You can choose from the following InfoObject types: Characteristic, key figure, unit and XXL InfoObject.

How many types of InfoObjects are there in SAP BW?

You will find five different styles of InfoObjects offered inside the SAP BW landscape.

What is InfoObjects SAP BW?

InfoObjects are known as the smallest unit in SAP BI and are used in InfoProviders, DSO’s, Multi providers, etc. Each InfoProvider contains multiple InfoObjects. Characteristics like Customer, Product, etc. Units like Quantity sold, currency, etc.

How do you make a DSO in BW?

To create a standard DSO, go to the RSA Workbench. Go to Modeling tab → InfoProvider → Select InfoArea → Right click and click on create DataStore Object. Enter the technical name and description of the DataStore object. Type of DataStore Object → This is used to select the DSO type.

What is the difference between a field and an InfoObject?

InfoObject attributes must be InfoObjects. A field-based key figure cannot be an exception aggregation. An association with an Open ODS view is only possible once for navigation attributes. Planning queries on DataStore objects (advanced) are only supported with fields as read-only.

What are the different types of info objects in SAP BW?

In SAP BW, info objects are collectively classify into 5 types Technical characteristics. 1. Characteristics InfoObjects : Characteristics are used to describe the objects that deal with the business process. These can be anything core business objects like Customers, Vendors, Accounts, etc.

What types of infoinfoobjects are there?

InfoObjects can be classified into the following types: Characteristics (for example, customers) Key figures (for example, revenue) Units (for example, currency, amount unit) Time characteristics (for example, fiscal year) Technical characteristics (for example, request number)

What is infoobject in SAP bi?

InfoObjects are absolutely essential to the SAP BI ecosystem. InfoObjects take delivery of source data and throughout the entire ETL process, adjusting and arranging data for its eventual report consumption. The InfoObject is truly the smallest building block in SAP BW.

How the data is stored in SAP BW?

The data is stored in an internal format, and also the way data appears on screen. For example : if you have InfoObject characteristic ZC_CUST is 10 and ALPHA is selected, in SAP BW value of 1 is stored as 0000000001, without conversion routine, the SAP BW would treat ZC_CUST value of 1 is different with 001.