SAP BW InfoCube – Learn SAP BW in simple and easy steps starting from Overview of SAP BI, Data Warehousing, Data Flow, Transformation, InfoArea, Object. What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from source system physically. An InfoCube. SAP BW InfoCube is a type of InfoProvider on which queries can be defined or executed. InfoCubes can store data in real DB tables or virtually.
|Published (Last):||14 October 2018|
|PDF File Size:||2.26 Mb|
|ePub File Size:||1.99 Mb|
|Price:||Free* [*Free Regsitration Required]|
Infocube is data storage area in which we maintain data which we are extracting from source system physically. An InfoCube can function as both a data target and an InfoProvider. From a reporting point of view, an Infocube can be described as a self-contained dataset.
The dimensions of an Info-Cube are entities or hierarchies. BIW Business Intelligence Infocubess provides facility to define 16 dimensions, out of which 3 are pre-defined. The above cube demonstrates a simple 3 dimensional cube. Each dimension can hold characteristics for analysis. An Infocube follows the Extended Star Schema.
It has Fact table at the center and is surrounded by 16 dimension tables with Master data lying outside the cube. Infocubes are the central multidimensional data model in BI.
InfoCubes (SAP Library – Business Intelligence)
It is a self-enclosed data set encompassing one or more related business processes. A reporting user can define or execute queries against an info cube. Infocubes consist of inofcubes one fact table surrounded by dimensional tables.
SAP delivered Infocubes begins with a number usually 0. Your own Infocube should begin with a letter from A to Z and that it should be 3 to 9 characters in length. Type of InfoCube Infocube is classified in to three types based on the way of maintaining and distributing the data.
Used to maintain the data physically in the cube. Read only is possible. It does not maintain data physically in the cube.
During the query execution it brings the data from respective source system. Stores the data physically in the cube. Read and Write are possible. It is significantly used in planning the data.
Right click on InfoArea. Step 3 Enter the Technical Name. Step 5 Rename the Dimension as per Info object information. Step 7 Select Characteristics. Dimension Tables should be used optimally. Ensure optimum cardinality while adding characteristics infoobject to dimensions. A departmental store has 10, customers and different materials. The cardinality is m: Such kind infovubes cardinality should not be maintained in the same dimension table. Enter the Technical Name. Wants to facilitate multi-dimensional analysis.
Types of infocubes in BI
Use line item dimension if only one object is placed in a dimension table. Maintain high granularity of records. N cardinality within the same dimension. Give more attention on bring the character information through navigational attribute. Maintain high cardinality information in dimensional table.
SAP BW – InfoCube
Accounting Business Analyst Cloud Computing. Ethical Hacking Informatica Jenkins. How To Create One?