Saturday, April 28, 2012

Collaborate 2012 - April 22-26

The week of Collaborate conference 2012 is over! It turned out to be a action packed week. It started on Saturday with a full day IOUG board meeting. I have been nominated to the IOUG Board for 2012-213 and will be taking care of Product Integration Portfolio with focus on Exa-systems. On Sunday, we conducted the Deep Dive on Oracle BI Applications (OBIA) along with a friend JV and Oracle Product Management folks. This was intense 5 hr class between 9 am and 3 pm on Sunday and had 20+ attendees. The day ended with IOUG SIG reception were Mark Townsend was recognized for his contributions to IOUG community, posthumously. It was nice meeting Dr DBA or Ken Jacobs in the event, even though he has retied from Oracle. The BIWA SIG board had dinner the same night and discussed possibilities of BIWA SIG and the Quest BI SIG working closer in future.

Monday morning was no rocket science! It was key note with Mark Kelly... I was lucky to obtain his autographed book and here is the picture with him!

Wednesday, April 11, 2012

Getting Ready for IOUG Collaborate 2012

It is that time of year!   Collaborate 2012 is less than two weeks away. This time it is in Las Vegas, April 22-26. It has been alternating between Orlando, FL and Las Vega, NV, tow cities that are very conference friendly.

The event will be full of exciting content in the BI, DW & EPM (BIWA) Track, starting with the Deep Dive on Oracle Business Intelligence Applications on Sunday. The Mon-Wed will be filled with several sessions from customers, implementer and Oracle Product Managers. Apart from regular sessions and Panel discussions, take advantage of the Hands on Labs, at no extra cost on a variety of topics from OBIEE, Spatial/MapViewer to Advanced Analytics such as Oracle Data Mining, Oracle Enterprise R and OLAP.  In the Hands on Labs (HoL) you actually work on a computer, on a virtual machine and get to carry out the exercises in 1-2 hr session.  Add these to your schedule if you want to join these sessions and come in early.

I have to jump on an IOUG call, so more later...

Saturday, April 7, 2012

Oracle Business Intelligence Applications - Manufacturing and Enterprise Asset Management Analytics (OBIEE based)

The coverage of Oracle Business Intelligence Applications for Oracle and SAP  ERP continues to extend. The most recent addition from April 4, 2012 is the the new Oracle Manufacturing Analytics and Oracle Enterprise Asset Management Analytics Applications including the connectors for IBM Maximo. This was released through the Extension Pack for branch.  At the same time Oracle extended the coverage for the SAP customers from Finance to Sales & Distribution and Materials Management with the support for Procurement and Supply Chain Performance Applications on the branch.  I have come across companies that are a mix of Oracle and SAP either by choice such as PeopleSoft for HCM and SAP for Finance and Manufacturing or due to acquisitions. With the availability of coverage for back-office applications (ERP) for both Oracle and SAP, now customers have increased choice for packaged applications.

The new applications such as the Manufacturing and Enterprise Asset Management (EAM) Analytics currently comes with the support for Oracle E-Business Suite. The support for J D Edwards is not available right away, which is little interesting as a lot of manufacturing shops use JDE. So how do these applications differ from the prior release of new functionality?  These applications will come with a new OBIEE repository (rpd) that can be merged with the current release at the customer site such as 7962 or 7963. This is the same concept as the Spend Classification that has its own rpd. The three way merge for RPD comes in handy here. The new applications were developed for companies in the manufacturing, energy production, utilities and other asset-intensive industries. Also the first time IBM Maximo connectors are made available as it very popular for managing fixed assets specially in the public sector.

What does it mean for current, and customers of Oracle EBS?   The good news is the new functionality is available for all these customers. For instance a customer can take the newly released rpd for based on OBIEE 10g and merge it with their current (and  retain any configuration and customization) easily. The same option applies for or (OBIEE 11g based) customers. In the way the Informatica and DAC metadata has to be merged with the existing code.  Please note the new SAP analytics functionality is on its own branch and the above ( extension pack) does not apply to it.

These Extension pack is certified to run on Oracle Exalytics In-Memory Machine, as long as you use version of OBIEE. Native support for tablet and mobile devices, such as the Apple iPad and iPhone is provided as well on the OBIEE 11g path. I personally thing the RIM/blackberry support is a gap, but I think most other Mobile Computing enthusiasts will differ from me and say the Blackberry OS has no role in tablet space and hence in enterprise mobility! Well time will tell.

The new Manufacturing Analytics will allow the customers to gain visibility into manufacturing schedules, cost, quality and service levels and correlate work order information with production plans. This can lead to possible reduction in work order cycle time and aging of open work orders. Customers can now perform non-conformance and disposition analysis and improve insight into raw materials and finished goods. To make best use of this Analytics Application, you must be using E-Business Suite Manufacturing Applications, including Discrete Manufacturing, Process Manufacturing, Flow Manufacturing, Hi-Tech Manufacturing Quality and Inventory modules.  Current SCM Analytic Applications had support for Discrete inventory and it lacked OPM support, so this is a good enhancement release. You can see the piece of the Manufacturing Analytics in the visual below.

The new EAM Analytics will help to provide information to improve the quality of decisions and ultimately optimize asset utilization. Companies can manage plant, machinery, and equipment by asking these questions:
• What does it cost to maintain & operate my assets?
• What is the expected life of our assets?
• How can we get timely asset information and respond more quickly to change?
• Which asset strategies work to our advantage to drive uptime?

These questions can be answered with the help of the following areas of EAM Analytics:

  • Maintenance Cost Analytics
  • Work order Analytics
  • Inventory and Costing Analytics
  • Quality Analytics
  • Resource Analytics
  • Asset Genealogy Analytics
Oracle BIWA SIG ( will organize a Techcast on this topic on april 18, 2012, you can pre-register here: