Dynamically builds one or more dimensions from a data file or SQL source.
BUILDDIM location rulobjName dataLoc sourceName fileType errorLog
Parameter | Description/Values |
location |
Location of the rules file. 1 - Local/client-based rules file. 2 - Remote/server rules file. 3 - File. Use option 3 if the file is not an Analytic Services object, or if you want to specify the full path name. Otherwise, Analytic Services looks in the < APPNAME >/<DBNAME > directory. |
rulobjName | Name of the rules file |
dataLoc | Location of the data file. 1 - Local/client data file. 2 - Remote/server data file. 3 - File. Use option 3 if the file is not an Analytic Services object, or if you want to specify the full path name. Otherwise, Analytic Services 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 file. 2 - Lotus .WK1 file. 3 - Lotus .WK3 file. 4 - Text file. 5 - Lotus .WK4 file (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. |
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:
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";
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |