The Essbase models you build with the Cube Schema Wizard are used to deploy cubes to Essbase Server. Cube deployment is a process of setting load options in order to build an outline and load data into an application and database. The outline you build is editable in Administration Services Console. The application and database you create is accessible from Smart View and Essbase Spreadsheet Add-in.
Using the Cube Deployment Wizard, you can choose from several load options when you deploy a cube:
Build outline only
Load data only
Build outline and load data
Load members incrementally
Delete members from a cube before loading
Delete and restore data to a cube
Create and save an Essbase rules file, which you can use to load members or data or both at a later time
Create and save a MaxL load script containing all the cube deployment options you have selected, which you can use to load members or data or both at a later time
Depending on how you set the server.essbase.streamingCubeBuilding server property, and the options you choose in the Data source settings group in the Cube Deployment Wizard, you can adjust how data is retrieved during a cube deployment . See Deployment Scenarios and Streaming Cube Building Property Considerations.
If you used a date measure in your cube schema, see Deploying Date Measures for information on performing cube deployment so that data is aggregated correctly.
If you did not choose to create an Essbase model during cube schema creation, you can create one at any time. You can also create more than one Essbase model for the same cube schema, as described in Creating Essbase Models from Existing Cube Schemas. After creating the Essbase model, launch the Cube Deployment Wizard and complete the first page, as described in Providing Connection Information for Cube Deployment. From the wizard, you can also modify Essbase properties for the selected model, as described in Essbase Properties.
Note: | This chapter describes deploying cubes using the Cube Deployment Wizard. You may also deploy cubes using the MaxL deploy command. An option in the Cube Deployment Wizard creates the deploy script automatically. All the options that are available in the Cube Deployment Wizard are also available in the deploy command and are recorded in the MaxL script. See the MaxL documentation in the Oracle Essbase Technical Reference for information. |