Oracle Essbase
If you have access to data in an Oracle Essbase system, you can use the Oracle Essbase connector in Spotfire to connect to your OLAP cube.
When you configure a connection to an Oracle Essbase cube, you can choose whether to analyze data in-database or to import it into your analysis. Note that you need to install a driver on your computer to get access to the Oracle Essbase connector. See the System requirements for connectors in Spotfire to find the correct driver.
- 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. - Hierarchical Measures
In Oracle Essbase, measures can be organized in hierarchies, in contrast to other cube data sources. - Adding In-database Data from Oracle Essbase
You can add a data connection to Oracle Essbase to an analysis and select to analyze the data in-database. - Importing Data from Oracle Essbase
When you want to import data from an Oracle Essbase cube, it important to limit the selected data as much as possible. - Spotfire for Oracle Smart View Users
If you are an Oracle Smart View user who is accustomed to do ad-hoc analysis, that is, if you are using Microsoft Excel spreadsheets with Smart View functionality for selecting members from a cube, there are a number of things you should think about when doing analysis in Spotfire. - Settings for Oracle Essbase Connection
Use this dialog to connect to Oracle Essbase. - Select Measure Dimension
If you are connecting to an Oracle Essbase cube that does not have a dimension tagged as the accounts dimension, you must specify which dimension contains the measures. When you create a connection to such a cube, this dialog will be displayed, and you can manually specify which dimension to use as the designated measure (accounts) dimension in your connection.