-
Extracting a Rule to Validate (Board 12.6)
While troubleshooting a Rule function, the extracted file is in the form txt document and the rules / formulae are in the form of Entity member codes and not description. Hence, it becomes difficult to validate the rules/formulae for the developer/support/user, in the event a calculation is populating incorrect numbers
-
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…
-
About Grand Total
Q1. I want to change the notation of grand total to, for example, total year. Is there any way? (Yellow part) Q2. Can I apply the rule to Grand Total? (Green part) Now, I have set the following rules. c=(b/a)%, f=(e/d)% I want to set the same rules for grand total, as shown below. i=(h/g)%
-
Use of Rules in Layouts
The limitation by using rules in layouts should be elimiated since it limits the use of quick layout massively. In our case we calculate a %-KPI which can not be safed in a cube and must be calculated on the fly. Using the quick layout and having the rule set on the cube not only leads to not calclulated KPI´s but also…
-
Rules: Time Functions & Select on Other Entities
To enhance the effectiveness of analyses through the use of rules, we propose the introduction of two main functionalities: the use of time functions and the selection of specific occurrences of other entities. Integrating time functions into rules would allow for greater agility in report construction, especially by…
-
How to manage three different rules in the same layout
Hi, I'm in the situation described by the title. The rules are based on the same entity, but I want to use them in the same layout due to the type of calculation the user selects. Have you got any tips?
-
Fix Entity in Quick Layout
Would be great if we could fix dimensions within the quick layout. This is very important to allow mid flexibility within the quick layout function. Its specially important when we have a rule within one of the dimensions, that must always be there to be able to display data correctly.
-
Possibility of calculating YTD figures based on MTD data using Rul
Hi All, I want to explore the possibilities of calculating YTD figures using MTD data using a rule. For example - Revenue for Jan 2023 - 1000 Revenue for Feb 2023 - 1000 Using Rule can we calculate and store it under new member called "YTD Revenue" YTD Revenue for Jan 2023 - 1000 YTD Revenue for Feb 2023 - 2000 Using…
-
Offset Rules
1. Abstract Offset rules are a type of rule which allow you to reference multiple blocks in the same layout as part of your calculation, they can be very powerful but should be used with caution. 2. Context Offset rules can be very powerful in certain circumstances but should be used with caution due to the complexity they…
-
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…