Example of an Excel VBA application using the mooDimLen function:
Returns the maximum length of an Oracle OLAP dimension as supplied to the function.
The result is the same as executing an obj(dimmax 'DIMNAME') within the Oracle OLAP environment.
Syntax
moodimlen(“ [dim1] “)
Example of an Excel VBA application using the mooObjType function:
Public Sub mooObjType()
If Not oregistered Then: boo = regQ:
If Not o.connected Then
boo = o.connect
boo = o.connected Else
boo = True
End If
If boo = True Then
Debug.Print o.mooObjType("ALLCOMPILE")
Debug.Print o.mooObjType("INTL.MLANGMAP")
End If
End Sub
Returns the maximum length of an Oracle OLAP dimension as supplied to the function.
The result is the same as executing an obj(dimmax 'DIMNAME') within the Oracle OLAP environment.
Syntax
mooobtype(“ [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
