On Windows systems only, [SQR Extension] defines DLLs containing new user functions (ufunc) and user calls (ucall). Ufunc and ucall reside inside SQREXT.DLL and/or other DLLs.
When SQR.DLL and SQRT.DLL are loaded, they look for SQREXT.DLL in the same directory, and for any DLLs specified in [SQR Extension] such as:
Any new extension DLLs containing new user functions must be listed in [SQR Extension] in SQR.INI. For more information, see “Interoperability” in Volume 1 of the Hyperion SQR Production Reporting Developer's Guide.
For Windows/Oracle, Production Reporting uses dynamic binding of Oracle routines. When Production Reporting tries to access an Oracle database, it searches for the Oracle DLL as follows: