Steps in BI7.0 to Create Cube

What is steps in BI7.0 to Create Cube?

Procedure:

1.  Create an InfoArea to which the new InfoCube should be assigned.
To do this, choose Modeling (r) InfoProvider.

2.  In the context menu of the InfoArea, choose Create InfoCube.

3.  Select either Standard or Real Time as the InfoCube type.
Choose Create.
If you want to create a copy of an already existing InfoCube, you can enter an InfoCube as a template.
The Edit InfoCube screen appears.

4.  Transferring InfoObjects:
On the left side of the screen, there are various templates to choose from.
These allow you to get a better overview in relation to a particular task.
For performance reasons, the default setting is an empty template. You use the pushbuttons to select different objects as templates.

The InfoObjects that are to be added to the InfoCube are divided into the categories characteristic, time characteristic, key figure and unit. You have to transfer at least one InfoObject from each category.

On the right side of the screen, you define the InfoCube. Use drag and drop to assign the InfoObjects in the dimensions and the Key Figures folder. You can select several InfoObjects at once. You can also transfer entire dimensions using drag and drop. The system assigns navigation attributes automatically. These navigation attributes can be switched on to analyze data in BEx.

Or:

You can insert InfoObjects without selecting a template in the left half of the screen. This is useful if you know exactly which InfoObjects you want to include in the InfoCube. Choose Insert InfoObjects in the context menu for the folders for dimensions or key figures. In the dialog box that appears, you can enter and transfer up to ten InfoObjects directly, or you can select them using input help. You can use drag and drop to reassign them.

5.  Details and object-specific properties:
If you double click on an InfoObject, the detail display of this InfoObject is displayed. In the context menu of an InfoObject, you can make additional settings under Object-Specific Properties. .

6.  Create dimensions: The dimensions data package, time, and unit are available as the default setting. The data package dimension contains technical characteristics. Time characteristics and units are automatically assigned to the corresponding dimensions. In the context menu of the Dimensions folder, you can create additional dimensions under Create New Dimensions.

If a dimension only has one characteristic, or it has a large number of values, you need to set the Line Item or High Cardinality indicator.

7.  In the context menu of the Key Figures folder you can Insert
New Hierarchy Nodes. In this way you can sort the key figures in a hierarchy. You then get a better overview of large quantities of key figures in query definition.

8. Save or Activate the InfoCube.

Only an activated InfoCube can be supplied with data and used for reporting and analysis.

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP BW Books
SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.