Example of an Excel VBA application using the mooExists function:
Public Sub mooExists()
If Not oregistered Then: boo = regQ:
boo = o.mooExists("ALLCOMPILE")
If boo = True Then
MsgBox "Yes, ALLCOMPILE Exists"
Else
MsgBox "No, ALLCOMPILE Does Not Exist"
Debug.Print o.getLastMooErr
End If
End Sub
Enables the developer to identify if a given object exists within an Analytic Workspace in the current Oracle OLAP session
Syntax
mooexists(“ [object name] “)
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010
