Web Analysis Studio enables you to drill through to related relational data from the lowest level of the Essbase outline, by defining a link on Essbase database connections. You can pass pages, filters, and row limits to focus and control the relational query result set.
See Defining Relational Drill-through.