Is there anyway to know underlying relational tables and their Column used in dsv . Manually we go to DSV and check tables , but it tedious process when Cube is large .
This is useful to check Impact of changes in Relational tables on Measures
For Example : IF there is measure called [Measure]. [Number of Sales] , then I would like to see DSV and respective Relational tables .
Would the Used Columns Report in BIDS Helper be what you are looking for?
It is an open source project so if for security reasons you can't install it, compile the whole project yourself. Or at least grab the relevant code and put that snippet in your own project. Here is the relevant code.