The original design,"Hierarchy," uses a time-dependent hierarchy structure. Although that design performs more poorly than the alternative II InfoCube design,its sales organization hierarchy is very flexible. That is,we can easily add or delete levels in the sales organization. The major drawback of the design,however,is that we cannot create aggregates on a time-dependent hierarchy structure.
This section introduces another type of hierarchy,called a time-dependent entire hierarchy,that does allow us to create aggregates. Figure illustrates how it differs from the time-dependent hierarchy.
A COMPARISON OF TWO TYPES OF HIERARCHIES
Time-dependent hierarchy structures consist of nodes or leaves that are time-dependent. The hierarchy itself is not time-dependent.
As shown in Figure(b),time-dependent entire hierarchies consist of nodes or leaves that are not time-dependent. The hierarchy itself is time-dependent.
The following steps explain how to build the design for our example with time-dependent entire hierarchies.
Step 1. Create a new IO_SREP,called IO_SREPN3. Select the Entire hierarchy is time-dependent option.
Step 2. Select Create hierarchy from the InfoObject menu.
Step 3. Specify the valid dates,and then click to continue.
Step 4. Using the procedure given,create a hierarchy. Notice that the Denver office is placed in the West region.
Step 5. Create another hierarchy,and specify its valid dates as being from 01.01.1000 to 31.12.1999. Now the Denver office appears in the Midwest region.
Step 6. Notice the two hierarchies. Each has an associated valid date.
Step 7. Follow the procedure to create a new InfoCube,IC_NEWBC3.Follow the procedure to create a new query,IC_NEWBC3_Q01. When selecting hierarchies,we have two hierarchies.
Select one hierarchy,and click. Save and run the query.
The first query result shows that the Denver office is located in the West region.
Create another query. This time,select IO_SREPN3_H1999 as the hierarchy. The result of this query puts the Denver office in the Midwest region.
Note:The time-dependent hierarchy structure in the design and the time-dependent entire hierarchies in the new design created produce the same query results.BW hierarchies are very flexible. We can easily add or delete nodes and leaves. Likewise,we can alter the number of levels.
If the hierarchy does not change very often and is not very large,then this new design is a good one. Note,however,that its performance is not as good as that of the Alternative II InfoCube design. We can create aggregates that compensate for the loss in performance to a certain extent.
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.