Find the Size of ASO Database in ESSBASE

To Find the size of ASO Database in essbase below is the Maxl Script.

Query database "Dbs_Name" get cube_size_info;

This will display information about the input data size, aggregated data size, and number of queries tracked (when query tracking is enabled).

input_data_size_cells - Number of input-level cells in the cube
input_data_size_bytes - Number of bytes used by the input-level data (approximate)
aggregate_data_size_cells - Total number of cells in all aggregate views in the cube
aggregate_data_size_bytes - Number of bytes used by the aggregate cells (approximate)
kernel_queries_tracked - Number of kernel queries executed since the last time query tracking was enabled or query tracking information was reset
total_query_cost - Total cost of all queries executed since the last time query tracking information was reset
query_tracking_enabled - Values: True or False. Tells whether user retrieval statistics are being collected for the aggregate storage database

For further information please refer to the Essbase Technical Reference Guide.


Thanks.