Do stored Key Figures without values consume memory in HANA?

[former_member422194]

Hi IBP experts,

We were having some memory issues with IBP lately, so we are investigating how to make our Planning Area more lean. As we started from the Unified Planning Area in IBP1702, we have a lot of key figures, but not all of them are used or planned to be used in the future. We just kept them for the sake of remaining as close as possible to the SAP Sample Area. We are now on version IBP1708

However, we are now considering removing the stored key figures that are not used. We understood (correct me if we are wrong on this point) that the internal Key Figure table which stores the values in HANA contains PeriodID and Planning Object ID as sort of 'keys' and then contains all stored key figures as columns. And even if these columns are empty, they still take a bit of memory in the system. Is that correct?

We did understand that the large amount of key figures has an impact on the duration of planning area activation, but does it also impact memory if these key figures are not filled?

Kind regards

Kristof

[former_member194529 · Accepted solution]

Hi Kristof,

Seems that you got the correct understanding.

If you have stored KFs but they were not initialized (created planning objects and timeseries data for them), they will still take some storage space, but if these same stored KFs already contain data, then the space utilized will be larger than in the first case.

Best,

Ivan

[former_member422194 · Accepted solution]

Hi Ivan,

So to be clear: going through the effort to remove unused Key Figures in order to lower memory usage makes sense?

For instance, if we have a Planning Object on a certain planning level which has, say 10 Key figures of which there are 4 used (these contain data) and 6 not used. Suppose that we remove those 6 key figures. Would we then clean a considerable amount of data or would the result be very small?

Thanks

Kristof

[former_member194529]

Hi Kristof,

In this case, the result would be very small. Technically, each KF is stored in 1 column in the HANA database, so you would be removing 6 columns in the database, that does not represent a considerable amount of storage. Now let's say that you have a difference between 100 and 1000 KFs, then it is very relevant.

Thanks,

Ivan