-R

To specify that users are restricted from browsing table records when customizing a drill-through report.

When -R is not set, users have unrestricted access to all table records.
When -R is set to Y, users have no access to any table records.
When -R is set to F, users have no access to fact table records but have unrestricted access to all other table records.

To restrict users from browsing fact table records:

In Windows, add -Raccess_parameter to the startup.bat file.
In UNIX, type -Raccess_parameter when you start Integration Server.
In Windows or UNIX, add [R]=access_parameter to the ais.cfg file.

By default, -R is not set, giving users unrestricted access to all table records.

In Windows:

In the startup.bat file, to prevent users from accessing any table records, add -RY after "C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe". For example:

"C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe" -RY

In the startup.bat file, to prevent users from accessing fact table records, add -RF after "C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe". For example:

"C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe" -RF

In UNIX:

To prevent users from having any access to any table records, type:

olapisvr -RY

To prevent users from having any access to fact table records, type:

olapisvr -RF

In Windows or UNIX:

In the ais.cfg file, this parameter is specified in the following format:

[R]=Y

[R]=F