Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Formula Reporting Overview

    When using formulae to retrieve information and data from the OLAP cube, each cell contains a formula rather than the data itself (unlike Grid reports). It is therefore possible to put any value in any cell, and to have fully disjoint reports.

    Most formula reports are built primarily using just two XLCubed formulae:

    XL3Lookup
    retrieves the cube value from a specified slice, and will normally reference one or more XL3Member formulae
    XL3Member
    returns the caption for a specified member

    Formula reports will often be preferred where the required formatting is complex, or where existing 'static' financial reports are being replaced.

    See Also