I have a SQL Server 2005 Analysis Services instance with 100 cubes. These cubes are automatically created by an application and used as the source for Reporting Services reports (also auto-generated). My task is to write a query or a report of the cubes based on either Creation date older than 90 days or Last Update (or Processed) date older than 30 days.
My first problem is how do I query the cube metadata? I see that I can right-click on the cube and view the properties but I want to produce a list (query results or report) to see the list of cubes and their respective dates. Also, I can see the file properties Date Created, LastUpdated, LastAccessed in Explorer and I now how to write a batch script to export this list; however, I was hoping to do something within SQL Server Management Studio (query) or Reporting Services (report).
