On the BI Publisher screen:
- Select the Connect to Oracle Analytics Server option.
Note: If you would rather configure Oracle Analytics Server manually or do not have Oracle Analytics Server installed, verify the Connect to Oracle Analytics Server option is clear and click Next. See the P6 EPPM Oracle Analytics Server Configuration Guide for more information.
- In the Server URL field, enter the URL used to connect to the Oracle Analytics Server web service to P6.
For example,
http://serverIP:port/xmlpserver/services/PublicReportService?wsdl - In the Version field, enter the version of Oracle Analytics Server that you want to integrate with P6.
- In the Folder Paths field, enter the relative path to the Oracle Analytics Server P6 reports folder where P6 will search for reports.
Example format (the forward slash is required):
/P6REPORTS
- Note: You can find the relative path (for example, /P6Reports) in the following folder:
%weblogic_home%\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Reports
- Note: You can find the relative path (for example, /P6Reports) in the following folder:
- In the Admin Username field, enter a Oracle Analytics Server web services user name with administrative privileges (for example, PxRptUser).
- In the Password field, enter the password for the administrative user name.
- Select Personal Folders, to enable personal folders per user. If you do not want to use personal folders, leave the option clear. Users have their own personal folders where they can store their objects. Only the user who created and saved the content in the folder can access the folder.
- Select Scrub Username, to enable the setting or leave it clear to ensure it is disabled.
This setting controls whether special characters (non-alphanumeric) are removed from the user name when connecting to Oracle Analytics Server. The default is 'false,' meaning special characters will not be removed.
If you are using the P6 EPPM Extended Schema for Oracle Analytics Server reporting, leave the setting as false.
If you are using the P6 ODS Schema for Oracle Analytics Server reporting, change the setting to true. Setting the value to true will allow the user's security context (user name) to format properly before it goes to Oracle Analytics Server. This allows reporting queries to perform against the ODS tables.
- In the Cache Timeout field, enter how long cached report definitions should appear.
The default is 1d.
- Click Next.