How to find the size of SAP HANA cubes?

[balaji_systech]

Is there a way to identify how much memory a cube would consume if no filter is applied and that it is fully loaded into the memory? This is basically to get an estimate of the size of data file (csv) if i extract all of the data from a cube.

[Bojan-lv-85]

Hello,

please note that estimating the csv sizes of table exports based on the "memory-used" figures might be heavily missleading due to the fact that tables in memory are in most cases compressed. Some tables / columns more efficient than the other.

So in case you have a ~70% compression ratio in the base case, you might end up with a 1GB csv file for a table using 300MB of memory.

Regards, Bojan

[former_member186399]

Hi,

If you are in hana the below SQL script should be able to give you the memory occupied by the cube.

select table_name, sum( memory_size_in_total/1024/1024/1024) as "Peak" from m_cs_tables where table_namelike '%cube_name%' group by table_name

Regards

Gajesh