Dimbuild: Load Dimensions to a Cube
The dimbuild CLI command for Essbase loads dimensions to a cube. To run this command, you need at least Database Manager permission for the cube.
Before you can load dimensions, you must first upload the dimension-build and rule files to Essbase. You can use the CLI to upload files. See Upload: Add Cube Files.
Syntax
dimbuild [-verbose] -application appname -db cubename -file fileName [| -catalogfile catalogFile] -rule rulesFile [| -catalogrulefile catalogRulesFile]] [-user userName [-password password]] [-stream] [-connection connectionName][-query queryString] [-rows n]] [-restructureOption restructureOption] [-forcedimbuild]
Option | Abbreviation | Description |
---|---|---|
-verbose | -v | Show extended descriptions |
-application | -a | Application name |
-db | -d | Database (cube) name |
-file | -f | Dimension build file name. You do not need to give a full path. Files are assumed to be in the relevant application or database directory. You can use -catalogfile in place of this option. |
-rule | -r | Rule file name. You do not need to give a full path. Files are assumed to be in the relevant application or database directory. You can use -catalogrulefile in place of this option. |
-catalogfile | -CF | Dimension build file name from the file catalog. You can use this option in place of -file. |
-catalogrulefile | -CRF | Rule file name from the file catalog. You can use this option in place of -rule. |
-user | -u | Optional. User name. Requires password if used.
If you are using a saved connection and Datasource, no user name and password are required. If you are not using a saved connection, and the rule file connects to an RDBMS, specify the user name and password to connect to the RDBMS. |
-password | -p | Optional. Password for user. If omitted, user will be prompted for password. |
-stream | -S | Optional. Use streaming dimension build. Requires -conn option if used. |
-connection | -conn | Required if streaming option is used. Name of a saved connection that was created using the createlocalconnection CLI command. |
-query | -q | Optional. Database query to submit along with the streaming dimension build. |
-rows | -rows | Optional. Number of rows to stream simultaneously. Default is 100. |
-restructureOption | -R |
Controls your preservation choices for the outline restructure. For block storage, possible options are:
For aggregate storage, possible options are:
|
-forcedimbuild | -F | Continue the dimension build even if other user activities are in progress. This cancels active user sessions. |
Examples
esscs dimbuild -a Sample -d Basic -r Basic.rul -u smith -p password -R NO_DATA -F
esscs dimbuild -a Sample -d Basic -r Basic.rul -S -conn oraConn -q "Select * from Data" -rows 50 -R NO_DATA
esscs dimbuild -a Sample -db Basic -CRF /users/weblogic/Dim_Market.rul -CF /shared/Market.txt -R ALL_DATA -F
You can also load dimensions using Cube Designer, Jobs in the Essbase web interface or REST API, or import dimensions in MaxL.