Tag: On-Premise BI / Analytics

Maps convey dense, multi-dimensional relationships in data faster and more intuitively than any other graphical display methodology. Access to accurate, properly displayed information is critical in a competitive environment. Maps are now built-in to OBIEE 11g as a native view and make data visualization through maps available to all users. This lab will show attendees…

In this session, learn howFusion Applications uses Fusion Middleware as its modern technical foundation.Get a behind-the-scenes look at key components of Oracle Fusion Middleware inaction, including Oracle Application Development Framework, Oracle SOA Suite,and Oracle WebCenter. Hear how they are used by Oracle development teamsto help you innovate. Learn how successful organizations are leveragingOracle Fusion Middleware…

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…

Topics covered are slowly changing dimensionsâhow to identify and design for Type I and Type II and Type III combinations. Dimensions are standard fixed-length hierarchy in many cases. But modeling non-standard, dynamic hierarchies like an organization hierarchy or account hierarchy is a different story. This session explores different methods for modeling variable-length hierarchies without impacting…

In this presentation, the attendees will learn about technique in mining the web server access log to retrieve location (From Country to a specific city) of the visitors of your website. During the presentation, it will provide sample code, and database table structure for references.

The new 11g version of Oracle Business Intelligence (OBIEE) has added many new OLAP features. One of the most significant features includes dynamic mapping of multidimensional data sources. In the past administrators needed to manually map Oracle OLAP and Essbase sources to the BI Server catalog. Then alot of special adjustments had to be made…

Today’s business intelligence implementations are becoming more and more complex, as efforts move from departmental report generation to true enterprise-wide analytics. As complexity increases and the requests for information grows, a one-size-fits all approach for reporting tool selection is no longer adequate. OBIEE 11g offers a number of tools to aid clients in providing information.…

Southwestern Energy is a growing independent energy company primarily engaged in natural gas exploration, development and production. SWN is currently implementing the Hyperion System 11 suite to create a world class financial systems platform to support the needs of a rapidly growing organization. The purpose of this presentation is to facilitate information on best practices…

It’s 10:00 pm, and your finding yourself having to go through every department’s Excel budget submission (again) to make an adjustment (again) and find that someone’s made a change that you didn’t expect (again) and someone else has overwritten a formula in one cell (again) – you’re thinking to yourself that there must be a…

Learn how to create highly formatted reports using Oracle BI Publisher through hands on exercises. Create a report and layout directly through the browser using the Layout Editor. Build a data model that combines and structures data from an Oracle Database and an Excel Spreadsheet. Learn how to Schedule reports for recurring jobs.