Hi,

is it possible to retrieve the meta data from a certain cube (like last
process date) so i can use it in a report ?

Thx!

do you use AS2005 or AS2000?
in a reporting services report?
do you also want to see unprocessed cubes?

with AS2000 and if you want the list of unprocessed cubes, you have to use
the DSO objects.
With AS2000 and displayed only prossed cubes, use the ADOMD.NET (this should
works fine with AS2005 cubes too)

To disply the result in RS report, you have some choices,
first you can create your own data source provider for RS,
second you can create a simple script on the server to read the information
and store this info into a table, then create your report on this table.
This script could be a simple VBScript which used the DSO objects and can be
scheduled to read the AS server at a regular basis or executed after you
process your cubes (I presume that you use a scheduler to process your
cubes)

last option: don't create a RS report, simple create a web page which
display this information (I think its a quick and easy way)

"Koen" <Koen (AT) discussions (DOT) microsoft.com> wrote