Users with privileges can create relational drill-through connections using the Database Connection wizard. You must know the name of the relational database table that you intend to access before beginning.
To create a relational drill-through definition on an OLAP database connection:
Select File, then New, then Database Connection, then Analytic Services or Financial Management.
Click
, and select Database Connection, then Analytic Services or Financial Management.In the View Pane Browser tab, right-click an OLAP database connection in the Selection frame and select Edit. The database connection wizard for the selected database connection is displayed.
The first two options create a database connection. The last option enables you to define relational drill-through on an OLAP database connection.
The Process bar displays the steps for creating a database connection: Server, Database, Formatting, and Drill-through.
This procedure describes the creation of a relational drill-through definition on an OLAP or Oracle | Hyperion database connection. See also Creating OLAP and Oracle | Hyperion Database Connections.
On the Server, Database, and Formatting page, click Next until the Drill-through page is displayed.
Do not click Finish, or the wizard close without defining a drill-through connection.
On the Drill-through page, select Define Relational Drill-through Connection.
The Configure JDBC Driver dialog box is displayed. To successfully create a JDBC RDBMS connection, you must know the kind of relational data source you are accessing, the parameters needed to connect to it, and have a user name and password that supports connectivity.
In Database Connection String, supply values for variables.
Depending on the driver type, there are variables for host name, database name, port, and DSN. You must replace the brackets and the variable.
Click Test Connection to verify connectivity.
If the connection fails, repeat steps 6 through 10 until you can establish successful relational database connectivity. Make sure you remove the brackets from string variables.
After you connect, close the message and click OK.
The Modify Relational Drill-through Connection dialog box is displayed. With this dialog box, you can redefine a JDBC RDBMS connection, test the connection, identify a relational table, specify a column, and finally map the column to an OLAP dimension.
Column names for the specified table are displayed in the Column Name list at the bottom of the dialog box.
Designate the OLAP dimensions from which you connect to these table columns. To do this, you must understand the relationship between OLAP and relational data:
Click a cell in the Related Dimension column opposite a relational column name to which you would like to connect OLAP data.
The clicked cell presents a drop-down list with the dimension list of the OLAP database connection.
Click to select an OLAP dimension.
Repeat the process of mapping relational database columns and OLAP dimensions until your mappings are complete.
Click Pass Pages to maintain the current OLAP pages as you drill into relational data.
Click Pass Filters to maintain the current OLAP filters as you drill into relational data.
Set row limits for the query result set in the "Max rows to return" text box. This protects server and network resources from being consumed unintentionally by very large query result sets.
Specify SQL Select, Where, and Order By clauses to narrow the relational query result set.
Your relational drill-through definition is saved as a database connection property.