Measures in Oracle Essbase
In an Oracle Essbase cube, you organize measures in one dimension, which you tag as the accounts dimension. If no dimension in the cube is tagged as accounts, you must specify the dimension where the measures in the cube are located, when you create a connection in Spotfire.
You define the dimension to use for measures in the Select Measure Dimension dialog, which is displayed automatically when you connect to an Oracle Essbase cube that does not have an accounts dimension.
Formula-based measures
Some measures in Oracle Essbase cubes are calculated based on non-dynamic Essbase formulas. By default, the possibility to aggregate such calculated measures with MDX is disabled, because aggregating them can yield unpredictable results.
For formula-based measures that you know have a definition that makes them able to be aggregated, you can enable MDX aggregation. When you select data to include in your connection, in the Data Selection in Connection dialog, click to select the formula-based measure you want to configure, and, in the Settings pane, select Allow aggregation with MDX.