Hello,

Is it possible to retrieve the LastProcessed time of a cube from a stored
procedure?

Best regards

Henrik Skak Pedersen

Not easily. It is available as a DSO property, so one way would be to write
a COM object (let's say in VB) which looks up the value using DSO -- and
call the component via sp_oaXXX.

A backdoor would be to access the repository directly and parse the XML
located there.

Or to use the data/time stamp on the data files in the Data folder structure
on-disk.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Henrik Skak Pedersen" <notavailable (AT) nothing (DOT) com> wrote

I try to understand DSO but it's difficult. VB and sql is not a problem. Can you give me an example of the code you can use to get LastProcessingtime?

--
Message posted via http://www.sqlmonster.com