Showing Cube's last process time in Report

Question

Is there any way to show the last time a Cube or a Dimension was last processed in a Report (I'm using Report Builder)?

I attempted this by starting off creating a table called LastProcessTime with the fields "Type", and "DateTimeProcessed", and I could Insert into this table, but I do not know how I would initiate the Insert. Perhaps there is an entirely different approach. Thanks.

Answer 1

Not sure you could add this into report builder, but try a standard MDX report, and use the SSAS DMVs (Dynamic Management Views):

http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/

Run this in an MDX query window against a cube (I know, it does look like TSQL):

SELECT * FROM $system.mdschema_cubes

Should give you what you need?