In version 7.9.6.1 of Project Analytics, you may have noticed a subtle difference between the way in which to-date budget amounts are reported when compared to figures in the E-Business Suite (e.g. PJI / Performance Reporting). This has now been addressed (albeit partially) in release 7.9.6.2 of OBI Applications.
Quick Links
Login
Home 
Project Analytics
Project Analytics
Archive for the ‘Project Analytics’ Category
Project Analytics 7.9.6.2 addresses budget date range issue
Tuesday, October 19th, 2010 by Andy CoatesOBI Appications 7.9.6.2 released, Project Analytics new features
Wednesday, September 22nd, 2010 by Andy CoatesVersion 7.9.6.2 of OBI Applications has recently been released and is available for download from Oracle eDelivery.
Project Analytics sees some updates in the latest release, most notably the introduction of a project commitments subject area. The full list of updates to Project Analytics are:-
- New Project Commitments Subject Area for Oracle EBS
- Updates to Universal Adapter for Oracle Project Analytics
- Configuration Update for Project Customer for Oracle EBS
- My Oracle Support Technical Note on How to Configure RPD if the Cost Aggregate Grain is Set to Period or Year
- New Dimension for Project Budget and Forecast Fact
- Linear Spread Metrics for Project Budget Fact
A full summary of the new features across the 7.9.6.2 OBI applications can be found on oracle.com here, with the Project Analytics updates here. No doubt that a number of bug fixes have also been included, as previously alluded to in My Oracle Support.
Oracle SQL Functions in OBI Answers
Monday, April 19th, 2010 by Andy CoatesFor those of you who use OBI Answers, you may have noticed that when defining column formulae in requests that the standard Oracle database function set is not used. This is likely to be a throwback to the pre-Oracle origins of the product, but it is most frustrating for those of us with a SQL background solely in the Oracle world. Read the rest of this entry »
Project Analytics – Help At Last
Wednesday, September 16th, 2009 by Projected ConsultingWhy do I need Project Analytics?
How many of you have been through an Oracle Projects implementation either as a client or functional consultant and can recognise this situation? You have worked through fact finding interviews, discussions and CRPs, you now have a configured Oracle Projects system to meet the detailed transactional needs and then somewhere along in all this process you come to look at reporting. The conversation is then a little tense as Oracle Projects is really good at getting data in and not always so nice at helping you get it out again, especially not in aggregate.
In other words, it is exactly at the sort of level that directors, financial controllers and senior project managers may wish to see useful information that Oracle Projects is probably at its least amenable. For functional consultants, such as me, this has always been an uncomfortable area, despite significant improvements delivered in the application over the years and the power of tools such as Discoverer. Now at last some welcome help is coming our way through the recently released (May 2009) Project Analytics, part of Oracle BI Applications 7.9.6.
The difficulty of deriving real insight and intelligence from detailed transactions is of course not restricted to Oracle Projects, it affects all systems built using the relational data model. As a chartered accountant and non-technical functional consultant I have to tread carefully here as I am not a technical consultant but in essence relational systems such as Oracle EBS are terrific at getting data in as they avoid duplication and provide all sorts of relationship and integrity controls between related pieces of data.
However, because of these very same relationships within such Transactional (OLTP) systems, pulling data out again requires considerable skill (understanding the complex relationships) and computing power (potentially large data volumes and much joining together of data separated in the relational design.) Over years there has therefore grown up a range of Business Intelligence (BI) tools designed to help aggregate, collate and provide real insight into the detail so assiduously collected by OLTP systems such as Oracle EBS.
Project Analytics is a new Business Intelligence solution from Oracle, the technical details of which have appeared in Antony Heljula’s guest article Review of Oracle BI Applications 7.9.6 and Project Analytics and Andy Coates’ Oracle BI Applications 7.9.6 – Project Analytics Screenshots. I hop that this short article will give something of a user eye view of the benefits of Project Analytics and how much help it can be.
What Does Project Analytics Give You?
Project Analytics has four main components:
- Pre-built warehouse
- Prebuilt Extract Transform and Load (ETL) process. The Analytics tools can gather data from all manner of places through “adapters”, one of which is for Oracle EBS
- Pre-mapped Meta data including over 350 pre-built calculations and metrics
- Best practice library of over 120 reports.
Oracle BI Applications 7.9.6 – Project Analytics Screenshots
Monday, August 24th, 2009 by Andy CoatesFollowing on from Antony Heljula’s excellent blog post on Project Analytics (Review of Oracle BI Applications 7.9.6 and Project Analytics), here are some screenshots of the application:-
The Project Analytics dashboard index page, with full descriptions for all of the out-of-the-box dashboards.