This two-hour, hands-on tutorial shows how executives and BI users can solve business problems by visually create illuminating ad hoc BI queries, and build insightful dashboards in Microsoft Excel directly against Oracle Database OLAP Option. We introduce the business value of multi-dimensional OLAP cubes. Put yourself in the shoes of a BI Analyst when you…

Fix on sparse, if on dense; hourglass vs. hourglass on a stick. Just when you thought you had all of the Essbase design best practices down, here comes Tracy McMullen, Oracle Ace Director, with some exceptions to the general Essbase rules. Join us for this unique twist on an Essbase tips and tricks presentation where…

Some people want to optimize their Essbase cubes or Planning applications for calculation performance.  Others want to reduce the speed of data loading, improve the performance of retrievals, or make their Planning forms blazingly fast.  The best place to start no matter what you're optimizing is the common factor across all of these: the Essbase…

Fix on sparse, if on dense; hourglass vs. hourglass on a stick. Just when you thought you had all of the Essbase design best practices down, here comes Tracy McMullen, Oracle Ace Director, with some exceptions to the general Essbase rules. Join us for this unique twist on an Essbase tips and tricks presentation where…

Gallup Inc. reports data collected from surveys using OBIEE11g as one of the reporting platforms. This lecture talks about the customization aspects of OBIEE11g and also the performance characteristics of our implementation.

Some people want to optimize their Essbase cubes or Planning applications for calculation performance.  Others want to reduce the speed of data loading, improve the performance of retrievals, or make their Planning forms blazingly fast.  The best place to start no matter what you're optimizing is the common factor across all of these: the Essbase…

A common hurdle for new OBIEE environments is the seeming lack of support for transactional schemas as physical sources. Data structures are presented to Analysis developers as dimensions and facts, so a common misunderstanding is that the physical model must be a star schema. This presentation will examine common techniques for modeling transactional schemas as…

OBIEE 11g Balanced Scorecard is a Key Performance Indicator (KPI) based analytic application which generates Balanced Scorecards and other functionality that makes KPI analytics valuable, visible across the organization, and increasingly actionable closer to real time. How does it work? The logical split as well as its reflection in the underlying metadata is twofold: KPI…

A common hurdle for new OBIEE environments is the seeming lack of support for transactional schemas as physical sources. Data structures are presented to Analysis developers as dimensions and facts, so a common misunderstanding is that the physical model must be a star schema. This presentation will examine common techniques for modeling transactional schemas as…

Learn from our team of experienced consultants ODI Tips and Tricks in this Hands on lab. We will cover everything from proper setup to clearing log files to automating ODI.