Product specifications

Configuring database capability parameters
12.1 About database capability parameters
Database capability parameters describe capabilities of databases used as sources of data for the
contents of a universe. You can set these parameters to operate at the following levels:
• Universe level
You set these parameters when you create or modify a universe.
• Database level
You set these parameters in the PRM file of the database. They are overridden by any corresponding
setting at universe level.
Note:
To view the operators and functions available for your data access driver, open the <driver>.prm
file in an XML editor.
12.2 About PRM files
PRM files provide you with parameters that describe capabilities of databases used as sources of data
for SAP BusinessObjects applications. They allow database-dependent factors to control what SQL
can be used with the universe, based on the connection and the database that it is attached to. There
is a PRM file corresponding to each database driver.
You can configure some database capability parameters from inside a universe. They override PRM
file settings consequently.
PRM files are located in the connectionserver-install-dir\connectionServer\<RDBMS>
directories, where <RDBMS> is the network layer or middleware name.
Note:
Help text files in other languages are also available in the same directories.
2012-03-15155
Configuring database capability parameters