Configuring an Oracle Standard Edition Database

Previous TopicNext TopicContents

If you are using Oracle Standard Edition as your database, you must use a non-default setup option with P6 Reporting Database. P6 Reporting Database uses row-level security as its default security, and Oracle Standard Edition does not support row-level security. You must disable the security policies script to use Oracle Standard Edition.

To enforce security when using P6 Analytics, you must use a different RPD. This RPD will contain security built into the RPD and can be found in the rpd\StandardEdition folder for P6 Analytics. Deploy this RPD in your OBI environment or build the RPD using the UDML file also in the rpd\StandardEdition folder. Partitioning is on by default when running through the configuration utility. There is an option to choose a non-partitioned installation in the configuration utility. If you ran the configuration utility and didn't enable partitioning, follow the steps in Creating Non-partitioned Deployments.

Related Topics

Installing and Configuring the Star Database

Creating Non-partitioned Deployments

Creating a New RPD for SE Security

Installing the Star Database

Configuring the Star Database

Running the STARETL Process

Updating the RPD file

Multiple Data Sources in the Star Database

Star Security Configuration

Installing and Configuring Financial Periods



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014