InfoCube Design Alternative III— Time-Dependent Entire Hierarchies - SAP BW

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
(a)
A COMPARISON OF TWO TYPES OF HIERARCHIES
(b)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.

Work Instructions:
Step 1. Create a new IO_SREP,called IO_SREPN3. Select the Entire hierarchy is time-dependent option.
Work Instructions

Step 2. Select Create hierarchy from the InfoObject menu.
Create hierarchy from the InfoObject menu.

Step 3. Specify the valid dates,and then click clickto continue.
Create Hierarchy

Step 4. Using the procedure given,create a hierarchy. Notice that the Denver office is placed in the West region.
Maintain HierarchyMaintain Hierarchy

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.
Maintain HierarchyMaintain Hierarchy

Step 6. Notice the two hierarchies. Each has an associated valid date.
Administrator work bench modelling

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

Result:
The first query result shows that the Denver office is located in the West region.
Result

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

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.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics