Databases Reference
In-Depth Information
•
Database objects
: These commands are used to list database objects and
their lock statuses, if any. Also, you can copy and rename database objects,
and view or remove URLs, cell notes, or database partitions linked to
the database.
•
Outline/Attribute information
: Use these commands to view outline
member information, member attribute information, current attribute
naming specifications, and to view the outline paging information.
•
Dimension building
: This group of commands can be used to build
one or more dimensions from data files or SQL sources. You can
build multiple dimensions incrementally and decide how you want
the database restructured after the dimension build is complete.
•
Data loading, clearing, and exporting
: Use these commands to load
your data from files or from individual records or to clear all data
from a database or to export and import data to and from text files.
•
Calculating
: These commands can be used to run calc scripts, execute
one or more calc strings, run or change the default database calculation,
and view information about calcs associated with outline members.
•
Reporting
: Use these commands to execute report scripts or to run one
or more report strings individually.
•
Partitioning
: This group of commands can be used to load or unload
data from a database partition or even produce a text file version of a
partition mapping.
•
Outline synchronization
: These commands are actually used in conjunction
with partitioned databases to keep the target database outline synchronized
with changes made to the source database outline.
•
Error and log handling
: Use these commands to set conditional or
unconditional error branching from EssCmd scripts, redirection of process
information output, specifying what level of detail messages are displayed
in, and clearing the application log file when necessary.
•
Currency conversion information
: These commands are used to get
information about currency databases linked to the currently selected database.
•
Location aliases
: These commands manage location aliases used in a
distributed analytic services environment. Location aliases are names
that are used in place of server addresses, applications, databases, user IDs,
and passwords.
