Databases Reference
In-Depth Information
Syntax:
import database <app-name>.<db-name>
data
|
dimension
:
data
is used when we are loading data into the cube. Use
dimension
for updating dimension in the outline.
connect as <Database Username>
: Since we are loading the data from a relational
database, please specify the user name here.
IDENTIFIED BY <Database password)
: Specify your relational database password.
USING
(Information about the Rules File)
LOCAL
|
SERVER
: Location of the rules file
RULE_FILE
RULE FILE NAME
: Name of the rule file
ON ERROR APPEND TO
(error File information)
WRITE
|
APPEND
ERROR FILE NAME
: Path for error file
C:/book/dataload.err
Code Sample:
import database 'ESSCAR'.'ESSCAR' data
connect as 'hypuser' identified by 'password'
using server rules_file 'dSales'
on error write to 'C:/book/dataload.err';
The
export
MaxL statement is used to export the level 0 data, all of the data, or just
the input data from the Essbase cube into a text file. This function is mainly used for
data retention as per company policy or backing up critical data.
Syntax:
export
database
<app-name>
.
<db-name>;
all | level 0 | input
:
all
indicates all levels of data,
level 0
indicates only leaf
node data which excludes the aggregated data, and
input
indicates only input data.
data in columns to data_file <File-name>;
Code Sample:
export
database
'ESSCAR'.'ESSCAR' all data to data_file 'C:/book/
export_data.txt';