Personal Growth


Instead of creating a new InfoCube, you can install an InfoCube from SAP BI More information: Line Item and High Cardinality. 7. In the context menu for the. 13 Mar There are some differences in SAP BI while creating objects. We will see how to create InfoCube and other related Objects in SAP BI SAP BW InfoCube – Learn SAP BW in simple and easy steps starting from Overview of SAP BI, Data Go to Modeling tab → InfoProvider → Create InfoCube.

Author: Tygogul Tara
Country: Malaysia
Language: English (Spanish)
Genre: Medical
Published (Last): 25 December 2016
Pages: 373
PDF File Size: 17.56 Mb
ePub File Size: 10.2 Mb
ISBN: 563-4-43178-452-2
Downloads: 37859
Price: Free* [*Free Regsitration Required]
Uploader: Sagar

The fact table and dimension tables in an InfoCube are both Relational database tables.

What Is an Infocube in SAP BI/BW? How To Create One?

This will delete the transaction data and InfoCube will be set to inactive. Add InfoObject to dimension. Excel Tutorials Accounting Ethical Hacking.

How To Create One?

Step by Step Guide Session Icreate an infocube – SAP NetWeaver Business Warehouse – SCN Wiki

Real time InfoCubes are used to infocubf parallel write access. Real time InfoCubes are used in connection with the entry of planning data. Delta loads will bring any new or changed records after the last upload. You’ll be able to see the delta changes coming in the delta queue through RSA7 on the R3 side. It is a self-enclosed data set encompassing one or more related business processes.


The delta mechanism is the same for both Master data and Transaction data loads. Key Figures are measures used for characteristics. Use line item dimension if only one object is placed in a dimension table.

The dimensions of an Info-Cube are entities ot hierarchies. Enter the Technical Name. A reporting user can define or execute queries against an info cube. Maintain high cardinality information in dimensional table.

Read and Write are possible. SAP delivered Infocubes begins with a number usually 0. Step 7 Select Characteristics. Dimension Tables should be used optimally. Wants to facilitate multi-dimensional analysis.

Step by Step Guide to load data to BW using BI 7.0

Click on the save button and on the BADI definition. Granularity degree of detail of key figures in an InfoCube is defined by its characteristics. Maintain high granularity of records. This method is used for better loading in less time.

They are available as InfoProviders for analysis and reporting purposes.

Data Sources are extraction structure. Step 5 Rename the Dimension as per Info object information. Each dimension can hold characteristics for analysis.

Stores the data physically in the cube. From a reporting point of view, an Infocube can be described as a self-contained dataset.

What Is an Infocube in SAP BI/BW? How To Create One?

For example, Product, Customer and Plant. An InfoCube is used to store the data physically. Python Perl Linux JavaScript. All InfoObjects to be used in an InfoCube should be available in an active version. An InfoCube can function as both a data target and an InfoProvider. Iin a BADI implementation alre….


N cardinality within the same dimension. Infocube is data storage area in which we maintain data which we are extracting from source system physically. Your own Knfocube should begin with a letter between A to Z and that it should be 3 to 9 characters in length. For example, sales quantity for a product, customer and location combination. It consists of a number of InfoObjects that are filled with data from staging.

In doing so, each document posting with delta extracti…. It has the structure of a star schema. There are large fact tables that contains key figure for InfoCube and multiple smaller dimension tables that surround it.

Infocube uses concept of star schema. These dimensions and fact tables are linked to each other using identification numbers dimension IDs. An InfoCube consists of a set of relational tables which are logically joined to implement the star schema.

During the query execution it brings the data from respective source system. The real-time characteristic can be assigned to an InfoCube. The above cube demonstrates a simple 3 dimensional cube. A reporting user can define or execute queries against an info cube.

Back To Top