InfoCube Design Alternative II-Dimension Characteristics - SAP BW

In this section,we discuss yet another design alternative. This time,we will create a new IO_SREP,called IO_SREPN2. We will treat IO_SREG and IO_SOFF as independent characteristics,just like IO_SREPN2,and put them all together in the same dimension. Figure shows a simplified star schema for this design.
BW STAR SCHEMA OF ALTERNATIVE II INFOCUBE DESIGN
BW STAR SCHEMA OF ALTERNATIVE II INFOCUBE DESIGN

In Figure,/BIC/SIO_SREG and /BIC/SIO_SOFF have their own master data table and text table.This design methodology is known as the Dimension Characteristics method. The following steps explain how to build this new design.

Work Instructions:
Step 1. Repeat the Steps to create IO_SREPN2. It has no hierarchies.
Work Instructions

Step 2. Create an InfoCube and include IO_SREG and IO_SOFF as characteristics.
Edit Info cube: Characterstics

Step 3. Assign IO_SREG,IO_SOFF,and IO_SREPN2 to the same dimension as shown in this screen.Click Clickto check the new InfoCube. If it is valid,clickClick to activate the new InfoCube.
new InfoCube

Step 4. We also need to include IO_SREG and IO_SOFF in the communication structure.
Step 5. Load data into the new InfoCube and create a query.In the left panel,we see the three characteristics Sales office,Sales region,and Sales representative. They are all in the same dimension.
Step 6. As before,we specify 31.12.9999 as the key date,and run the query.
Query properties

Result:
Screen shows the query result. The Denver office is listed under the Midwest region,instead of the West region,although we specified 31.12.9999 as the key date. This result arises because the sales transactions conducted by the Denver office all took place before January 1,2000 (see Table). In the data warehousing world,this query result is referred to as a yesterday-or-today scenario—the data were valid when they were generated.

In a yesterday-and-today scenario,the data that were valid yesterday and today are displayed. In our example,we would not see the Denver office data in a yesterday-and-today scenario. For further information on this scenario,refer to ASAP for BW Accelerator,"Multi-Dimensional Modeling with BW."Now we know that our new InfoCube design does not provide the two views of data that we saw earlier with the time-dependent hierarchy structure and time-dependent navigational attributes—namely,the today-is-yesterday scenario and the yesterday-is-today scenario.
hierarchy structure

Note:
From a performance point of view,this design improves upon the two earlier options,because it places IO_SREG and IO_SOFF closer to the fact table.Performance is,of course,one of the major concerns in data warehousing. Here are some guidelines for dealing with this issue:

  1. If IO_SREG and IO_SOFF data are included in the transaction data, as shown in Table, use IO_SREG and IO_SOFF as dimension characteristics instead of characteristic attributes.

SALES DATA
SALES DATA

  1. If IO_SREG and IO_SOFF are frequently used for navigation,use IO_SREG and IO_SOFF as dimension characteristics instead of characteristic attributes.

When considering the dimension in which a characteristic should be placed,follow these two guidelines:

  1. If the characteristics,such as IO_SREG, IO_SOFF,and IO_SREPN2,have a one-to-many relationship,group them in the same dimension.
  2. If the characteristics,such at IO_MAT and IO_CUST,have a many-to-many relationship,group them in different dimensions. In some special cases,when the combinations of the relations are small,such as materials and colors,you might consider grouping them within one dimension.

Another advantage of this InfoCube design is that we can create aggregates on IO_SREG and IO_SOFF. As in Alternative I,however, the levels of the sales organization are fixed in Alternative II.


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

SAP BW Topics