Dimension Member Count
Data scale in Oracle Hyperion Profitability and Cost Management is a function of the number of dimensions and the size (member count) of those dimensions. The range sizes for rules are impacted by both dimension count and member count.
When designing the application, it is wise to be judicious in the use of very large dimensions. Profitability and Cost Management applications work best when the dimensions are fewer and smaller. This is not to say that Profitability and Cost Management cannot handle large and sparse dimensions, but that using many large dimensions can cause performance issues in calculation once you start design rules to work across the vast and sparse ranges that are caused by using many large dimensions.
Use the same rationale for member detail within a dimension as you do for choosing dimensions in the first place:
-
Will the detail be needed for reporting?
-
Is it needed to differentiate data to support allocation logic?
If the answer to both questions is no, you should consider using a more aggregated level of members in the dimension. For example, use Cost Pools instead of the lowest level account or Product Family instead of SKU.