myObjectiveOLAP Files and Components


myObjectiveOLAPXL.dll


myObjectiveOLAPXL.dll is the core library that is used by any of the myObjectiveOLAP applications. myObjectiveOLAPXL.dll is not optional and must be installed in order to connect Microsoft Excel to the Oracle OLAP database using the myObjectiveOLAP data provider.  myObjectiveOLAPXL.dll contains pre-defined functions which are exposed to Microsoft Excel.


myObjectiveOLAPXL.dll Exposed functions


These functions are grouped into four sections:


Common Functions


Common functions enable the end user to interact either with the myObjectiveOLAP library itself or to execute commands or retrieve output from the Oracle OLAP server application.


The functions include a number of low level API's that do minimal checking before attempting to execute within the server side environment. It is best practice to only use these APIs if myObjectiveOLAP does not offer a function to do this for you. By using the myObjectiveOLAP functions in your code, additional pre-execution checks are performed and enhanced error trapping is available to you.


GUI Functions


A number of functions offered by the myObjectiveOLAP framework can provide the end-user with a graphical interface into the Oracle OLAP option.


Common Options


Common options enable the end-user to control Oracle OLAP server side options.


Reporting Functions


These are Excel worksheet cell based functions which can be used by end users to develop rich reporting solutions