You can construct seamless liaisons between OLAP data and relational data sources. Navigation from OLAP to relational data is typically called relational drill-through. Users can navigate from the dimension bottom (level 0) of OLAP databases and drill down to relational data.
Web Analysis documents store relational drill-through definitions, which can be defined with Select statements and clauses, as database connection properties of Analytic Services database connections. Query result sets are presented as SQL spreadsheets.