SQL Spreadsheet data objects enable you to query a relational data source, and display the returned data values on a custom document.
Prerequisites for SQL Spreadsheets:
To create a SQL Spreadsheet you are required to specify:
Query that gets data values from the data source and returns them to the data object.
Note: | If you import a Web Analysis document that contains an SQL Spreadsheet (exported and imported via APT file format) from one environment to another, the password in the target environment will not be decrypted properly.. Therefore, you will have to edit SQL query settings to specify a valid password. To change the password for SQL Spreadsheet, right-click on the Spreadsheet and open the Open Query dialog box. Enter the password into the "JDBC password" text field. |
The process of creating SQL spreadsheets assumes that you know your JDBC driver, database application, and logon credentials. The process also assumes that you can compose the SQL query for the SQL spreadsheet data object, or be able to use a SQL Query Builder to create a query.
There are four alternatives for accessing relational data in Web Analysis Studio:
You can create a relational database connection to be used by regular spreadsheets, charts, and pinboards. See Creating Relational Database Connections.
Free-form grids enable you to combine data values from multiple data sources in one data object. Free-form grids leverage custom document database connections. See Creating Freeform Grids.
You can create a relational drill-through connection from an OLAP database connection to a relational data source. See Creating Relational Drill-Through.
You can leverage predefined Integration Services drill-through documents using the Related Content dialog box. See Integration Services Drill-Through.