Post reply

Cube last processed date

  • March 22, 2017 at 5:55 pm

    #151514

    Does anyone know how to pull cube last processed date?
    I have used following dmx query but looks like it is to pull the last data updated date and i need cube processed date. 
    SELECT * FROM $system.mdschema_cubes
    Please see attached image.  I want to pull that date in picture for all cubes. It is on sql 2008.

  • March 23, 2017 at 3:40 pm

    #1934665

    SqlServerLover - Wednesday, March 22, 2017 5:55 PM

    Does anyone know how to pull cube last processed date?
    I have used following dmx query but looks like it is to pull the last data updated date and i need cube processed date. 
    SELECT * FROM $system.mdschema_cubes
    Please see attached image.  I want to pull that date in picture for all cubes. It is on sql 2008.

    If you are able to add assemblies to your instance then you can add ASSP. Then use the GetCubeLastProcessedDate function in the CubeInfo class.

    https://asstoredprocedures.codeplex.com/

    I'm on LinkedIn

  • March 23, 2017 at 4:02 pm

    #1934670

    Thanks. I will try.

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

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