Monday, September 20, 2010

Definitions of some Objects in BI/BW

Info Area:

Element for grouping meta-objects in the BI system.

Each InfoProvider is assigned to an InfoArea. The resulting hierarchy is displayed in the Data Warehousing Workbench.

In addition to their properties as an InfoProviders, InfoObjects can also be assigned to different Info Areas.

Info Area is a Top Level Object, which contains the data models in it .


In general, Info Areas are used to organize InfoCubes and InfoObjects. Each InfoCube is assigned to an Info Area. Through an InfoObject Catalog, each Info Object is assigned to an Info Area as well.


The Info Area contains all objects used to evaluate for a business logical process.


Info Area in which Info Providers are stored.


Info Object Catalogs:


An Info Object catalog is a collection of InfoObjects grouped according to application-specific criteria. 


There are two types of InfoObject catalogs: Characteristic and Key figure.


Info Objects, (characteristics and key figures) are the basic data model of SAP Business information warehouse(BW/BI).


And the Info objects are stored in folders, it also called the “InfoObject catalogs”, the infoobject catalogs are also stored in a folder called Info Areas.


An Info Object catalog is assigned to an Info Area.


An Info Object can be included in several Info Object catalogs.


Info Objects:


Business evaluation objects are known in BI/BIW as InfoObjects. They are divide into characteristics (for example, customers), key figures (for example, revenue), units (for example, currency, amount unit), time characteristics (for example, fiscal year) and technical characteristics (for example, request number). 


Info Objects are the smallest information units in BI/BW.


They structure the Information needed to create the data targets.








Info Objects with attributes or texts can be either a pure data target or an Info Provider (if it is being reported).




Application Component







Application Components are used to organize Data Sources. They are analogous to the Info Areas .






DataSource

A DataSource is not only a structure in which source system fields are logically grouped together, but also an object that contains ETTL-related information.
 Four types of DataSources exist:
DataSources for transaction data
DataSources for characteristic attributes
DataSources for characteristic texts
DataSources for characteristic hierarchies

If the source system is R/3, replicating DataSources from a source system will create identical DataSource structures in the BI/BW system. 


Info Package:
An InfoPackage specifies when and how to load data from a given source system. BW generates a 30-digit code starting with ZPAK as an InfoPackage's technical name.






PSA

Persistent Staging Area is a data staging area in BW. It allows us to check data in an intermediate location, before the data are sent to its destinations in BW.
The PSA stores data in its original source system format. In this way, it gives us a chance to examine / analyse the data before we process them to further destinations. Most probably it is a temporary storage area, based on the client data specifications and settings.
SID

SID (Surrogate-ID) translates a potentially long key for an InfoObject into a short four-byte integer, which saves I/O and memory during OLAP.

Star schema
A star schema is a technique used in the data warehouse database design to help data retrieval for online analytical processing(OLAP).







Business Content

Business Content is a complete set of BI/BW objects developed by SAP to support the OLAP tasks. It contains roles, workbooks, queries, Info Cubes, key figures, characteristics, Transformations and extractors for SAP R/3, and other mySAP solutions.




Compound attribute

A compound attribute differentiates a characteristic to make the characteristic uniquely identifiable. For example, if the same characteristic data from different source systems mean different things, then we can add the compound attribute 0SOURSYSTEM (source system ID) to the characteristic; 0SOURSYSTEM is provided with the Business Content.




Data packet size

For the same amount of data, the data packet size determines how work processes will be used in data loading. The smaller the data packet size, the more work processes needed.




Data Warehouse

Data Warehouse is a dedicated reporting and analysis environment based on the star schema database design technique and requiring special attention to the data ETTL process.




Delta update

The Delta update option in the InfoPackage definition requests BI/BW to load only the data that have been accumulated since the last update. Before a delta update occurs, the delta process must be initialized.

6 comments:

sadaqmsc said...

hi thanx for giving ur most n valuable time for us like learners it is much easier i'm searching jobs on sap bi my mail id sadaqmsc@gmail.com

shivakrishna said...

hi thanks for giving this information if u have any other material in detaild plz send it to my mail id am learnig sap bw,hana,bi
plz send me the materials which u hva
mail id :shivakrishna589@gmaIL.COM

shivakrishna said...

hi thanks for giving this information if u have any other material in detaild plz send it to my mail id am learnig sap bw,hana,bi
plz send me the materials which u hva
mail id :shivakrishna589@gmaIL.COM

comettech said...

Nice Blog,http://www.keentechnologies.com/sap-bw_bi-online-training.html

Unknown said...

Hi,

Very informative explanation, could you please send me sap bi material to my mail id so that i can learn more effectively.

srinivas.akula1988@gmail.com

i am waiting for your response.


Thank you

Srinivas

Unknown said...

Very informative article. This is usefull for many people who are reading it.
Learn Master Data Loading Attributes and Text Actual cost of this course is 3,200/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.

Hurry-Up Enroll Now and get Free Access to the Entire Course