Import Dimensions

Import dimensions from text or spreadsheet data files, using a rules file. Minimum permission required: Write.

Syntax

Notes

Example

import database sample.basic dimensions
from data_file '/data/calcdat.txt'
using rules_file '/data/rulesfile.rul'
on error append to '/logs/dimbuild.log';

Incremental Dim Build Examples

For Data File Sources:

import database sample.basic dimensions 
from server text data_file 'genref' using server rules_file 'genref' suppress verification,  
from server text data_file 'level' using server rules_file 'level' suppress verification,  
from server text data_file 'time' using server rules_file 'time' suppress verification 
preserve input data on error append to 'C:\Hyperion\EAS\eas\client\dataload.err';

For SQL Sources:

import database sample.basic dimensions 
connect as 'usrname1' identified by 'password1' using server rules_file 'genref',  
connect as 'usrname2' identified by 'password2' using server rules_file 'level',  
connect as 'usrname3' identified by 'password3' using server rules_file 'time'
on error append to 'C:\Hyperion\EAS\eas\client\dataload.err';

For Data and SQL Sources:

import database sample.basic dimensions 
from server text data_file 'genref' using server rules_file 'genref',  
from server text data_file 'level' using server rules_file 'level',  
connect as 'usrname1' identified by 'password1' using server rules_file 'genref',  
connect as 'usrname2' identified by 'password2' using server rules_file 'genref'  
on error append to  'C:\Hyperion\EAS\eas\client\dataload.err';

Descriptions

You can import dimensions to a database in the following ways using import dimensions.

Key Phrase Explanation
import database <dbs-name> data from... Specify whether the dimension import is from a local or server file, and what type of file to import the dimension from.
...using ... rules_file Import dimensions into the database outline using a specified rules file.
...enforce verification Verify the outline resulting from the dimension build. This is the default behavior.
...suppress verification Do not verify the outline resulting from the dimension build.
...preserve all data If you need to preserve all data when importing dimensions, specify that here.
...on error... Tell Essbase what to do in case of errors during the dimension build: abort the operation, or write or append to an error log.
...<SQL connect spec> (connect as...) If you are importing dimensions from an SQL source, provide your SQL user name and password. You must always use a rules file when you load SQL data sources.
...<preserve spec alt> (preserve...data) If you need to preserve level-0 or input data when importing dimensions, specify that here.

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