Hi siddarth,
couple of things captured my interest:
- creating stored procedures for reports; is this wise in a MS BI environment? with a datawarehouse and cubes, one of things I found out best to use is a 3rd party report/analysis tool which truly uses the cubes. This saves a lot of effort; there is pretty much stuff, MS gold partners out there, delivering things at the level of pro-clarity
- documentation; although the product is not at the level to show full interdependancies, the BI documenter will be of use to many
- use the metadata fields in the database, as well descriptions in cube dimensions to extract them with automated tools