Hi Scholars, How to create Environmental Reports (CPU Utilization, RAM Utilization, BIOS Installed) in SSRS 2008 R2 from Fact and Dimension Tables?? What columns do I need to analyze the data for? And what will be the steps to do this? Please suggest me in this regard. Thanks Kranthi

Hi Kranthi, For your sql server or machine itself? Please clarify your requirement. thanks, Jerry

Hi Jerry, These reports are to be generated for all the machines that are used by our company. So that, by analyzing these reports, we can suggest the user to upgrade their hardware or software. I have access to Fact tables and Dimension tables to get the required information for them. But I don't know where to start from!! I'm new to such reports. Please guide me. Thanks Kranthi

Hi Kranthi, Sorry to delay this response. "I have access to Fact tables and Dimension tables to get the required information for them." Since you have build a dataware house, you can either create a cube for futher analysis using SSAS and then display them on reports, or show the information directly on reports. See http://technet.microsoft.com/en-us/library/bb522607.aspx on getting started with SSAS, and http://msdn.microsoft.com/en-us/library/cc627438(v=SQL.100).aspx on how to Retrieve Data from an Analysis Services Cube (MDX). Hope this helpfully, thanks, Jerry