Jeff McQuigg, KPI Partners Inc, "Performance Tuning the BI Apps with a Performance Layer"
The BI Apps from Oracle present customers with a nice head start to getting their BI environment up and running. But for many customers they just are too slow for their user community while running dashboards, reports and ad-hoc queries. Learn about some of the key techniques you can use to take the BI Apps to performance levels you didn’t think were possible.
The discussion begins with a conceptual understanding of why performance problems can exist and the counteracting design considerations. Special attention will be paid to the concept of a Performance Layer, describing what it is, what it is comprised of and how to build it. The presentation includes several real world examples of the significant performance gains that can be had from a Performance Layer.
Venkatakrishnan J, Rittman Mead, "In Memory Analytics - Times Ten, Essbase 126.96.36.199 - Analysis - A Comparison"
This session details how Oracle’s various in-memory offerings in the analytics space work. In particular, it covers how Oracle TimesTen In-Memory Database works and compares it with in-memory Oracle Essbase 188.8.131.52. The session includes live demonstrations of how the memory is utilized by both of the products and shows the advantages of using in-memory analytics over conventional storage-based analytics.
Rene Kuipers, VX Company, "It's all in the genes - The power of Oracle Exadata and the Oracle Database"
In genetic cancer-research, huge amounts of data are needed to do proper analyses. My presentation will cover the data model we developed to store these data, as well as the database options and Exadata-features that are involved in managing these high volumes and the effect they have on query-response times. Good database design is of the essence in a well-performing BI landscape. I will also show the extension built to this database; a 3D cinema that uses the database to visualize the effect of genetic defects on organs.
Jeremy Harms, CD Group, "A BI Publisher Beginner's MacGyver-Hack for Financial Reporting with OBIEE"
For organizations with a mandate to support ALL reporting needs directly within OBIEE, financial reporting can be very difficult (or nearly impossible) depending on your financial statement layouts and/or specification complexity. If you don’t have Hyperion tools such as Hyperion Financial Reporting (HFR) or Essbase that come included in Oracle Business Intelligence Foundation Suite (OBIFS), then you need a different approach to generating financial reports in Oracle BI.
I've spent years as a BI consultant pulling my hair out and multiple ugly attempts trying to generate Profit and Loss (or P&L, Income Statement) reports directly within OBIEE. After hearing Charles Elliott’s TED style talk on report prototyping with BI Publisher at the RM Forum last year, I finally bit the bullet and learned how to try and leverage BI Publisher with OBIEE to help generate these financial layout reports.
OBIEE alone has FAR too many (and painful!) limitations to be a real "financial report writer;" and it lacks many of the required formatting options that would just be assumed of such a tool. As a newbie to BI Publisher, I found that tool alone too cumbersome and complicated to generate the needed data set outputs and calculations. So, I eventually settled in on a best-of-both-worlds MacGyver-hack approach using the two: OBIEE 11g to easily generate the raw P&L data sets and calculations, and BI Publisher to more easily format the required layout.
Leveraging OBIEE for the data set generation and BI Publisher for layout creation, you can -- with at least with a little more sanity, hopefully -- create these types of financial statements and keep everything within the OBIEE umbrella.
Adam Seed, Rittman Mead, "Endeca - Looking beyond the general demos"
Endeca, Bitsa this, bitsa that. Put 'em all together and what have you got?
This presentation will look at key enterprise elements found in many BI applications. It is my findings that most Endeca presentations look at how cool it is, but after all the rehearsals are over and time comes to do the real performance, what is there in Endeca to support the enterprise requirements of the common BI application?
This presentation will look at:
• Methods of adding robustness to the ETL process
• Problems faced with large data sets
• Using Steams of data from datasift
• Using Databases with other data sources
• Endeca Security including Row level security
• Scheduling the ETL process with email notification
• Looking at moving content between environments
Lali Chatterjee, Deloitte Consulting, "Finance Transformation: Insight-driven Business Process Optimization via Integrated Business Intelligence"
This presentation will:
1) include the foundation for the need to integrate HFM and OBI
2) evaluate possible integration options
3) provide a technical overview of the custom integration approach highlighting implementation challenges and tool behavior anomalies
4) summarize the lessons learnt and technical considerations
The target audience for this presentation are Delivery Managers, Solution Architects and Practitioners who are familiar with OBI and have basic BI implementation experience.