Monthly Archives: December 2013

The Benefits of Using Oracle Fusion Middleware MapViewer versus Google Maps Analysis in Oracle Business Intelligence Enterprise Edition (OBIEE) 11g

December 23, 2013

Both the Oracle Fusion Middleware MapViewer (MVDEMO) and Google Maps map sources can deliver outstanding outcomes within OBIEE 11g.  One of the main differences is that MVDEMO maps are stored within your Oracle Database and Google Maps results are rendered over the internet.

MVDEMO allows you to:

  • Maintain greater control of how the background maps are displayed by customizing font sizes, colors of the grids and how layers are displayed on the maps
  • Utilize this feature without a network connection
  • Enhance control of security since no data is transferred via http websites

Is there a cost associated with using MVDEMO datasets?  The answer is “No,” but keep in mind that by using MVDEMO data sets, you are limited to using small number of sample datasets and will not have access to all of the details.  One way to get around this is by purchasing detailed maps from NAVTEQ.  This will allow you to access greater detail that you will need to graph maps in OBIEE.

Google Maps offers the following benefits:

  • Information consumers tend to be familiar with the look and feel of Google Maps and are often more attracted to its 3D street/city/region/country view features
  • You don’t need to store any map data in your Oracle database since all of the data is being rendered via an internet source

The table below captures various features and options for MVDEMO maps versus Google Maps:

JK

 

Author: Jon Kim, Performance Architects


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Four Ways to Bridge the Enterprise Performance Management (EPM) Gap between IT and Finance

December 18, 2013

You there, reading this! Are you about to start an Enterprise Performance Management (EPM) project? I bet you want it to be a success, don’t you? Have you thought about how your Finance team and Information Technology (IT) team will interact?

The following few tips can help keep the Finance and IT teams on the same page, instead of fighting over the project. While there are no magic silver bullets and there are entire books dedicated to bringing organizations together, these tips can certainly help keep everyone working together.

1. Involve IT at the beginning. 

The major issue that always seems to come up, as demonstrated in Jonathan Etkin’s previous blog post, is that IT is kept out of the project until they are needed. Ideally, someone from IT should be included from the beginning of the project until the end. This is because IT will usually be the department handling your automated nightly processes, your back-ups, and basically the entire technical side of the system. But who do you select from IT to be involved from the beginning? Continue reading.

2. Make sure there are people that can speak both “Finance-talk” and “tech-talk” on both the IT and Finance side.

Ideally, you’ll have “Project Champions” on the Finance side and the IT side. These people should have a few Oracle Certification qualifications, so that they can transfer business requirements into EPM design, and EPM design into IT requirements and design. These people will likely be the ones who will lead EPM design meetings, program the automation of the EPM system, and direct IT in using the EPM system. If you can’t find project champions within your organization, you can always ask for help here.

3. Look for solutions to problems, rather than who to blame.

Issues will always arise in projects. Naturally, the first step that always occurs is looking for someone to blame. This can lead to a rift between departments. If an issue occurs, then look at what can be changed to fix the issue, or even better, prevent it from happening again.

For example, think about backups; if data is lost, it can be catastrophic for both the IT team and the Finance team. Ideally, both teams will realize the importance of backups and ensure that they have a process to create backups of their data. This is much better than thinking about backups after the first failure to retrieve data, and having an argument about which team should have created the backups.

Generally, the IT team will oversee backups, and they would know the way to automate backup creation if they were included in the project from the beginning and Finance let them know which cubes need to be backed up.

4. When the project succeeds, share the glory.

Like Harry Truman said, “It’s amazing what you can accomplish if you don’t care who gets the credit.” Everyone likes to be part of a successful project. Make sure everyone who worked on the project gets credit. This will be useful the next time you need to get a project started. Think of it like buying some wine for an IT staffer after they fix your computer. I’m pretty sure they’ll want to fix your computer again.

As you can see, the basic idea is to get the two areas to work as a team, and to have a few people who can bridge the IT-Finance gap. These tips are just scratching the surface of this topic, so if you have any questions or comments about this, please let us know in the comments section below.

Author: Nathan Low, Performance Architects


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Still feeling bad about missing out on Oracle OpenWorld?

December 11, 2013

If you missed Oracle OpenWorld 2013 or even if you just want to listen to some of the highlights you may have missed, Oracle has them up on their Media Network here: http://medianetwork.oracle.com/media/

If you want to connect one-on-one regarding topics at OOW13, please feel free send us a note and we will be in touch!

Author: Melanie Mathews, Performance Architects


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.