Technical Incremental refresh of Exalytics Aggregates using TimesTen Introduction One of the key reasons that Exalytics can deliver sub-second response times is the use of TimesTen in-memory database to hold data pre-calculated to various levels of aggregation as required by the reports. Last year I wrote about Alternatives to the Summary Advisor [http://www.rittmanmead.com/blog/2012/
Technical Rittman Mead BI Forum 2013 Call for Papers now Open! I'm pleased to announce that the call for papers for the 5th annual Rittman Mead BI Forum is now open, with abstracts being accepted through to January 31st, 2013. Last year's BI Forum was the biggest and best ever, running in Brighton, UK and Atlanta, GA
Business Insights BIWA 2013 Welcome Reception You may have seen information on our website about the BIWA Summit [http://www.rittmanmead.com/biwa2013/] and how excited we are to be attending. It's great to have a separate BIWA event again, and to help ensure it's success, Rittman Mead has decided to be
ODI 11g in the Enterprise Part 5: ETL Resilience and High-Availability In this final part of our five part series on ODI 11g in the Enterprise, we'll take a look at a topic that's become increasingly important as ODI and ETL becomes more mainstream; data integration and loading routines that were once considered "nice to have&
ODI 11g in the Enterprise Part 4: Build Automation and Devops using the ODI SDK, Groovy and ODI Tools Happy New Year! In this five-part series over the Christmas break, we've been looking at some of the more enterprise-orientated features in Oracle Data Integrator 11g, starting off with its support for multi-dimensional, message-based and big data sources and targets, and yesterday looking at its integration with Oracle
ODI 11g in the Enterprise Part 3: Data Quality and Data Profiling using Oracle EDQ In this special Christmas Break series of postings on Oracle Data Integrator 11g, we've been looking at how ODI has moved beyond being just a relational data movement tool to one that can connect to multi-dimensional databases such as Oracle Essbase, or perform a bulk-data movement role within
Technical ODI11g in the Enterprise Part 2 : Data Integration using Essbase, Messaging, and Big Data Sources and Targets In this five part series over the Christmas break, I'm taking a look at some of the lesser-known features in Oracle Data Integrator 11g, focusing on "enterprise" features such as build automation, scripting, data quality and middleware integration. If you've arrived at this post
Technical ODI11g in the Enterprise Part 1: Beyond Data Warehouse Table Loading Most developers who've used Oracle Data Integrator [http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html] in the past have used it to load data warehouse tables, typically from an Oracle or other relational source into a set of dimensional Oracle target tables. Some source data might
Technical Using OBIEE against Transactional Schemas Part 4: Complex Dimensions You guessed it... more on transactional schemas. For a quick recap, here are the posts to date: Using OBIEE against Transactional Schemas Part 1: Introduction [https://www.rittmanmead.com/blog/2012/06/using-obiee-against-transactional-schemas-part-1-introduction/] Using OBIEE against Transactional Schemas Part 2: Aliases [https://www.rittmanmead.com/blog/2012/08/using-obiee-against-transactional-schemas-part-2-aliases/] Using
Oracle Endeca (2.3) Record Level Security A common task with any BI solution is to implement some type of security whether it be content, or data based. Tools for managing content security in Oracle Endeca Information Discovery are fairly prominent in the Admin pages within Studio, managed through a set of security objects: User Groups, Roles
Technical OEID and RTD Events Just wanted to mention two events we're running in conjunction with Oracle on Thursday 6th December that may be of interest. These events will allow you to learn more about Oracle Endeca Information Discovery (OEID) and Oracle Real-Time Decisions (RTD). Providing a great opportunity to learn how OEID
Technical Update on my OBIEE / Exalytics Books Just a quick update on my two recently published books, "Oracle Business Intelligence Developers Guide" and "Oracle Exalytics Revealed", both of which are now published and available to purchase around the world in printed and electronic format. Here are some links to the two books on
Clustering ODI11g for High-Availability Part 1 : Introduction and Architecture ODI developers have always been able to build and deploy data integration packages code and run them on traditional standalone agents, but with the 11g release of ODI a new type of agent called a “JEE Agent” became available and gave us another option. JEE agents, rather than running in
Technical Using OBIEE against Transactional Schemas Part 3: Simple Dimensions and Facts This could be the longest series of blog posts in Rittman Mead history... not in number of posts (this is only the third), but in length of time from start to finish. I don't think that's a record anyone is actively pursuing, nor am I proud
Technical Oracle ACE Directors Nordic Tour 2012 : Venues and BI Presentations Next week I'm honoured to be taking part in the Oracle ACE Directors Nordic Tour, taking in Copenhagen, Stockholm, Oslo and Helsinki over four days. Organized by Heli Helskyaho (Finnish Oracle Users Group) and Sten Vesterli (Danish Oracle Users Group) along with the leaders of the Norwegian and
ADF View Objects as a Repository Data Source using OBIEE 11.1.1.6 and JDeveloper 11.1.1.6 The Application Development Framework [http://www.oracle.com/technetwork/developer-tools/adf/overview/index.html] (ADF) within Oracle Fusion Middleware 11g provides a data abstraction technology called ADF Business Components [http://docs.oracle.com/cd/E15051_01/web.1111/b31974/bcintro.htm], that provide a Java object later over database SQL
Technical Oracle Exalytics, Oracle R Enterprise and Endeca Part 3 : Flight Delays Analysis using OBIEE, Endeca and Oracle R Enterprise on Exalytics So far in this series we've looked at Oracle's BI, Big Data and Advanced Analytics strategy and seen how Exalytics can benefit both Endeca Information Discovery and Oracle R Enterprise through its 40 CPU cores and 1TB of RAM. For a recap on the two earlier
Technical Oracle Exalytics, Oracle R Enterprise and Endeca Part 2 : Oracle Endeca, the Advanced Analytics Option and Oracle Exalytics In this week of postings we're going to look at Oracle Exalytics and how it enables "big data" and unstructured data analytics, using Oracle Endeca, Oracle Exadata, Oracle Big Data Appliance and the Oracle Database Advanced Analytics option. In case you've arrived via a
Technical Oracle Exalytics, Oracle R Enterprise and Endeca Part 1 : Oracle's Analytics, Engineered Systems, and Big Data Strategy One of the presentations Rittman Mead gave at last week's Oracle Openworld [http://www.rittmanmead.com/openworld2012/] was entitled "High Speed, Big Data Analysis using Oracle Exalytics" [http://www.rittmanmead.com/files/oow2012_rittman_exalytics_big_data.pdf][PDF]. Although it was the last of my
Technical Oracle BI Developers Guide, and Oracle Exalytics Revealed, Now Available to Buy! After what has been around five years of development, including two years of waiting for OBIEE11g and then three of desperately keeping up with 11g point releases, the Oracle Business Intelligence Developers Guide [http://www.mcgraw-hill.co.uk/html/0071798749.html] has now been published by Oracle Press / McGraw Hill
Technical BI, Data Warehousing and Data Integration News from Oracle Openworld 2012 This week is Oracle Openworld week in San Francisco, USA [http://www.oracle.com/openworld], with around 50,000 attendees attending Openworld itself, Java One and fringe events such as Oaktable world. Rittman Mead have had ten sessions during the week, covering topics such as OBIEE, Endeca, data warehousing, Essbase
Technical OOW2012 so far... It's now half way through Oracle Open World 2012 [http://www.oracle.com/openworld/index.html] and I thought I would write up a brief update of what has happened so far. Last year saw the announcements of both Exalytics [http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/
Technical Alternatives to the Summary Advisor for Refreshing Exalytics Aggregates One of the several elements of Exalytics' power comes from it holding pre-calculated (aggregated) data in the TimesTen for Exalytics In-Memory Database. Exalytics comes with a tool called the Summary Advisor (which Mark Rittman has written about previously here) [https://www.rittmanmead.com/blog/2012/03/oracle-exalytics-week-the-summary-advisor/] which suggests
Oracle Trusted Partitions for Oracle Engineered Systems, Oracle Exalytics and Updated BI Foundation Pricing Some interesting news from Oracle around Oracle Exalytics In-Memory Machine [http://rittmanmead.com/exalytics], virtualisation and licensing. An updated version of Oracle's Partitioning Policy document has recently been released which includes a new section called "Oracle Trusted Partitions for Oracle Engineered Systems" [pdf [http://www.oracle.
Oracle BI EE Management Pack Now Available for Oracle Enterprise Manager 12cR2 Ever since I wrote the an article on Oracle Enterprise Manager 10g's BI Management Pack [http://www.oracle.com/technetwork/articles/rittman-oem-bipack-087508.html], people have asked me when equivalent functionality would be available for OBIEE 11g. With the release of Oracle Enterprise Manager 12c Release 2 [http://www.
