MaxL scripts do not require a particular—or any—file extension. This document uses. In UNIX shells, place single quotation marks around the path to avoid file-reading errors. In a Windows command prompt, if the path to the script contains a space, you may have to use double quotation marks around the entire path and file name to avoid file-reading errors. Starting the Shell for Programmatic Input To invoke the MaxL Shell to take input from the standard output of another program or process, use the -i flag.

Author:Turr Kejora
Language:English (Spanish)
Published (Last):7 December 2016
PDF File Size:15.51 Mb
ePub File Size:18.80 Mb
Price:Free* [*Free Regsitration Required]

Import data from text or spreadsheet data files, with or without a rules file. Minimum permission required: Write. Specify whether the data import is from a local or server file, and what type of file to import data from. 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. You must always use a rules file when you load SQL data sources. Essbase initializes multiple temporary aggregate storage data load buffers one for each rules file and, when the data is fully loaded into the buffers, commits the contents of all buffers into the database in one operation.

Each rules file must use the same authentication information SQL user name and password. In the following example, SQL data is loaded from two rules files rule1. The file name for rules files must not exceed eight bytes and the rules files must reside on Essbase Server. In initializing a data load buffer for each rules file, Essbase uses the starting data load buffer ID you specify for the first rules file in the list for example, ID for rule1 and increments the ID number by one for each subsequent data load buffer for example, ID for rule2.

If there are duplicate cells between the new data and the primary slice, their values are added together when you query for them. Notes This statement requires that the database is started.

When using the import statement, you must specify what should happen in case of an error. To import from a SQL data source, you must connect as the relational user name and use a rules file. Example import database ASOsamp. Sample database. Sample database by adding values. Sample database with the contents of the specified data load buffer.

Sample database by creating a new data slice with the contents of the specified data load buffer.


MaxL et ESSCMD, les langages d'administration d'Essbase



Join the world’s largest interactive community dedicated to Oracle technologies.


Related Articles