This can be helpful if you want a function to apply to a certain set of records, for example, a sum of purchases for people older than 65. These calculations will be supported in both merged and union QueryObjects, as well as in stand-alone QueryObjects. QueryObject Administrators now have the ability to create custom calculations at the record level by selecting the Custom Function dialog. By choosing from a list of available Metrics displayed in an edit window, you can now take advantage of improvements using C-based functionality to build a mathematical expression. The QueryObject Engine creates a Metric with the name derived from the name of the calculation routine.
Administrators can then test the resulting calculation and make changes as required.
Enhanced Range Wizard Release 3.20 improves the wizard used to group Dimension values into ranges. The QueryObject Administrator then entered the low and high values for each range as well as a description for each. Now, with the enhanced wizard, the Administrator can automatically generate ranges by specifying the method to be used. The ranges created can then be edited if necessary. New SQL Wizard Release 3.20 includes a new wizard to simplify the process of selecting data from relational databases.