Important Information
TIBCO Spotfire Documentation and Support Services
Introduction
What is a Cube?
What are Measures?
What is a Dimension?
What is a Hierarchy?
Cube Queries
Large OLAP Hierarchies in Spotfire
Configuring a Cube Hierarchy to be Loaded on Request
Hierarchy Filters Loaded on Request
Common Operations on Cubes and their Spotfire Equivalent
Combining OLAP Data and Other Data in the Same Analysis
Defining a New Relation Between a Relational Data Table and a Cube Data Source Using Keys
Creating Column Matches Based on Keys to View Cube Data in the Same Visualization as Other Data
Limiting Data
Data Selection in Connection
Icon Descriptions
In-database Cubes in Spotfire
Microsoft SQL Server Analysis Services
Dimensions and Attributes
Measure Groups
Hierarchies
Named Sets
Microsoft SQL Server Analysis Services Cubes in Spotfire
Adding In-db Data from Microsoft SQL Server Analysis Services
Importing Data from Microsoft SQL Server Analysis Services
Settings for Microsoft SQL Server Analysis Services Connection
Oracle Essbase
Measures in Oracle Essbase
Hierarchical Measures
Adding In-database Data from Oracle Essbase
Importing Data from Oracle Essbase
Spotfire for Oracle Smart View Users
Minimizing the Strain on the Oracle Essbase Database
Settings for Oracle Essbase Connection
Select Measure Dimension
SAP BW
Installing Drivers for the SAP BW Connector
InfoProviders
Business Explorer (BEx) Queries
Variables
Key Figures
SAP Message Server
Characteristics
Dimensions
Adding In-database Data from SAP BW
Importing Data from SAP BW
Prompting for SAP BW BEx Variables
Adding Prompts to an SAP BW BEx Query Connection
Details on Prompting for SAP BW BEx Queries
Best Practices for the SAP BW Connector
Default Cell Limit: Maximum 1 000 000 Cells
Importing SAP BW Data in Pieces
Limitation: Multiple Hierarchies or Columns from the Same Characteristic
Other Tips for Using the SAP BW Connector
Settings for SAP BW Connection
Define Value
Data Import
Limit the Number of Dimensions
Data Import Best Practices
Known Limitations
Creating a Shared Data Connection in the Library