SAP BW
If you have access to data in an SAP BW system, you can use the SAP BW connector in Spotfire to connect to your OLAP cube.
Note that you need to install a driver on your computer to get access to the SAP BW connector. For more information and instructions for installing the required drivers, see Installing Drivers for the SAP BW Connector.
- Installing Drivers for the SAP BW Connector
The Spotfire connector for SAP BW can employ either the BAPI interface, or the ODBO interface, for connecting to SAP BW systems. This depends on which data source driver you have installed on your computer. - InfoProviders
InfoProviders are the reportable entities in SAP BW, for example, InfoCubes and MultiProviders. - Key Figures
Key figures are numeric values, quantities, dates or times. - Characteristics
A characteristic usually denotes a business entity that is being evaluated or measured by a key figure. Characteristics can be either attributes or hierarchies. Attributes are further broken down into display attributes and navigation attributes. - Dimensions
In SAP BW, dimensions are groupings of logically related characteristics. - Variables
Variables act as parameters to a Business Explorer (BEx) query. They are filled with values and processed at query runtime. - Business Explorer (BEx) Queries
SAP BW users can create Business Explorer (BEx) queries in the BEx Query Designer. BEx queries are intended to provide the end users with queries for reporting and analysis in SAP BW. In Spotfire each BEx query becomes a cube. - SAP Message Server
An SAP message server can be used for load distribution and communication between individual application servers in an SAP BW system. When you create an SAP BW connection in Spotfire, you must specify whether you will connect directly to an application server, or if you want to connect via a message server. - Adding In-database Data from SAP BW
Follow the steps below to add a connection with in-database data to SAP BW. - Importing Data from SAP BW
Follow the steps below to import data from a SAP BW cube. - Prompting for SAP BW BEx Variables
You can define prompting for a data connection to an SAP BW BEx query. Using prompting, you can let the end user define values for BEx variables, upon opening the connection. - Best Practices for the SAP BW Connector
When you work with SAP BW data in Spotfire, there are certain restrictions in SAP BW that you should keep in mind. The following sections contain information describing common SAP BW limitations and suggestions for how you can work around them. - Settings for SAP BW Connection
Use this dialog to connect to SAP BW. - Define Value
This dialog is used to specify a value for a BEx query variable. The appearance of the dialog depends on the type of variable you have selected, but a few examples are shown below: - Custom value presentation
For characteristics and hierarchies from SAP BW, you can select how to display the characteristic in Spotfire. A characteristic in SAP BW can have many types of metadata, such as attributes and technical names.