Skip to Content
Former Member
Jan 06, 2012 at 07:40 AM

Modifying .PRM file for user defined database functions



Currently we have the BOXI 3.1.8 Universe in oracle database and we are planning to migrate to SQL server 2008.And the universe contains few oracle functions and user defined functions in the universe objects.

In the way of migration we are planning to have both Oracle and SQL Server database connecting to single universe. To make the universe generic we have identified the objects using user defined functions and trying to push it to the database.

Since there are a few differences in the way oracle and SQL Server functions are invoked, we have decided to edit the .PRM files available in the path D:\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc , so that we have a common way of invoking the functions.

Invoking functions:


SQL Server : <SchemaName>.<function>

Oracle: <function>

1.Is there any problem if I edit the .PRM?

2.Whether these changes will work fine?

3.Whether the reports will run fine if I use those objects in the reports?