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.