Calculations Overview

Revision as of 11:13, 8 October 2010 by Antonio.remedios (talk | contribs) (Updated link)

XLCubed features three ways to define your own calculations.

Grid Calculation Columns and Rows

Used only in Grid-based reports, Grid Calculations allow you to define your own dynamic calculations within a Grid report.

They allow Excel formulas to be used within the Grid, based either on the visible data or on other elements on the worksheet.

More details can be found here.

MDX Calculated Members

MDX Calculations are a simple but powerful means to manage calculated members, sets and custom MDX commands that live in the session, and are executed on connection.

They are more involved to implement than Grid Calculations, but enable more complex and flexible calculations.

More details can be found here.

XLCubed OLAP Formulae

XLCubed offers several formulas that allow you to bring Cube data into Excel. This allows you to create complex workbooks interacting in all the sophisticated ways that Excel allows.

A more detailed description can be found here, and an XLCubed formula reference here.