What is this property (CubeDef.LastProcessed) supposed to return as it does not return the date the cube was last processed?
Does AMO provide this info more reliably ?
TIA
Dave
Hi Dave,
It's a bug - CubeDef.LastProcessed returns the last time the server was restarted as far as I know. See
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124606
...for more details. Take a look at the comment posted by furmangg on April 28th on this entry on my blog for some code which does what you want:
http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!675.entry
It's also available in the Analysis Services Stored Procedure Project here:
http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures&title=CubeInfo
HTH,
Chris
|||
Thanks Chris,
Its not resolved in SP1 either... Im going to check out AMO.
Cheers
Dave
No comments:
Post a Comment