Skip to Content

Do stored Key Figures without values consume memory in HANA?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 08, 2017 at 11:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Dec 12, 2017 at 07:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded