Click here for non-aggregate storage version
Import data from text or spreadsheet data files, with or without a rules file. Minimum permission required: Write.
See Loading Data Using Buffers for an example.
Use import data in the following ways to load data into an aggregate storage database:
Key Phrase | Explanation |
---|---|
import database <dbs-name> data from... | Specify whether the data import is from a local or server file, and what type of file to import data from. |
...using ... rules_file | Import data into the database using a specified rules file. |
...<data error spec> (on error...) | Required. Tell Essbase what to do in case of errors during the data load: abort the operation, or write or append to a specified error log. |
...<data record spec> from data_string | Load a single data record into the selected database. |
...<SQL connect spec> (connect as...) | If you are importing data from an SQL source, provide your SQL user name and password. You must always use a rules file when you load SQL data sources. |
...to load_buffer with buffer_id | If you are importing data from multiple data files and you are using aggregate storage, you can import to a buffer first, in order to make the data import operation more efficient. For more information, see Loading Data Using Buffers. |
...from load_buffer with buffer_id | If you are importing data from multiple data files and you are using aggregate storage, you can import from a data load buffer in order to make the data import operation more efficient. For more information, see Loading Data Using Buffers. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |