Start of Content Area

Procedure documentation Create MOLAP Cube Locate the document in its SAP Library structure

Use

In order to work with MOLAP aggregates, you firstly need to create a MOLAP Cube.

(See MOLAP Cube (Root Aggregate))

Prerequisites

The BW system must be connected to a Microsoft Analysis server via the SAP MOLAP Bridge.

The InfoCube for which you want to create an aggregate has been saved and is active. There are not yet any aggregates for the selected InfoCube.

Procedure

  1. You are in the Modeling function area of the Administrator Workbench. In the navigation window, choose InfoProvider.
  2. In the InfoProvider tree, navigate to the InfoCube whose queries you want to optimize.
  3. In the context menu of the InfoCube choose Change. The Edit InfoCube screen appears.
  4. Choose MOLAP Store from Extras. The Multidimensional Cube dialog box appears.
  5. Process the window areas from top to bottom. The system supports this process with traffic lights and system messages.

MOLAP Cube: Structure

This graphic is explained in the accompanying text Mapping possible?

Traffic light display

This graphic is explained in the accompanying text Check

This graphic is explained in the accompanying text Does MOLAP Cube exist?

Traffic light display

This graphic is explained in the accompanying text Refresh

This graphic is explained in the accompanying text Create

This graphic is explained in the accompanying text Delete

MOLAP Cube: Data

This graphic is explained in the accompanying text MOLAP Cube processed?

Traffic light display

This graphic is explained in the accompanying text Check

Loading Data:
  • complete
  • refresh

This graphic is explained in the accompanying text Execute

in the background
      1. Check to see if Mapping is possible When the traffic light displays This graphic is explained in the accompanying text to check, choose This graphic is explained in the accompanying text Check. You can find additional information about the structural properties of a MOLAP Cube relevant here under MOLAP-Cube (Root Aggregate).
      2. If Mapping is possible, you can create a MOLAP Cube on the Microsoft Analysis server. (You can find additional information about restrictions set by Microsoft Analysis Services under Conditions for BW InfoCubes.)

        3. Background documentation 

        This step is approximately the same as when activating an InfoCube in BW. Database views, MOLAP dimensions, MOLAP Cube partitions and finally the MOLAP Cube are created.

      3. Finally, you can process the MOLAP Cube. In this step, the MOLAP Cube is filled with data.

Choose the fill mode.

Recommendation 

If the MOLAP Cube is to be filled with data for the first time, choose complete

If you want to load new data into the MOLAP Cube , choose refresh.

Choose how the system is to carry out the processing.

Recommendation

When the basis BW InfoCube only contains a small amount of data, we recommend you immediately start processing using This graphic is explained in the accompanying text Execute in the dialog box. In this way, you can follow the actions immediately.

When the basis BW InfoCube contains a large amount of data , we recommend that you schedule processing in the background.

Result

A MOLAP Cube is now available as the result of this procedure.

End of Content Area