Pre-aggregate report expressions
Report authors can create pre-aggregate expressions, also known as push-down expressions in Visualizer and Designer. Pre-aggregate expressions are evaluated in the Infor Birst database. Evaluating expressions at the database level improves performance and provides support for complex expression logic to create custom attributes and custom measures.
Pre-aggregated expressions apply at the space level and are enabled by default from the Push Down Expressions to Database space setting. You can disable it in Admin> Manage Space> Space Properties:
- If enabled, expect the results of existing report expressions to change because the expression is now aggregated in the database.
- The Push Down Expressions to Database feature supports all report expressions except those that include positional calculations and dimensional expressions. To use these, you must disable Push Down Expressions to Database.
- If you are using Smart Insights, you must disable Push Down Expressions to Database for new spaces.
After enablement, you can create custom attributes and measures in the Visualizer Expression Builder or the Designer Expressions dialog.
Custom attributes and measures are based on BQL expressions syntax.