mooClearAnalyzeCube


Clears the internal FinanceHub array storing the result of any mooAnalyzeCube call.  This destroys the internal array and release memory.


Syntax


               mooClearAnalyzeCube


Return Value

       

               BOOLEAN


Example


Public Sub ClearAnalyzeCube()

'returns a single dimension array of all dimensions of the variable passed to mooAnalyzeCube


Dim str() As String

Dim boo as Boolean


'Check Im connected if not connect

If Not   Application.COMAddIns.Item("myObjectiveOLAPXL.AddinModule").Object.connected Then

   boo = Application.COMAddIns.Item("myObjectiveOLAPXL.AddinModule").Object.connect

   boo = Application.COMAddIns.Item("myObjectiveOLAPXL.AddinModule").Object.connected

   Else

   boo = True

End If


str = Application.COMAddIns.Item("myObjectiveOLAPXL.AddinModule").Object.mooAnalyzeCube("GLOBAL.GLOBAL!UNITS_CUBE_COST")


For i = 0 To UBound(str)

  Debug.Print (str(i))

Next


boo = Application.COMAddIns.Item("myObjectiveOLAPXL.AddinModule").Object.mooClearAnalyzeCube


if boo then

   debug.print("Clear of internal array complete")

End If


End Sub


Return Value Example


TIME

CHANNEL

CUSTOMER

PRODUCT

Clear of internal array complete