With nearly 25 years experience in software and database technology I thought I had seen all that programming had to offer; then I discovered Essbase. Learn some interesting observations regarding Essbase calculations accumulated over nearly 10 years of Hyperion implementations. We will discuss aggregations, allocations, eliminations, and driver-based calculations, commands and functions specific to Hyperion Planning, and some of the more confounding aspects such as block creation and cross dimensional operators.

The DBA has numerous tools, some requiring additional licenses, some standard to any environment. When problems arise, often the administrator is expected to, not only identify, but also correct the problem without impact and in short order. This presentation goes over a number of common Oracle errors and performance issues, showing what tools, tracing to AWR reports, along with how to utilize these to quickly assess a strategy to address problems when they develop to lessen the challenge to managing these types of environments.

Attendees will leave the session with a better understanding of trouble-shooting techniques and when to use what features, tools and reports to address issues.

There is a considerable amount of free geo-spatial data available from the government and open source groups. This information can be quite helpful at providing more information about location-based data. For example, if you’re a property management company and you wanted to know close each of your properties are for anything from grocery stores to railroad tracks to flood plains, all of this information is available. If you wanted to know which homes are on a specific golf course, this data is available for free too.

In this presentation, Brad will share what geo-spatial data is available, where you can download the data, and what you might use the information for. You can also create your own layers of information and merge this into your queries. All of this can be done using an Oracle database (even the free version of Oracle) – i.e. without a mapping tool like ESRI. You can easily overlay this information onto Google maps or Google Earth. Brad will share PL/SQL code that will extract shapes into KML