1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements (Aggregate Storage)
  4. Query Database (Aggregate Storage)
  5. Aggregate Storage Group ID Information Output

Aggregate Storage Group ID Information Output

The following MaxL statement:

query database "dmglex4"."basic" list aggregate_storage group_id_info;

Returns the following output:

 group_id  transaction_id  state            time_last_used      time_expired              expired
+---------+---------------+----------------+-------------------+----------------------+-------------
      1234               1 Allocation Done  Wed Jul 20 17:39:57  Wed Jul 20 17:44:57           FALSE

See Query Database.