Query to find processing time for cube?

Question

Query to find processing time for cube?

jasonhatfield01

Right there with Babe

Points: 722
More actions
August 11, 2005 at 3:10 pm

#152507

Hello All - I'm looking for some A.S. experts who might be able to tell me where to find how long a cube took to process? And when it was last processed? Or any other info that might be of interest. I know how to get this in the GUI but would like to have a query to automate it if possible. Thanks!

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

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

Larry Stein Default port Points: 1447 More actions · Answer 1

Look at the properties for clsCube in BOL. It has last processed date and other cool stuff in it, as well the related classes/subclasses. Others will have to respond on the processing duration question.

Larry

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 2

You can find the processing time only in the processing log, if you have enabled it.

It's a text file, look for a line something like this:

8/12/2005 1:50:07 PM 4947 Completed Processing Cube 'CubeName'. End time: 1:50:07 PM Duration: 0:00:02

jasonhatfield01 Right there with Babe Points: 722 More actions · Answer 3

Thank you both for your replies. I've turned on the processing log and have the information I need. I'll try the clsCube method if I get some time to play around.