I have a scheduled job that runs a SSIS package. This package "processes"
all cubes... is there a way to look at a cube in AS2005 to see if it has
been processed? For example, to be able to click on it and see a date that
show the last time the cube has been processed?

Please advise...
Thanks,

Brett

Hi Brett,

If you right-click a cube in Management Studio and select "Properties",
under Status see "Last Processed".

Programmatically, you can get the cube processed timestamp using AMO,
from The "LastProcessed" property of a cube:

http://forums.microsoft.com/MSDN/Sho...58794&SiteID=1

Re: Last Cube Process Date/Time

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.AnalysisServices;



namespace GetCubeProcessingTime

{

class Program

{

static void Main(string[] args)

{

string date = string.Empty;

string cubeName = string.Empty;



try

{

// Connect to the SSAS server

Server server = new Server();

server.Connect(@"Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=Adventure Works DW;Data
Source=localhost\YUKON");



// Get the Adventure Works cube(s)

Database database =
server.Databases.GetByName("Adventure Works DW");

foreach (Cube cube in database.Cubes)

{

date = cube.LastProcessed.ToString("yyyy-MM-dd
HH:mm:ss");

cubeName = cube.Name;

Console.WriteLine(string.Format("Cube [{0}] was
processed: {1}", cubeName, date));

}

}

catch (Exception exception)

{

// Uups

Console.WriteLine(exception.Message);

}

}

}

}

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***