Multi-Cubes - SAP BW

Aggregates reduce data retrieval volume by creating small,virtual InfoCubes from the original InfoCube. A multi-cube seems to work in the opposite manner,by combining multiple InfoCubes to build a larger InfoCube. The larger InfoCube contains no data,however.

A good multi-cube example is BW Statistics,which will be discussed in Section.
The following steps show how to create a multi-cube.

Work Instructions:
Step 1. Suppose we have another InfoCube for delivery,and its data model is as shown in Screen.We would like to build a new InfoCube that brings the previous sales InfoCube and the new delivery InfoCube together to give a bigger picture of business,from sales to delivery.
Work Instructions

Step 2. Follow the procedure to create a new InfoCube. Enter a name and a description,select the MultiCube option,and then click to continue.
Work Instructions

Step 3. The window in Screen lists all available InfoCubes. Select the two InfoCubes IC_NEWBC2 and IC_NEWBC4 to build the new multi-cube. ClickWork Instructions to continue.
Work Instructions

Step 4. Select four characteristics from the Template table,and move them to the Structure table on the left,usingWork Instructions .
Edit Info cube characterstics

Step 5. Select a time characteristic from the Template table,and move it to the Structure table on the left,using .
Edit Info cube  time characterstics

Step 6. Select two key figures from the Template table,and move them to the Structure table on the left,using.
Edit Info cube: key figures

Step 7. Click identificationto set up the union conditions.

Edit Info cube characterstics
Edit Info cube characterstics

Step 8. Clickcreate-recomendation to get help from BW.
Identifications of characterstics Involved

Step 9. Accept the recommendation from BW,and then click to continue.
Identifications of characterstics Involved

Step 10. After checking and activating the multi-cube,display its data model. As you see,it looks like a regular InfoCube.
Administrator work bench modelling

Run transaction SE11 to display the /BIC/FIC_DEMOMC table definition. Note that the multi-cube is an ABAP structure.
Dictionary Display Structure

In the same way as we create queries for a basic cube,we can create queries for the multi-cube. Screen shows the query definition,and Screen shows its result.
Define query: New query

Microsoft Excel

As shown in Screen,when the characteristics selected by a multi-cube query are not shared across all underlying basic cubes,the query result will produce multiple lines. This is one drawback of the multi-cube technique. In this example,we want SREP08 and DAGE05 to appear in the same line.
Tracing the SQL statements during the query execution,we find out our multi-cube query was split into two subqueries on the underlying basic cubes:


Each subquery used an aggregate: aggregate 100014 for the IC_NEWBC2 (sales) subquery,and aggregate 100020 for the IC_NEWBC4 (delivery) subquery.

Note:The aggregated data are stored in the E fact table,rather than the F fact table. Section,"InfoCube Compression," provides more information on the differences between these two types of fact tables.The subqueries were processed in parallel. One work process sent the second subquery to the database without waiting for the database to return the result of the first subquery. After both subqueries received their data from the database,the same work process then presented the final result.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

SAP BW Topics