P6 Reporting Database User's Guide - Oracle

P6 Reporting Database User's Guide Release 3.0

December 2011

Copyright

Oracle Primavera P6 Reporting Database User's Guide Copyright ? 2008, 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose. The platform-specific hardware and software requirements included in this document were current when this document was published. However, because new platforms and operating system software versions might be certified after this document is published, review the certification matrix on the My Oracle Support Web site for the most up-to-date list of certified hardware platforms and operating system versions. The My Oracle Support Web site is available at the following URL: If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software -- Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.

2

Copyright The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party. To view the list of third party technology disclosures related to this product, please see the Commercial Notices and Disclosures document for the release.

3

Contents

Copyright........................................................................................................................................... 2 Preface.............................................................................................................................................. 7

Where to Get Documentation........................................................................................................... 7 Where To Get Training .................................................................................................................... 10 Where to Get Support ..................................................................................................................... 10 About this Guide .............................................................................................................................. 11 Before You Begin ............................................................................................................................ 13 About P6 Reporting Database ........................................................................................................ 13 About the P6 EPPM Extended Schema..........................................................................................13 About the STARETL Process ........................................................................................................... 13 About the ODSETL Process ............................................................................................................. 14 About Security in P6 Reporting Database ..................................................................................... 14

About ODS Security .................................................................................................................... 14 About Star Security .................................................................................................................... 14 About Scheduling ............................................................................................................................ 14 Operational Data Store (ODS)......................................................................................................... 17 Fields in the ODS ............................................................................................................................. 17 De-Normalized Fields from P6 EPPM.............................................................................................17 Creating Reports in BI Publisher..................................................................................................... 21 Creating a Folder for the Report.....................................................................................................21 Creating the Report ......................................................................................................................... 21 Editing a Report...............................................................................................................................22 Exporting Data to an XML File ........................................................................................................ 22 Creating Report Templates ............................................................................................................. 22 Sample BI Publisher Reports..........................................................................................................23

5

Preface

With P6 Reporting Database, you can generate databases that can be used to extract and transform data from the P6 EPPM database. You can use this data to create reports using Oracle Business Intelligence Suite or other third-party reporting tools The two types of databases are the Operational Data Store (ODS) and the Star Schema Database (Star).

In This Section Where to Get Documentation................................................................................................................ 7 Where To Get Training .......................................................................................................................... 10 Where to Get Support............................................................................................................................ 10 About this Guide ....................................................................................................................................... 11

Where to Get Documentation

For the most up-to-date versions of all manuals and technical documents related to installing, administering, and using P6 EPPM, go to:



Most documentation assumes a standard setup of the product, with full access rights to all features and functions.

You can also access the versions of the product manuals and technical documents that were available at the time of the release from the P6 EPPM Documentation Center, located in the \Documentation\Documentation_library\language folder of the P6 EPPM physical media or download.

The following table describes the core documents available for P6 EPPM and lists the recommended readers by role. P6 EPPM roles are described in the Planning Your P6 EPPM Implementation guide.

Title

What's New in P6 EPPM

Planning Your P6 EPPM Implementation

Description

Highlights the new and enhanced features included in this release. You can also use the P6 EPPM Cumulative Feature Overview Tool to identify the features that have been added since a specific release level. All users should read this guide.

This book provides information on planning your implementation. It provides an installation process overview, frequently asked questions, client and server requirements, and security information. The P6 EPPM network administrator/database administrator and P6 administrator should read this guide.

7

P6 Reporting Database User's Guide

Title

P6 EPPM Installation and Configuration Guide

Description

This documentation set explains how to install and configure the P6 EPPM using the P6 EPPM Installation and Configuration wizards.

The P6 EPPM network administrator/database administrator and P6 administrator should read this guide.

P6 EPPM Installation and Manual Configuration Guide

This documentation set explains how to install and configure the P6 EPPM using the P6 EPPM Installation wizards, and how to manually configure individual components.

The P6 EPPM network administrator/database administrator and P6 administrator should read this guide.

P6 EPPM Post Installation Administrator's Guide

Once you have installed and configured your P6 EPPM applications, this guide will tell you how to get started using them. You will want to complete most of the tasks in this guide before you let your users work with these applications. These tasks include information about configuring your users and security settings and privileges, setting your P6 Administrator application and P6 Progress Reporter Administrator settings, and finalizing your P6 Integration API and P6 EPPM Web Services settings.

The P6 EPPM network administrator/database administrator and P6 administrator should read this guide.

Tested Configurations

Lists the configurations that have been tested and verified to work with P6 EPPM. The network administrator/database administrator and P6 EPPM administrator should read this document.

P6 EPPM User's Guide

This guide explains how to plan, set up, and manage projects in a multiuser environment. If you are new to P6 EPPM, start with this guide to learn how to use the software effectively to plan and manage projects. When you need more detail, refer to the P6 Help. The program manager, project manager, resource/cost manager, and team leader should read this guide.

P6 Data Dictionary

This data dictionary defines fields used in P6.

P6 Team Member User's Guide

This guide explains how to status activities using P6 Team Member applications, which are P6 Team Member Web, P6 Team Member for iPhone, and E-mail Statusing Service.

P6 Team Member Web Help Describes how to use P6 Team Member Web to provide status on activities. Team members should read this Help.

P6 Team Member for iPhone Describes how to use the P6 Team Member for iPhone app to

Help

provide status on activities. Team members should read this Help.

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download