During the Best Practices session at MMS we have shown the DW properties report. The one thing I want to point out is that the management pack that contains this report is not imported by default when you install OpsMgr SP1. In order to get the report, you need to import the Microsoft.SystemCenter.DataWarehouse.Reports MP which is located in the ManagementPacks folder in the OpsMgr install folder. Shortly after importing the MP, the report will be available in the reporting space under the "Data Warehouse Reports" folder in the reports tree.