How do I look up the create or last process date/time of an SSAS 2005 cube?
--
Regards,
FWAT

I came across an SSAS stored procedure to get the last processed date,
posted as a comment on Chris Webb's blog:

http://spaces.msn.com/cwebbbi/blog/cns!7B84B0F2C239489A!675.entry
...
I'll contribute my only current stored proc idea... retrieving the date
the cube was last processed which is useful for putting an "data fresh
as of" date on a report:

Imports Microsoft.AnalysisServices.AdomdServer
Imports Microsoft.AnalysisServices 'reference to AMO
Public Class StoredProcedures
Public Shared Function GetLastProcessedDate() As Date
Dim oServer As New Server()
oServer.Connect("Data Source=(local)")
GetLastProcessedDate =
oServer.Databases.GetByName(Context.CurrentDatabas eName).Cubes.GetByName
(Context.CurrentCube.Name).LastProcessed
oServer.Disconnect()
End Function
End Class

Note: I first tried "Return Context.CurrentCube.LastProcessed" but it
didn't work because of a bug:

http://lab.msdn.microsoft.com/Produc....aspx?feedback
id=1b671017-0dac-4aaf-af74-39e7dfa25db9

Published By furmangg - April 28 6:09 PM

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

And You can always right click the cube/partition and get this data
using SQL Management Studio.

Deepak was correct in that I was interested in it programmatically, not in
the SSAS 2005 Mgmt Studio or BI Studio UIs. But I realize that my question
could have been interpreted that way - so thanks anyway.
--
Regards,
FWAT


"yaniv.mor (AT) mail (DOT) com" wrote: