New In 7.1
New In 7.0
New In 6.5.4
New In 6.5.1
New In 6.5
MaxL DDL Statements
Query Database statement |
Top |
The query database statement returns a variety of information about the current state of the database.
See query database.
You can add filter definition rows to an existing filter. See alter filter.
You can correct dangling or invalid partition errors using MaxL. See alter partition.
You can use the following statements to perform the following Unicode-related tasks:
The following MaxL statements aid in database object management:
Metadata filtering provides an additional layer of security in addition to data filtering. With metadata filtering, an administrator can remove outline members from a user's view, providing access only to those members that are of interest to the user. See Metadata Filtering.
The MaxL Shell recognizes any statement beginning with WITH or SELECT as an MDX statement, and returns the query results in the form of a grid. See MDX.
Triggers help you define administrative alerts or other events related to the current state of data in a database.
See:
create or replace trigger
You can use MaxL to load single data records into a database. For example, See import data.
Errors in MaxL are flagged as STDERR, allowing command-line redirection of errors using operating-system redirection handles. You can also redirect STDERR and STDOUT independently to different MaxL output logs. See Spool On/Off (Description section).
The Alter Database statement contains the following new grammar: set default calculation CALC-STRING; set ha_trace... (for Hybrid Analysis tracking) set active alias_table... set performance statistics... recover freespace; force restructure; load | unload alias_table... delete lro... unlock all objects;
The following list of ESSCMD commands now have an equivalent MaxL statement, and conversions from these commands to MaxL are supported by the cmd2mxl utility. Only the commands which map to new MaxL grammar for Release 7.0 are listed. For the full mapping, see ESSCMD to MaxL Conversion. GetDefaultCalc
|
Undo Forced Password Change |
Top |
With the following grammar, an administrator can undo a previous decision to force a user to change his or her password at the next login:
alter user USER-NAME set password_reset_days exact;
See alter user.
Display user has a new column |
Top |
When the display user
MaxL statement is issued, MaxL displays a table of information about users on the system.
A new column called change_password indicates whether a password change will be required at the next login.
See display user.
MaxL Statements for Security Platform User Management |
Top |
You can set up Analytic Services to use your corporate external-authentication scheme; this functionality is supplied by the Hyperion security platform.
For information about the security platform, see Introduction to the Security Platform. For the associated MaxL user-management statements, see MaxL Statements for External User Management.
MaxL Shell Output Column Widths |
Top |
In previous releases, the column size for MaxL Shell output was limited to 128 bytes.
Now, you can set the column width to any value of 8
or higher.
Documentation Update for no_access |
Top |
Granting any privilege, including calculation and filter privilege, on a database also grants the implicit ability to load the application containing that database. To remove this ability, you must grant no_access to the application, not just to the database.
Limitation on Whitespace in Names |
Top |
User names, server names, and passwords cannot include spaces at the beginning or at the end.
See definitions for USER-NAME, HOST-NAME, and PASSWORD.
Improved Security File Backup |
Top |
In the event that security file corruption occurs, Analytic Services provides an improved way of restoring security information. The security backup file can be synchronized to the security file regularly, rather than each time the Analytic Server starts. This ensures that the security backup file is as up-to-date as possible.
Analytic Services compares the security backup file essbase.bak
to the security file essbase.sec
at specified intervals and on demand, instead of only when the Analytic Server starts. When Analytic Services compares the files, it updates the backup file to match the security file if there are any differences.
To synchronize the security backup file on-demand to the current state of Analytic Services security, use
alter system sync security_backup;
To set a frequency for automatic comparisons and synchronizations of the security backup file to the security file, use the session_idle_poll
setting in alter system. The time interval you specify in the session idle poll tells Analytic Services both of the following:
session_idle_limit
in the alter system statement.session_idle_poll
is set to zero, the security backup file is still refreshed every five minutes.See alter system.
ZLIB as Database Compression Algorithm |
Top |
In addition to the database compression options previously being provided (RLE, bitmap compression, or no compression), Analytic Server now supports ZLIB compression. This method is used in packages like PNG, Zip, and gzip.
To set ZLIB as the compression type for a database, use
alter database DBS-NAME set compression zlib;
See alter database.
Reset Database Functionality |
Top |
Previous database reset functionality cleared all data from the database. Now you can optionally clear the database of data and metadata (index files, page files, and outline) and preserve any partition definitions, calculation scripts, load rules, and other associated database objects that you want to keep.
To clear only data (including linked reporting objects), use
alter database dbs-name reset data;
To clear data (including linked reporting objects) and the outline, use
alter database dbs-name reset all;
See alter database
Invalid Block Header Correction |
Top |
Now you can assess the severity of "invalid block header" errors, and use MaxL to repair the corruption indicated by the presence of invalid block headers.
To search for the cause of invalid block header errors, use
alter database DBS-NAME validate data to local logfile 'FILE-NAME';
Analytic Services creates a local log file with all index combinations for which blocks contain invalid block headers.
To repair invalid block header corruption, use
alter database DBS-NAME repair invalid_block_headers;
Analytic Services deletes all blocks that have invalid headers.
See alter database.
Outline Synchronization for Partitioned Databases |
Top |
Outline synchronization for partitioned databases is now available through MaxL, using the refresh outline grammar.
Advanced Display Partition Shows More Details |
Top |
When the advanced
keyword is used, the display output generated by
display partition contains two new fields of information. The new fields are time_source_updated
and time_target_updated
.
The times can be compared, enabling you to determine if the outline needs to be synchronized. If the ouline needs to be synchronized, use refresh outline.
Export-LRO Directory Cleanup |
Top |
The following grammar deletes directories created for linked-reporting objects exported from a database to a directory created in $ARBORPATH\app:
alter system delete export_directory EXPORT-DIR;
Use the export-directory cleanup statement after the exported LROs have already been migrated into a database (using import lro) and the directories containing the exported LRO information are no longer needed.
To view a list of names of exported linked-reporting-objects directories in $ARBORPATH\app
, use display system export_directory
.
See alter system and display system.
alter database Sample.Basic set io_access_mode direct;
Example:
create user 'O\'Brian' identified by 'password';
See complete quoting and escape-sequence rules for both MaxL and the MaxL Shell.
The MaxL Shell has invocation flags that can be used to accomplish various tasks in advance before the shell is launched; for example, the -l flag allows you to specify a login host as an argument to the shell. With Release 6.5, setting the message level returned by the shell is also available as an invocation option, the -m flag. See Interactive Input for MaxL Shell invocation.
In the MaxL Shell, you can use variables as placeholders for any data that is subject to change or to which you refer often. Prior to Release 6.5, the MaxL Shell allowed variables to be either positional parameters or environment variables. In Release 6.5, the flexibility of positional parameters is increased; also, a new type of variable can be used: locally defined shell variables.
Positional Parameters:
These variables are passed in to the shell at invocation time as arguments, and can be referred to generically by the subsequent script or interactive MaxL Shell session using $n, where n is the number representing the order in which the argument was passed on the command line.
For example, if the shell is started with the variable values provided,
essmsh -a arg1 arg2
The MaxL statements in the subsequent session can use $1 to refer to arg1, $2 to refer to arg2.
Additionally, with Release 6.5, you can change $1 to mean arg_new in the same MaxL Shell session, using the following syntax:
set 1 = arg_new;
In other words, you can reset the value associated with the positional parameters, without needing
to exit the shell and start again, passing new arguments.
Note: If you nest MaxL Shell scripts or interactive sessions, the nested shell does not recognize positional parameters of the parent shell. The nested shell should be passed separate arguments, if positional parameters are to be used.
Locally Defined Shell Variables:
With Release 6.5, you can create variables of any name in the MaxL Shell without the use of arguments or positional parameters. These variables persist for the duration of the shell session, including in any nested shell sessions.
Example:
MaxL>login user1 identified by password1;
MaxL>set var1 = sample;
MaxL>echo $var1; /* see what the value of $var1 is */
sample
MaxL>display application $var1; /* MaxL displays application "sample" */
Note: Locally defined variables can be named using alphabetic characters, numbers, and the underscore (_). Variable values can be any characters, but take note of the usual quoting and syntax rules that apply for the MaxL Shell.
display function on system;
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |