Lastupdate property in OLAP cube

  • Is there anyway to access the lastupdate property for an Analysis Services 2005 cube using MDX or Visual Basic (within an MDX query).  I want to create a named set that references that last date that the cube was updated.  Thanks.

  • Hey Larry,

    Some nice people have put together a sample set of Stored Procedures (these are contained in assembliy/ies that you add to your AS DB) and one of the functions provided is CubeInfo, which returns the last processed date.  Check out the samples here.

    Cheers,

     

    Steve.

  • Steve,

     

     

  • Yes,

    Steve.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply