Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

i2024.2.5 New Features and Improvements - Currency Conversion with CROSSJOIN Function

Business Requirement 

How can I perform a calculation for a specific combination of Dimension values before aggregating the result?  For example, I'd like to report on source transactions from regional currencies and report them in one or more reporting currencies. 

AtScale Feature Review 

Use the server-side CROSSJOIN function to define a set of dimension member tuples, execute an expression for each tuple and then aggregate the results.

  1. Allows Expressions to be evaluated within a constrained combination of dimension members BEFORE aggregation. 
  2. Expression author controls what Dimensions and what kind of Aggregation they wish to perform.
  3. Report End-User can Slice and Filter the Expression Values by Related Dimensions
  4. Ideal for converting n-source currencies to n-reporting currencies and breaking results down by related dimensions.