-
How to ensure correct rule behavior when using entity sorting
1. Abstract Rules applied to an Entity are widely used in Board to support aggregation logic within reporting structures. A common example is a P&L Reporting Line entity, where rules allow users to calculate and aggregate specific reporting categories. When working with such rules, it is critical to understand how entity…
-
On-the-fly Calculations: Pros and Cons
1. Abstract The term “on-the-fly calculation” refers to all the calculations executed directly at the layout level, meaning that the result is not physically stored in a Cube. This directly affects drill-down functionality and has advantages in terms of reducing the overall size. 2. Context During the development phase the…
-
Rule Consolidation
1. Abstract The rule is a key functionality that allows on-the-fly calculations between members of the same entity. The consolidation is a further step to physically store the result in the data model. This step is needed only in specific cases, usually when the calculated rows need to be reused as a source for following…