Display Application

application

String. Name of the application.

comment

String. Optional description of the application.

startup

TRUE or FALSE. Whether all users who have at least read permission can start the application.

autostartup

TRUE or FALSE. Whether the application starts when Essbase Server starts.

minimum permission

String. Minimum level of permission all users can have to databases in the application.

connects

TRUE or FALSE. Whether any user with a permission lower than Application Manager can make connections to the databases in this application which would require the databases to be started.

commands

TRUE or FALSE. Whether users with sufficient permissions can make read requests (or higher) to databases in the application.

updates

TRUE or FALSE. Whether users with sufficient permissions can make write requests (or higher) to databases in the application.

security

TRUE or FALSE. If FALSE, the Essbase security settings are disabled for the application, and all users are treated as Application Managers.

lock_timeout

Number. Maximum time interval (in seconds) that locks on data blocks can be held by clients.

max_lro_file_size

Number. If 0, there is no limit on the size of LRO attachments. All other sizes are displayed in kilobytes.

application_type

The type of encoding for the application.

0       Unspecified encoding type. The application was created using a pre-Release 7.0 version of Essbase.
1       This value is not in use.
2       Non-Unicode-mode application
3       Unicode-mode application

application_locale

The language of the character set in use by the application.

server

The name of the computer hosting the Essbase Server.

application_status

0       Not Loaded
1       Loading
2       Loaded
3       Unloading

elapsed_time

How long the application has been loaded.

users_connected

The number of users currently connected to the application.

storage_type

0       Default data storage
1       Multidimensional data storage
2       DB2 relational data storage
3       Oracle relational data storage
4       Aggregate storage
5.......Hybrid analysis

number_of_databases

How many databases are in the application namespace.