Before closing this chapter,let's briefly discuss two other InfoCube design techniques:
Compounding entities is an idea that BW borrows from R/3 to model coexistent entities. Compound attributes requires overhead,so you should not use them unless absolutely necessary.
Screen shows that 0CO_AREA is a compound attribute of 0COSTCENTER as defined in Business Content.
Sometimes the meaning of master data depends on the source of the data. In these cases,we need to compound the characteristic with the InfoObject 0SOURSYSTEM (Source system ID).
For example,suppose a characteristic IO_HOUSE has an entry called White House. The characteristic could mean the home of the U.S. President if it comes from a government source system,or it could mean a house painted white if it comes from a home improvement Web site. To handle cases such as this one,we need to compound IO_HOUSE with 0SOURCESYSTEM to clarify the meaning of the characteristic.
The 0SOURSYSTEM InfoObject is provided with Business Content.
Line Item Dimensions:
If a dimension has only one characteristic,we can make the dimension become a line item dimension. Consider the following example. For the InfoCube described,we can create another dimension called Dim: sales transaction,and check the option Line Item as shown in Screen.
After checking and activating the InfoCube,Screen reveals that the fact table has no dimension table created for the line item dimension. The key in the fact table is the SID of the SID table. Thus the fact table links to the master data,text,and hierarchy tables with the SID table,and one middle layer for the dimension table is removed. This design improves system performance.
Note:The line item dimension derives its name from the need for detailed information reporting at the line item level. In,Operational Data Store (ODS),we will discuss another technique that allows us to build a multilayer structure for different levels of detail information reporting.
The level of detail found in a data warehouse is called its granularity. It is determined by business requirements and technology capabilities.
SAP BW Related Interview Questions
|SAP BI Interview Questions||SAP WM Interview Questions|
|SAP BO Interview Questions||SAP Netweaver Interview Questions|
|SAP BODS Interview Questions||SAP Webi Interview Questions|
|SAP Web Dynpro Interview Questions||SAP BDC Interview Questions|
|SAP BW on HANA Interview Questions|
Sap Bw Tutorial
Business Scenario And Sap Bw
Creating An Infocube
Loading Data Into The Infocube
Checking Data Quality
Creating Queries And Workbooks
Managing User Authorization
Aggregates And Multi-cubes
Operational Data Store (ods)
Generic R/3 Data Extraction
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.