This content has been marked as final. Show 4 replies
To create a cube follow the below steps;
1.Expand the folder for the analytic workspace.
2.Right-click Cubes, then choose Create Cube. The Create Cube dialog box is displayed.
3.On the General tab, enter a name for the cube and select its dimensions.
4.On the Aggregation tab, click the Rules subtab and select an aggregation method for each dimension. If the cube uses more than one method, then you may need to specify the order in which the dimensions are aggregated to get the desired results. You can ignore the bottom of the tab, unless you want to exclude a hierarchy from the aggregation.
5.If you run the advisors after mapping the cube, Oracle OLAP can determine the best partitioning and storage options. However, if you want to define these options yourself, then complete the Partitioning and Storage tabs before creating the cube.
6.Click Create. The new cube appears as a subfolder under Cubes.
To import the Essbase cube, select File => Import => from Multi-dimensional. The Import from Multi-dimensional window appears.
Enter the following values:
Provider Type: "Essbase";
Essbase Server: "<name of machine hosting the Essbase server>";
Username: "<Essbase user>";
Password: "<Essbase password>"