dbTalk Databases Forums  

DSO - LastProcessed (MDStore Interface) - what exactly means that date

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss DSO - LastProcessed (MDStore Interface) - what exactly means that date in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GW
 
Posts: n/a

Default DSO - LastProcessed (MDStore Interface) - what exactly means that date - 05-23-2006 , 04:36 AM






Hello,
I have short code written in vbscript:


' ******* BEGIN CODE *************
Dim dsoServer
Dim dsoDB
Dim dsoCube

Set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "MY_SERVER"

Set dsoDB = dsoServer.MDStores("MY_CUBE")

Set dsoCube = dsoDB.MDStores("MY_01_PHYSICAL_CUBE")
dsoCube.Process processFull

Set dsoCube = dsoDB.MDStores("MY_02_PHYSICAL_CUBE")
dsoCube.Process processFull

Set dsoCube = dsoDB.MDStores("MY_VIRTUAL_CUBE_BASED_ON_TWO_PHYSI CAL")
dsoCube.Process processFull

Set dsoCube = Nothing
Set dsoDB = Nothing
Set dsoServer = Nothing

' ******** END CODE

The code runs about 50 minutes. When I try read LastProcessed property of
MY_02_PHYSICAL_CUBE when cube is processing, I see the date when cube
started processing, but it is not the date when the cube was last
successfuly processed (even LastProcessed property of
MY_VIRTUAL_CUBE_BASED_ON_TWO_PHYSICAL is changing during processing physical
cubes) . When processing of the cube has finished, then LastProcessed
property returned me correct date.

Is it normal behaviour ? How using DSO (what properties should I check) to
be sure that, cube was today processed (but it is not during processing at
the time of checking) ? Please help me.

Greetings,





Reply With Quote
  #2  
Old   
Designing-Systems.com
 
Posts: n/a

Default RE: DSO - LastProcessed (MDStore Interface) - what exactly means that - 05-23-2006 , 01:42 PM






hi,

The LastProcessed property is updated when the cube processing is complete
and the cube is successfully processed.

Kind regards,
---------------------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
----------------------------------------------

"GW" wrote:

Quote:
Hello,
I have short code written in vbscript:


' ******* BEGIN CODE *************
Dim dsoServer
Dim dsoDB
Dim dsoCube

Set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "MY_SERVER"

Set dsoDB = dsoServer.MDStores("MY_CUBE")

Set dsoCube = dsoDB.MDStores("MY_01_PHYSICAL_CUBE")
dsoCube.Process processFull

Set dsoCube = dsoDB.MDStores("MY_02_PHYSICAL_CUBE")
dsoCube.Process processFull

Set dsoCube = dsoDB.MDStores("MY_VIRTUAL_CUBE_BASED_ON_TWO_PHYSI CAL")
dsoCube.Process processFull

Set dsoCube = Nothing
Set dsoDB = Nothing
Set dsoServer = Nothing

' ******** END CODE

The code runs about 50 minutes. When I try read LastProcessed property of
MY_02_PHYSICAL_CUBE when cube is processing, I see the date when cube
started processing, but it is not the date when the cube was last
successfuly processed (even LastProcessed property of
MY_VIRTUAL_CUBE_BASED_ON_TWO_PHYSICAL is changing during processing physical
cubes) . When processing of the cube has finished, then LastProcessed
property returned me correct date.

Is it normal behaviour ? How using DSO (what properties should I check) to
be sure that, cube was today processed (but it is not during processing at
the time of checking) ? Please help me.

Greetings,






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.