This discussion is archived
2 Replies Latest reply: May 29, 2012 5:04 AM by Smilee RSS

Subcube in HFM

Smilee Newbie
Currently Being Moderated
Hi Experts

What is the concept of subcube? Can any one please explain in brief? A little bit high in financial management?

regards
Smilee
  • 1. Re: Subcube in HFM
    KostasN. Expert
    Currently Being Moderated
    Hi,
    A subcube is a construct that HFM uses to cache data in memory. A subcube is defined by the combination of one member from each of Scenario, Year, Entity and Value and contains every single data cell defined by all possible combinations of the rest of the dimensions. That is why it is called a subcube, it is a cube defined by all possible combinations of Account, ICP, Custom1-4 for a fixed Scenario, Year, Entity and Value combination. You will ask: where is the period here? The answer is that a subcube comes in as a set of records, each record containing a unique Account, ICP, Custom1-4 combination with 12 values (provided that you have defined a month as a period).

    --Kostas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
  • 2. Re: Subcube in HFM
    Smilee Newbie
    Currently Being Moderated
    Hi Kostas

    Thanks for your prompt response and good explanation.

    Have a nice time...☺

    regards
    Smilee

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points