Hey Everyone.
This is what I have so far,however I am getting the following error at this line :
objmodel.CreateMDCFiles , a msg box that states the server is busy appears. The message box states : Action cannot be completed because the other program is busy. Choose "Switch To" to activate the busy program and correct the program.
Does anyone know how to resolve this?
Just as a general FYI, I am using a batch file and a macro to disable the cube, rebuild the cube, copy the new cube and then enable the cube. The purpose of the macro is to build the cube and logon to the Common Logon Server.
Sub Main()
'declare variables
Dim objTransApp as Object
Dim objModel as Object
Dim objDrill As Object
Dim objAssociation As Object
Dim objColumn As Object
Dim strModelPath As String
Dim strLocation As String
Dim strModelSource As String
strLocation = "INSERT Cube Location Path"
strModelSource = "INSERT PYI file "
strModelPath = strLocation & strModelSource
Set objTransApp = CreateObject("CognosTransformer.application.cer3"

Set objModel=objTransApp.OpenModel(strModelPath ,"Administrator", " INSERT Password" , "Root User Class"
'build Cube
objmodel.CreateMDCFiles
objModel.close
Set objColumn = Nothing
Set objAssociation = Nothing
Set objDrill = Nothing
Set objModel = Nothing
Set objTransApp = Nothing
End Sub