You can construct liaisons between OLAP and relational data sources, typically called relational drill-through. After relational drill-through is configured, you can drill from the dimension bottom (level 0) of the OLAP database to specified relational data.
Relational drill-through is a client-based integration solution comparable to the server-based Integration Services drill-through.
The Relational Drill-Through dialog box is a graphical user interface for creating SQL relational database queries. You can use complex SQL syntax to specify table joins, and select and order by clauses.
To support a broad array of JDBC relational data sources, relational drill-through does not support queries by levels, generations, or previously selected members. |
Relational drill-through is configured as a database connection property of an OLAP database connection. You can set database connection properties through the database connection wizard:
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. Relational drill-through is set by the last step in the wizard process.