The Essbase Block Storage calc engine is one of it's most powerful features.  Sadly, most people are just using simple member formulas and running default aggregation calcs.  To unlock the true power of Essbase BSO, you need to tap into Essbase calc scripts and the 350+ functions that make up the Essbase Calc Script language. …

This presentation will demonstrate how SQL coding techniques were used to report data from Parent–Child data relationships in Oracle Tables. Fairbanks Morse Engine, Inc (FME) builds engines composed of thousands of parts. Several Oracle E-Business Suite Application modules are used to maintain the data used in the building, selling and distribution of these engines and…

While Essbase and OBIEE are powerful separately, with the advent of OBIEE 11g, they are even stronger working together.  If you've been using tools like Web Analysis and Interactive Reporting on Essbase or if you've been using Answers and Dashboards on relational sources, come to this lab to learn how to use OBIEE+ 11g on…

Oracle Locator is available as part of every edition of the Oracle Server, and is extended in Enterprise Edition through the Spatial option. OBIEE 11g is aware of Oracle Spatial and Map Viewer, a component of Fusion Middleware.

This paper takes an in depth look at the integration of OBIEE and Spatial, starting with an overview of Oracle Spatial as a data source, through integrating and troubleshooting the display of spatial data through Map Viewer.

We will present who we are, what our Records Management environment is, and how far we have progressed two years after implementation. We will explain our implementation efforts on Electronic Records Management including file system and emails. We will share our lessons learned with other users who are considering electronic records management.

As a new DBA, you may be eager to learn new skills while trying to absorb as much technical information as possible. There is light at the end of the tunnel, but is it an oncoming train? Technical skills are important but you can also learn important lessons from others who have succeeded as DBAs,…

Oracle Exalogic and Exadata x2-8 provides a basefor private clouds and workload consolidation. Each workload hasunique profile, different seasonal peaks and different SLOs. It is easy to create a policy controlling resource management, but difficult to find rules capable to satisfying SLOs of the individual workloads. In this presentation we will review several case studies…

Being an Oracle server process is no easy thing. While typically doing a whole lot of nothing, when asked to do something expectations are extremely high. And all this happens while it's being subjected to all sorts of infuriating roadblocks. If you think teenage drama is exhausting, that's nothing compared to what an Oracle server…

Founded by two high school students in 2005, myYearbook.com has grown to become one of the top 5 social networks and one of the top 25 most trafficked web sites in the United States. In the face of such growth and large traffic volumes, we continually face technical challenges in achieving operational stability. In this…

Many traditional Oracle developers are asking themselves if they should invest their time in the new middleware technologies. Despite many years of Java presence in the database, PL/SQL is still number one choice for most seasoned Oracle DBAs and developers. BPEL and middleware technologies are making the shift to occur allowing separation of integration from…