olapQDR(“ [valid QDR statement] “)


An end user orientated function that can be used to return a value from an Oracle OLAP array by fully qualifying the coordinates within the array.                        


Syntax


               olapqdr("[valid QDR statement]")


               Where QDR statements in the the form

               cube(dim1 dimval1 dim2 dimval2 ….dimx dimvalx)

               The QDR must be fully referenced for the stated cube otherwise an error will be returned.


Return Value


               STRING


Example


Public Sub olapQDR()

'Pass a QDR to Oracle OLAP and return the result


Dim boo As Boolean


If Not oregistered Then:   boo = regQ:


'Check Im connected if not connect

If Not o.connected Then

   boo = o.connect

   boo = o.connected

   Else

   boo = True

End If


'Connected so bring up the command line

If boo = True Then

   boo = o.mooAwAttach("EXPRESS", "FIRST")

             'INTL.MLANGMAP is a variable within the Express AW

         'You can pass any valid OLAP qdr to olapqdr

          Debug.Print (o.olapQDR("INTL.MLANGMAP(INTL.MLANG 'ENB')"))

End If


End Sub