MOPS2003 - OLAP build date or status in DB ?

[Thomas Bräutigam]

Hi all,

as I would like to use the latest OLAP build date or even status in
SQL Reporting Services Reports...
....does anyone know where to find this date in the database?

Best Regards
Thomas

PS: We're (still) using Project / Server 2003 SP3

 

[Mike Mahoney]

Hi all,

as I would like to use the latest OLAP build date or even status in
SQL Reporting Services Reports...
...does anyone know where to find this date in the database?

Best Regards
Thomas

PS: We're (still) using Project / Server 2003 SP3

Hi Thomas

In the Olap Repository database, in the OlapObjects table there is a
Lastupdated field.

regards

Mike

 

[Thomas]

Hi Thomas

In the Olap Repository database, in the OlapObjects table there is a
Lastupdated field.

regards

Mike

Mike,

thanks for the quick response, but I cannot find the database or even
the table you mentioned...we're using Project Server 2003...

What I can find is "WADMIN_CUBE_LOG_STATUS" in DB Table
"MSP_WEB_ADMIN_CUBE" within the Project Server DB.

Could you be more precise please?

Best Regards
Thomas

 

[Mike Mahoney]

Mike,

thanks for the quick response, but I cannot find the database or even
the table you mentioned...we're using Project Server 2003...

What I can find is "WADMIN_CUBE_LOG_STATUS" in DB Table
"MSP_WEB_ADMIN_CUBE" within the Project Server DB.

Could you be more precise please?

Best Regards
Thomas- Hide quoted text -

- Show quoted text -

Hi Thomas

In both PS 2003 and 2007 you have the opportunity to "migrate the olap
repository" to a sql database, which is something I always do. The
repository contains cube metadata (such as Last Updated information
for each cube element). If you have not migrated then the information
will be sitting in an mdf file somwhere. Its not something I have
looked at in any detail. The data would clearly be more accessible if
you did migrate.

The migrate function was a feature of AS2000. In AS 2005 a script is
available to build the repository database and you change AS property
settings for AS to make use of this table.

regards

Mike