BUILDDIM

Dynamically builds one or more dimensions from a data file or SQL source.

Syntax

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.

Description

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:

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";

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com