FinanceHub Files and Components


myObjectiveOLAPXL.dll


myObjectiveOLAPXL.dll is the core library that is used by any of the FinanceHub applications. myObjectiveOLAPXL.dll is not optional and must be installed in order to connect Microsoft Excel to the Oracle OLAP database using the FinanceHub 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 FinanceHub 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 FinanceHub does not offer a function to do this for you. By using the FinanceHub 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 FinanceHub 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