You can use SQR Production Reporting Studio to define security rules based on users and groups defined in Oracle's Hyperion Reporting and Analysis applications in Oracle's Hyperion® Shared Services.
To define security rules:
Connect to Shared Services to retrieve a list of users and groups.
Make any desired edits, and save the list as a text file.
The text file must have two variables, User Name, Mode. For example:
User1, ON User2, ON User3, OFF
Display the report in the SQR Production Reporting Studio Layout window.
Select Report, then Report Properties.
Select the Security tab.
Check Security and select a security file.
After you select a security file, the User Name and Mode fields are populated.
Click OK.
After you create a security file, the information is embedded in the SQR code for the report, and is applied when the Production Reporting job is run in EPM Workspace. You can then “burst” the file (send the results of running the Production Reporting job to the appropriate users as described in the security file).