How to know last process time of SSAS Cube

Question

How to know last process time of SSAS Cube

shirisha.t33

Mr or Mrs. 500

Points: 509
More actions
April 14, 2010 at 11:18 am

#386701

Hi
I have deployed the SSAS cube on to the server.
I know how to see when the cube was last ran.
But I am wondering how can i know how much time it took for processing.

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

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

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 1

How are you currently processing the cube? If you are simply using a SQL Agent job with a script you should be able to get the time based on the Agent job or if you are using an SSIS package you should look at enabling the logging features to determine how long the SSIS task took to complete.

To get the last processed time to display to the users you can use the DMV if you are using SSAS 2008 or utilize the ASSP project on CodePlex - http://social.msdn.microsoft.com/Forums/en-SG/sqlanalysisservices/thread/80abc80c-b1f3-440f-9663-8ad161853d60:

SELECT CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBES

OR

WITH MEMBER [Measures].[LastProcessed] AS ASSP.GetCubeLastProcessedDate() SELECT [Measures].[LastProcessed] ON 0 FROM [myCube]

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com

shirisha.t33 Mr or Mrs. 500 Points: 509 More actions · Answer 2

shirisha.t33

Mr or Mrs. 500

Points: 509

June 15, 2010 at 1:12 pm

#1180638

Thanks a lot ...Appreciate

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

Look in the event log under Application, at the around the time your cube finished it's last run.

We process ours using a package, and we have events 12288 written to the log at start, and 12289 at completion.

Greg E

CLT-BI guy SSC Journeyman Points: 78 More actions · Answer 4

denglishbi (4/16/2010)
How are you currently processing the cube? If you are simply using a SQL Agent job with a script you should be able to get the time based on the Agent job or if you are using an SSIS package you should look at enabling the logging features to determine how long the SSIS task took to complete.
To get the last processed time to display to the users you can use the DMV if you are using SSAS 2008 or utilize the ASSP project on CodePlex - http://social.msdn.microsoft.com/Forums/en-SG/sqlanalysisservices/thread/80abc80c-b1f3-440f-9663-8ad161853d60:
SELECT CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBES
OR
WITH MEMBER [Measures].[LastProcessed] AS ASSP.GetCubeLastProcessedDate() SELECT [Measures].[LastProcessed] ON 0 FROM [myCube]

Hey thanks, this was very helpful.