What is the use of InfoSource in SAP BW?

You always use an InfoSource when you want to perform two (or more) transformations consecutively in the data flow – without additional storage of the data. If you do not need two consecutive transformations, you can model the data flow without an InfoSource.

What is InfoCube and Infoobject?

An InfoCube is used to store the data physically. It consists of a number of InfoObjects that are filled with data from staging. It has the structure of a star schema. The real-time characteristic can be assigned to an InfoCube. These Real-time InfoCubes are used differently to standard InfoCubes.

What is Infoobject catalog in 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. InfoObjects are used in reports to analyze the data stored and to provide information to the decision makers.

What is difference between InfoSource and DataSource in SAP?

To further explain – a DataSource is assigned to an InfoSource. If fields that logically belong together exist in various source systems, they can be grouped together into a single InfoSource in BW, in which multiple DataSources can be assigned to an InfoSource.

What is bw4hana InfoSource?

The SAP BW InfoSource is a concept which used to be mandatory in a 3. x dataflow. It is a view that had to be created between the DataSource and InfoProvider, to map the SAP fields to InfoObjects. In the newer versions it is not a mandatory object anymore.

What is difference between DSO and InfoCube?

The main difference between the DSO Object and the PSA and InfoCube is that the DSO Object allows existing data to be changed. Whereas an InfoCube principally allows inserts, and only allows deletion on the basis of requests, data in an DSO Object can be changed during the staging process.

How many key fields are in InfoCube?

Key figures: The infocube can contain up to 233 key figures. Key fields: The DSO can contain a total of 16 key fields. This numer is limited to 12 for standard datastore objects.

What are the characteristics of InfoObjects in SAP BW 4HANA?

There are four types of InfoObjects in SAP BW/4HANA: characteristic, key figure, unit, and XXL. In the case of language dependency, the language is added as a compounding key to the characteristic’s values, allowing multiple descriptions to be stored.

What is characteristic InfoObject in SAP BW?

Business evaluation objects are known in BW as InfoObjects. InfoObjects are divided into characteristics, key figures, units, time characteristics and technical characteristics. InfoObjects are the smallest units in BW. They are used to depict information in a structured form required for creating InfoProviders.

What are the types of InfoProviders?

InfoProvider Types

  • Standard.
  • Write-optimized.
  • DataStore objects for direct update.
  • Semantically partitioned.
  • Creating DataStore Objects (advanced)

How do I assign InfoObject to Infoarea?

It did not seem to be an easy way, but it worked.

  1. TX RSD1.
  2. Click on the InfoObject Catalog button.
  3. Select the target InfoObject catalog that you want your objects in the unassigned nodes to go and click on ‘Edit’ button.
  4. Right click on the Characteristic/Key Figure and select ‘InfoObject direct input’.