Dynamically builds one or more dimensions from a data file or SQL source.
Syntax
BUILDDIM location rulobjName dataLoc sourceName fileType errorLog| Parameter | Description |
|---|---|
location | Location of the rules file. 1 - Local/client. 2 - Remote/server. 3 - File. Use the file is not an Essbase artifact, or if you want to specify the full path name. Otherwise, Essbase looks in the <APPNAME>/<DBNAME> directory. |
rulobjName | Name of the rules file |
dataLoc | Location of the data file. 1 - Local/client 2 - Remote/server 3 - File. Use if the file is not an Essbase artifact, or if you want to specify the full path name. Otherwise, Essbase looks in the <APPNAME>/<DBNAME> directory. 4 - SQL source. |
sourceName | Source of the data file. If dataLoc is 1, 2, or 3, specify the data file name. If dataLoc is 4, specify the SQL user name and password. |
fileType | Data file type. 1 - Excel 2 - Lotus .WK1 file (No longer supported) 3 - Lotus .WK3 file (No longer supported) 4 - Text. 5 - Lotus .WK4 file (No longer supported) This parameter is not required if you are using an SQL source. |
errorLog | Name of the text file to receive error messages and rejected records. |
Notes
This command builds one or more dimensions from a data file or an SQL source. Many applications have large dimensions that are impractical to manually define and maintain. This command makes it possible to automate the dimension-building and updating processes. See the INCBUILDDIM command for another way to build dimensions.
The INCBUILDDIM command is identical to the BUILDDIM command, except for the following:
INCBUILDDIM does not automatically restructure the database after modifying the dimensions. You can have several consecutive INCBUILDDIM, commands inside a BEGININCBUILDDIM...ENDINCBUILDDIM block. Essbase restructures when it encounters ENDINCBUILDDIM.
INCBUILDDIM lets you append to, rather than overwrite, the error log.
Example
To build the dimensions as defined by the rules file, PROD.RUL:
BUILDDIM 1 "PROD" 1 "PRODUCTS" 4 "PRODERR";
To build the dimensions from an SQL table defined in the rules file, PROD.RUL:
BUILDDIM 1 "PROD" 4 "TomT" "Password" "PRODERR";