how can i see the data which is loaded to a perticular hierarchy ?

Hi gurus,

can anyone please tell me that how can i see the data which is loaded to perticular hierarchy.

actually my problem is i have one report.in the query of that report one hierarchy is used.i want to see the data which is loaded to the hierarchy.i can see in the report.but i want to see the data in the hierarchy.

i know the cube name and from that how can i know the master data table name and how can i see the loaded data for the hierarchy.

hope my question is clear.

thanks in advance.

ashok.