How to do forecasting and allocations in Business Intelligence Systems will cover Essbase forecasting and allocations. The audience will learn about how to do forecasting with user-based and statistical methods with Essbase. This session will cover how to create forecasts and allocations using BSO calc scripts, and ASO MDX scripting. This session will cover different…

There are too many Essbase optimization presentations with far too many tips floating around (many tips don't even work in the real world).If you come to this session, you'll hear the 10 optimization tricks that will give you 95% of the improvement to your Essbase cube. Learn how to order your dimensions, set your caches,…

This two-hour, hands-on tutorial shows how executives and BI users can visually create illuminating ad hoc BI queries, and build insightful dashboards natively in Microsoft Excel directly against Oracle Database OLAP Option. We introduce the business value of multi-dimensional OLAP cubes. Then Excel's PivotTables are used to investigate business measures broken down simultaneously by, say,…

This two-hour, hands-on tutorial shows how executives and BI users can visually create illuminating ad hoc BI queries, and build insightful dashboards natively in Microsoft Excel directly against Oracle Database OLAP Option. We introduce the business value of multi-dimensional OLAP cubes. Then Excel's PivotTables are used to investigate business measures broken down simultaneously by, say,…

This session will teach you theapproach to take when migrating your non-Oracle data warehouse to Oracle. If you've optimized a non-Oracle environment over anumber of years and now want to migrate to Oracle database, there are four primaryfocus areas you need to consider. We will review these considerations, and usea customer case-study of one of…

This session will teach you theapproach to take when migrating your non-Oracle data warehouse to Oracle. If you've optimized a non-Oracle environment over anumber of years and now want to migrate to Oracle database, there are four primaryfocus areas you need to consider. We will review these considerations, and usea customer case-study of one of…

How do you find very important needles in haystacks? This presentation and demo will show several use cases of Oracle Data Mining's fraud and anomaly detection capabilities. Oracle Data Mining's (ODM) Anomaly Detection algorithm trains on what is considered ânormalâ and then flags any record(s) that, on a multi-dimensional basis, appear to not fit in.…

In a perfect world (or maybe an 11g world) , your QA database would be an exact clone of production. Unfortunately, most of us live in the real world where cost is always consideration. This can lead to issues with a SQL statement performing well in QA, but sub-optimally in production. There are several ways…

Oracle Forms is a strong and viable product with years of future left. However, Oracle has “bet the farm” on the success of Fusion; Oracle’s rewrite of its Application stack using Java EE and Service-Oriented Architecture. A key tool in this development effort has been the JDeveloper tool and the Oracle Application Development Framework (ADF).…

In a perfect world (or maybe an 11g world) , your QA database would be an exact clone of production. Unfortunately, most of us live in the real world where cost is always consideration. This can lead to issues with a SQL statement performing well in QA, but sub-optimally in production. There are several ways…