Creation of Standard Info Cube (Transaction Data ) in SAP-BI

[mitsumi]

Creation of Standard Info Cube (Transaction Data ) in SAP-BI
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4 Hours | Lec: 11 | 2.92 GB
Genre: eLearning | Language: English

Learn step-by-step how to create Info Cube and load the data from Flat File to Info Cube in SAP-BI/BW

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 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.

For example, a Sales Amount Infocube which has dimensions like MONTH - PRODUCT-CUSTOMER-REGION, can be viewed by any of the axes, for example total sales by region or by customer. The dimensions of an Info-Cube are entities or hierarchies.

BIW ( Business Intelligence Warehouse) provides facility to define 16 dimensions, out of which 3 are pre-defined. nfoCube Structure:

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.
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.
It is used to store summarized / aggregated data for long periods of time. Infocubes consist of precisely 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.

Standard Infocube:Used to maintain the data physically in the cube. Read only is possible.
Virtual Infocube:  It does not maintain data physically in the cube .During the query execution it brings the data from respective source system.
Real Time Infocube: Stores the data physically in the cube.Read and Write are possible. It is significantly used in planning the data.
         

               

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction