Essbase - MaxL

Essbase Overview

About

Maxl is a multidimensional database access language that is part of Essbase - Servers provides a flexible way to automate Essbase administration and maintenance tasks.

A MaxL Shell script can be executed from:

Press F5 to start a script in the Essbase - Administration Services Console

DOS Commande Line

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>echo %ARBORPATH%
E:\Hyperion\products\Essbase\EssbaseClient

C:\Documents and Settings\Administrator>cd E:\Hyperion\products\Essbase\EssbaseClient

C:\Documents and Settings\Administrator>e:

E:\Hyperion\products\Essbase\EssbaseClient>ESSMSH

 Essbase MaxL Shell - Release 11.1.1 (ESB11.1.1.3.0B126)
 Copyright (c) 2000, 2009, Oracle and/or its affiliates.
 All rights reserved.

MAXL> LOGIN admin password on ESSBASE11G;

 OK/INFO - 1051034 - Logging in user [admin].
 OK/INFO - 1051035 - Last login on Sunday, November 15, 2009 9:42:44 AM.
 OK/INFO - 1241001 - Logged in to Essbase.

MAXL> quit;

  MaxL Shell completed





Discover More
Essbase Overview
Essbase - (Dimension|Outline) Build

Building dimensions (known also as building outline) is the process of loading dimension and members data into an Essbase database outline by using a data source and a dimension build rules file. When...
Essbase Folders Structure
Essbase - Application (Directory Structure)

An Essbase application is a management structure that contains : one or more database (cube) and related files called artifacts Essbase applications and databases reside on an essbase servers....
Essbase Overview
Essbase - Creating / Copying a database

When you create a database, Essbase creates a subdirectory for the database within the application directory. The new subdirectory has the same name as the database. For example, ARBORPATH/app/app1/dbname1....
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...
Essbase Overview
Essbase - Data load in a parent member overwritten by consolidation

If you work with a block storage database (not aggregate storage) and then you load data into a parent member, when you calculate the database, the consolidation of the children’s data values can overwrite...
Essbase Overview
Essbase - EssCmd

EssCmd (Essbase Command Script) is a shell script and is replaced progressively by . ESSCMD Batch Processing...
Essbase Overview
Essbase - How to produce report ?

To produce reports, Essbase provides several clients and options: Use the Report Writer option in Essbase to select commands and options. Use a spreadsheet in Essbase template retrieval mode. Execute...
Essbase Overview
Essbase - Location Aliases

A location alias is a descriptor for a data source. A location alias maps an alias name for a database to the location of that database. A location alias specifies : an alias, a server, an application,...
Essbase Overview
Essbase - Locking and Unlocking Outlines

In , an is always locked when it is opened in edit mode. Essbase unlocks the outline when the outline is closed. When an outline is locked, Essbase does not allow other users to save over, rename, delete,...
Essbase Overview
Essbase - Locking and unlocking artifacts

Essbase uses a checkout facility for database to ensure that only one user modifies an at one time. This section describes how to lock and unlock artifacts, with the exception of . See . By default,...



Share this page:
Follow us:
Task Runner