I have an Excel Pivot table accessing a Cube on the server.

earlier, it used to access a relational database and I would be able to
click on the summary data and it used give me the entire table as it is
obtained from the relational database. Now I can't get it to do that
with Analysis Services. how do I do this?

any help would be appreciated.