Processing a Virtual Cube

Question

Processing a Virtual Cube

Jim Dickel

SSC Rookie

Points: 43
More actions
September 22, 2005 at 4:24 am

#115171

We process our normal cubes from a command file but have been unable to find out how this is done for a Virtual Cube.
September 26, 2005 at 8:00 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Bad dog Old Hand Points: 387 More actions · Answer 1

This is an ActiveX script we run in DTS. Not sure if you can use it in a command file or if it is different for a virtual cube. Hope you get something useful out of it.

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Main = DTSTaskExecResult_Success

End Function

Function DTSTaskExecResult_Success()

On Error Resume Next

Dim m_oDSODestServer 'As DSO.Server

Dim m_oDSODestDB 'As DSO.MDStore

Dim l_sDBName 'As String

Dim l_sCubeName 'as String

Dim l_sDimName 'as String

Dim i 'As Integer

Dim PartProcess 'As Integer

PartProcess = 1 ' 1 = Full process of Dimensions

' 2 = Keep Dimension structure, but only drop and get the 'data back

'Private m_oDSODS 'As DSO.DataSource

'Create instance of server and connect.

Set m_oDSODestServer = CreateObject("DSO.Server")

Set m_oDSODestDB = CreateObject("DSO.MDStore")

m_oDSODestServer.Connect "YourServerName"

Set m_oDSODestDB = Nothing

' Set Database name that you wish to work with

l_sDBName = "YourCubeDatabaseName"

'Set the Cube Name that you wish to work with

l_sCubeName = "YourCubeName"

' Process Single Cube

m_oDSODestDB.mdstores(l_sCubeName).Process 1 'processFull

Set m_oDSODestDB = Nothing

Set m_oDSODestServer = Nothing

DTSTaskExecResult_Success = Err.Number

End Function

Jim Dickel SSC Rookie Points: 43 More actions · Answer 2

Thanks for your help.

We do in fact process our normal cubes using an ActiveX script in a DTS package executed from a command file. The script is in line with your script but it does not work for a virtual cube.

Bad dog Old Hand Points: 387 More actions · Answer 3

Ok, not sure then. Just some other obvious thoughts: Are you sure all the normal cubes the virtual cube needs are fully processed before the virtual process starts? Have you tried DTS logging to see if you can pick up what goes wrong? Can you use the built in cube process task of dts?

Jim Dickel SSC Rookie Points: 43 More actions · Answer 4

We have always used an ActiveX script so I am embarressed to admit that I was not even aware of the Analysis Server Process Task.

It worked!

Thanks for you help.

Bad dog Old Hand Points: 387 More actions · Answer 5

Bad dog

Old Hand

Points: 387

September 28, 2005 at 5:40 am

#593603

Cool!