Microsoft SQL Server Analysis Services
If you have access to data in a Microsoft SQL Server Analysis Services system, you can use the Microsoft SQL Server Analysis Services Connector in Spotfire to connect to your OLAP cube.
- Dimensions and Attributes
Dimensions organize data with relation to an area of interest, for example, time, product, customer, region, etc. An attribute is a kind of categorization. - Measure Groups
Measure groups are used to associate dimensions with measures. - Hierarchies
Hierarchies are used to organize measures that are contained in a cube. In Spotfire, attribute hierarchies and single-level user hierarchies are represented as columns, whereas multi-level hierarchies are represented as hierarchies. - Named Sets
Named sets return a data set based on a defined logic. They are primarily used to create data sets that are often requested from the cube. - Microsoft SQL Server Analysis Services Cubes in Spotfire
- Adding In-db Data from Microsoft SQL Server Analysis Services
Follow the steps below to add a connection with in-database data to Microsoft SQL Server Analysis Services. - Importing Data from Microsoft SQL Server Analysis Services
Follow the steps below to import data from a Microsoft SQL Server Analysis Services cube. - Settings for Microsoft SQL Server Analysis Services Connection
Use this dialog to connect to Microsoft SQL Server Analysis Services.