Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Sap Bi: Infocube And Creation Of Standard Infocube



Infocube:

Infocube is information stockpiling range in which we keep up information which we are removing from source framework physically. An Infocube can work as both an information target and an InfoProvider. From a reporting perspective, an Infocube can be portrayed as an independent dataset.

For instance, a Sales Amount Infocube which has measurements like MONTH – PRODUCT-CUSTOMER-REGION, can be seen by any of the tomahawks, for instance all out deals by locale or by client. The measurements of an Info-Cube are elements or chains of command.
BIW ( Business Intelligence Warehouse) gives office to characterize 16 measurements, out of which 3 are pre-characterized.


Steps To Create Standard Infocube:

Step 1:
Make InfoCube
  • Go to exchange code RSA1
  • Click the OK catch.
Step 2:
  • Explore to Modeling tab->InfoProvider.
  • Right tap on InfoArea.
  • Click on "Make InfoCube" from the setting menu.

Step 3:
  • Enter the Technical Name.
  • Enter the Description.
  • Pick the choice catch "Standard InfoCube".
  • Click the make catch



Step 4:

Right Click on Dimension 1 - > Properties.

 

 
Step 5:
Rename the Dimension according to Info object data.




 


Step 6:
Right tap on the Dimension - >InfoObject Direct Input to Insert InfoObjects into the Dimension. 

 

Step 7:

Select Characteristics.



Step 8: 
  • Select Airline ID in qualities
  • Move and customize it into Dimension

Step 9:

Correspondingly make new measurements and take after the strides 4-8 to include the InfoObjects.
 
Step 10:

Including Key figureInfoObjects in the Infocube

Step 11:

Take after the proesses above to include more Key Figures
 
Step 12:

Initiate the Infocube.


Infocube Additional Points:

The specialized name of the dimensional table is alloted by the framework, utilizing the example/BIC/"D#", where the primary # will be a1, the second a 2, etc.
  • On the off chance that it is a sap conveyed 3D shape, then it would start as/BI0/D
  • Qualities Infoobjects can be uninhibitedly added to client made measurements.
  • Measurement Tables ought to be utilized ideally.
Guarantee ideal cardinality while adding qualities infoobject to dimensions.E.g. A departmental store has 10,000 clients and 1000 distinct materials. The cardinality is m:n, which implies every client can purchase numerous materials. Such sort of cardinality ought not be kept up in the same measurement table.

Folkstrain offers a best online training for sap bi in usa, uk and globally with real time experts. On your flexible timings with [email protected] sap bi online training


This post first appeared on Sap Crm: Account Management, please read the originial post: here

Share the post

Sap Bi: Infocube And Creation Of Standard Infocube

×

Subscribe to Sap Crm: Account Management

Get updates delivered right to your inbox!

Thank you for your subscription

×