Oracle Hyperion Web Analysis Studio users can construct seamless liaisons between OLAP data and relational data sources. Navigation from OLAP to relational data is typically called relational drill-through.
After relational drill-through is configured, users can navigate to level 0 (the bottom) of the OLAP database and drill down to relational data. Relational drill-through, a client-based integration solution, is comparable to the server-based Analytic Integration Services drill-through.
Relational drill-through supports an array of JDBC relational data sources but does not support queries by level, generation, or previously selected member. Relational drill-through definitions are saved as a property of the database-connection file.