Find The Size Of An Aggregate Storage (ASO) Database in Essbase?


To find the size of an ASO database you can use the following MaxL command:

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).

Column Name Contents
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

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s