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 facilitating the analysis of deviations, such as comparison with the previous year.
Offering the capability to directly select the values of specific occurrences, such as Actual and Budget—which are two occurrences of the Scenario entity—within the rules, would mark a substantial improvement in establishing comparison metrics.
Furthermore, this approach aims to reduce the number of cubes required
for report construction by shifting calculation logics to the rules,
which can also be managed by power users. This strategy seeks to
streamline the reporting process, making it more accessible and
efficient.
Please let us know your thoughts on this suggestion.