Hierarchical Measures

In Oracle Essbase, measures can be organized in hierarchies, in contrast to other cube data sources.

When the data source structure is shown in Spotfire, a measure that is also a parent is shown both as a folder and as a separate measure, which is slightly different compared to what the structure looks like in the Oracle Essbase Administration Services user interface.

Example of Structure

In the Data Selection in Connection dialog in Spotfire, only metadata is shown. This means that even if the Show both member and alias check box has been selected in the Oracle Essbase connection dialog, the member names will still be shown in the Data Selection in Connection dialog. The aliases will be shown in the data when the selection has been added to Spotfire.