DCSIMG
המידע שקיבלת במסגרת בלוג זה הינו מידע כללי בלבד ואין לראות ו\או להסתמך על מידע כאמור כייעוץ ו\או תחליף לייעוץ מכל סוג שהוא ו\או להסתמך עליו לעניין כלשהוא. Get Cube Last Processed Date - Business Intelligence,Technology, Thoughts, Thinking
Sign in | Join | Help

Get Cube Last Processed Date

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.

Comments List

# re: Get Cube Last Processed Date

Published at Thursday, June 14, 2012 5:23 PM by kobi deutsch  

SELECT

CUBE_NAME, LAST_DATA_UPDATE FROM

$System.MDSCHEMA_CUBES

where cube_source=1

# re: Get Cube Last Processed Date

Published at Thursday, June 14, 2012 7:37 PM by Ronen Chenn  

Thanks kobi.

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

Leave a Comment

(required) 
(
required
)
 
(optional)
(required) 

Enter the numbers above: