All,

I have implemented a set of reports using AS as the backend to some RS
reports. The only problem that I am having is that it is difficult to tell
from the reports when the AS DB/Cube was last processed. Is there a method
that can be employed to, for example query the repository (converted to SQL
Server) to find out when the cube was last processed? I'm still poking
around, but thought someone here may have a quick solution.

Thanks,

To add to my thread...

I have found a query against the repository that may work, but I don't fully
understand the table:

select
objectname, lastupdated
from
olapobjects

This seems to give me the timestamp for the last update of each object, but
I just manually processed the cube and this table was not refreshed. Is
there a stored proc that updates this table on a schedule or how is this
table refreshed? Is there a better solution to my problem?

Thanks!

"asnewbie+rs=argh" wrote:

Best to use DSO for that sort of thing.

I have not had to use DSO yet. I'll take a look at it. The reason I was
trying to do it with SQL was that I need to be able to report the resulting
date/time in my reporting services report. If I can do this with SQL then
that is easy.


"OLAPMonkey (http://olapmonkey.blogspot.c" wrote:

"OLAPMonkey (http://olapmonkey.blogspot.c" wrote:

I tried to write a test VB.NET app that should do this with DSO, but I get a
problem with the Server Property LastProcessed. This is based on some MSDN
code that loops though all the AS DBs on a given server.

++++++++++++++++++++++++++++++++++++++
Private Sub LastDatabaseUpdate()
Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore

' Connect to the server.
dsoServer.Connect("localhost")

' For each MDStore database object on the server,
' print its name.
For Each dsoDB In dsoServer.MDStores
'TextBox1.Text = "Database: " + dsoDB.Name + " - " +
dsoDB.LastProcessed

'TextBox1.Text = dsoDB.Name
'TextBox1.Text = dsoDB.Description
'TextBox1.Text = dsoDB.LastUpdated
'LastProcessed does not work while each of the above do!
TextBox1.Text = dsoDB.LastProcessed

++++++++++++++++++++++++++++++++++++

The error message I get is:

An unhandled exception of type 'System.NotSupportedException' occurred in
WindowsApplication1.exe

Additional information: Object doesn't support this action

Anyway, if anyone has any thoughts, please let me know.

Cheers,