Syntax

• APP-NAME

• DBS-NAME

• OBJ-NAME

Keywords

You can display objects in the following ways using MaxL display object.

display object [all]

Display all stored objects on the specified scope.

Example:

display object;

display locked object...

Display only locked objects on the specified scope.

Example:

display locked object on application Sample;

display object of type OBJ-TYPE

Display only the objects of a specific type. Valid object types (OBJ-TYPE) in Essbase 21c are: outline, calc_script, report_file, rules_file, text, partition_file, lro, and worksheet. To display alias tables, use query database appname.dbname list alias_table instead of display object.

Example:

display object of type calc_script;

display object OBJ-NAME of type OBJ-TYPE

Display a specific object by name and type.

Example:

display object sample.basic.Calcdat of type text;

display object ...on system

Display all objects, or all specified objects, that exist on the Essbase Server.

Example:

display object of type rules_file on system;

display object ...on application APP-NAME

Display objects associated with the specified application. Does not include database objects.

Example:

display object all on application Sample;

display object ...on database DBS-NAME

Display objects associated with the specified database.

Example:

display object of type text on database Sample.Basic;

Example Including Output

MAXL> display object sample.basic.Data_Basic of type text;

 application  database     object_name  object_type  locked       locked_by    locked_time
+------------+------------+------------+------------+------------+------------+------------
 Sample       Basic        Data_Basic              9        FALSE N/A          N/A

The object_type output column is numeric, and the values translate as follows:

1	outline
2	calc_script
3	report_file
4	rules_file
8	worksheet
9	text
10	partition_file
11	lro