Best Practices for Design Dimensionality

One of the most important design considerations you can make with HFM is thinking about the subcube. In recent releases the product has gotten much better at handling the memory limitations the subcube presents. In releases prior to 4.1, Hyperion strongly recommended a limit of 100,000 records for any one subcube, based on a 12-month Application Profile. This limit was not a hard and fast limit; one could see subcubes larger than 100,000 records completing consolidation without consistently failing or giving an error message. This made it very difficult to identify and resolve these issues. The large subcubes actually bring you closer to the real issue, which is the Maximum Number of Data Records in RAM (MaxNumDataRecordsInRAM) to the 1,50....