Get Cube Last Processed Date

14/06/2012

תגיות: , , , , ,
2 תגובות

The common request to present the last process date of Cube XX can be solved by the ASSP project presented at codeplex.

The function in the CubeInfo class is GetCubeLastProcessedDate. This
function will return the date when the current cube was last processed.
The following is an example MDX query against the sample Adventure Works
cube:

with member [Measures].[LastProcessed] as
ASSP.GetCubeLastProcessedDate()
select [Measures].[LastProcessed] on 0
from [Adventure Works]

Download the project and carefully walkthrough the step by step.

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. (*) שדות חובה מסומנים

2 תגובות

  1. kobi deutsch14/06/2012 ב 17:23

    SELECT

    CUBE_NAME, LAST_DATA_UPDATE FROM
    $System.MDSCHEMA_CUBES
    where cube_source=1

    להגיב
  2. Ronen Chenn14/06/2012 ב 19:37

    Thanks kobi.
    That is a very good example that the ms platform allows usany ways to reach thd same result .

    להגיב