Web Analysis Studio users can construct seamless liaisons between OLAP data and relational data sources. Navigation from OLAP to relational data is called relational drill-through.
After relational drill-through is configured, users can navigate from the dimension bottom (level 0) of the OLAP database and drill down to relational data.
Relational drill-through is a client-based integration solution comparable to the server-based Analytic Integration Services drill-through.
The Relational Drill-Through dialog box is a graphical user interface for creating SQL relational database queries. Users can use complex SQL syntax to specify table joins and to select and order by clauses.
Note: | Relational drill-through supports an array of JDBC relational data sources but does not support queries by levels, generations, or previously selected members. |
Relational drill-through definitions are saved as properties of database connection files.