R12: PA: Flag, Enable In Database Analytics (OLAP Cube) Based Summarization, errors with, Please perform the pre-requisite setups, to enable this project for summarization using database analytics.

(Doc ID 2283268.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

Per note "Oracle Project Planning and Control Release Notes for Release 12.2.5 (Doc ID 2051485.1)", there is a new functionality available:

3.3 PPR Refactoring

For very large and complex projects, the size of the datasets can be extremely large and require complex processing to summarize the data on multiple dimensions including dates, task structures, currencies, and program structures.

Project performance reporting processes and architecture are enhanced to:

Improve the accuracy and performance when summarizing project data used to report project performance, plan analysis views, and project health status.

Streamline the compilation and display of project information in project plan and reporting views.

Provide a reconciliation report that provides results of completed summary data processing programs.

With the enhanced project performance reporting, core data processing relies on in-database features (OLAP CUBEs) to streamline the programs and phases. New reconciliation reports ensure that you have the information about each processing stage which ensures the correctness of project data.

When you use Enhanced Project Performance Reporting, the data needed to display plan information and analysis reports is available at all times and does not require the execution of any concurrent programs. When your projects are extremely large and complex, you can use the option to defer the automatic rollup and data summarization. You can manually summarize and view the current data by clicking the Summarize button.

--------------------------------------------------------

When trying to enable the flag, "Enable In Database Analytics (OLAP Cube) Based Summarization" on a test project, receive error

"Please perform the pre-requisite setups, to enable this project for summarization using database analytics".

Why is the error appearing and how to enable the flag?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms