The latest Oracle OLAP newsletter, February 2009, has been posted onto OTN and is available by clicking here
The customer feature this time is R.L. Polk who have used 11g OLAP to simplify their delivery of aggregate data through the use of cube organised materialised views. This is a fantastic case study which captures the true value of this functionality (note the dramatic improvements in both build and query times), and of having Oracle OLAP embedded in the Oracle Database.
The highlights of the Product Update section this time are the release of the latest version of AWM 11g (11.1.0.7B), and also a new version of the BI Spreadsheet Add-in (10.1.2.3.0.1 - enough digits?!) which now includes support for Excel 2007.
Showing posts with label Customer References. Show all posts
Showing posts with label Customer References. Show all posts
Thursday, February 5, 2009
Wednesday, January 7, 2009
Get hands-on with 11g OLAP & Oracle Business Intelligence Enterprise Edition
Happy New Year to everyone!!
Following the announcement last month of two new 'Oracle By Example' tutorials on building and querying 11g OLAP cubes, here are the details of a further two tutorials on working with 11g OLAP and Oracle Business Intelligence Enterprise Edition (OBIEE).
The first tutorial shows how to create OBIEE metadata over 11g OLAP cubes
(if you are using 10g OLAP, use this tutorial to create OBIEE metadata instead)
The second new tutorial shows how to query 11g OLAP cubes using OBIEE Answers - using the metadata repository created during the first tutorial
While OBIEE Answers is a widely used query tool for Oracle OLAP (for an example, see the article on Micros Systems), it would be interesting to hear from people using some of the other components of OBIEE, especially some of the newly integrated 'plus' components like Smart View which appears to be receiving a lot of development effort from the BI/EPM folks.
Please feel free to share any experiences you might have in our comments section.
Following the announcement last month of two new 'Oracle By Example' tutorials on building and querying 11g OLAP cubes, here are the details of a further two tutorials on working with 11g OLAP and Oracle Business Intelligence Enterprise Edition (OBIEE).
The first tutorial shows how to create OBIEE metadata over 11g OLAP cubes
(if you are using 10g OLAP, use this tutorial to create OBIEE metadata instead)
The second new tutorial shows how to query 11g OLAP cubes using OBIEE Answers - using the metadata repository created during the first tutorial
While OBIEE Answers is a widely used query tool for Oracle OLAP (for an example, see the article on Micros Systems), it would be interesting to hear from people using some of the other components of OBIEE, especially some of the newly integrated 'plus' components like Smart View which appears to be receiving a lot of development effort from the BI/EPM folks.
Please feel free to share any experiences you might have in our comments section.
Tuesday, December 23, 2008
Oracle OLAP Newsletter - December 2008
The latest Oracle OLAP newsletter, December 2008, has been posted to the OLAP Home Page on OTN and is available by clicking here.
As usual, it contains very useful information about what is happening in the world of Oracle OLAP and includes regular features such as the OLAP skills corner and DBA tips, as well as useful links for those wanting to download the software or get training or assistance.
The featured customer this time is JD Sports in the UK. This is an excellent example of Oracle OLAP being used as part of a wider Data Warehouse solution. It is also a significant endorsement of Oracle's Data Warehouse strategy to bring smart, embedded analytics to the data and highlights the benefits of an embedded OLAP server; JD Sports has been able to leverage other advanced Oracle technologies such as Real Application Clusters (to deliver scalability and availability), whilst additionally benefiting from many of the features taken for granted by Oracle's RDBMS customers (DW integrated security, storage, backup, transaction control, etc) but often not so easily delivered by stand-alone OLAP engines.
This customer feature is also a good example of the scalability of the Oracle OLAP engine itself. Whilst far from being the largest implementation (there are customers managing several Terabytes of data in Oracle OLAP cubes), this example shows how relatively large volumes of DW data can be loaded and aggregated in Oracle OLAP, and how the cube compression and partitioning features first introduced in 10g OLAP have completely changed the game compared to what was previously possible. Taken in isolation, loading 300 million source records is not a major achievement (not for Oracle OLAP anyway), neither is having a 10 dimensional cube, or indeed is aggregating across 28 hierarchical levels. What is more impressive is doing all of these three things combined in a single cube (which is only one cube out of a total of six), and still being able to deliver all of the key benefits you would associate with an well implemented OLAP system - fast query performance and lots of advanced calcs (literally 100's in this case) serving a reasonably sized user community.
All things considered, it is easy to see why Oracle OLAP is a key, strategic component of the Oracle Data Warehouse platform.
Let's hope for some more customer features in the near future.
Greetings of the season to everyone!
BTW - you can have the OLAP newsletter sent directly to your email box each quarter by following the link at the top of the current newsletter (Unsubscribe/Subscribe to this Newsletter)
As usual, it contains very useful information about what is happening in the world of Oracle OLAP and includes regular features such as the OLAP skills corner and DBA tips, as well as useful links for those wanting to download the software or get training or assistance.
The featured customer this time is JD Sports in the UK. This is an excellent example of Oracle OLAP being used as part of a wider Data Warehouse solution. It is also a significant endorsement of Oracle's Data Warehouse strategy to bring smart, embedded analytics to the data and highlights the benefits of an embedded OLAP server; JD Sports has been able to leverage other advanced Oracle technologies such as Real Application Clusters (to deliver scalability and availability), whilst additionally benefiting from many of the features taken for granted by Oracle's RDBMS customers (DW integrated security, storage, backup, transaction control, etc) but often not so easily delivered by stand-alone OLAP engines.
This customer feature is also a good example of the scalability of the Oracle OLAP engine itself. Whilst far from being the largest implementation (there are customers managing several Terabytes of data in Oracle OLAP cubes), this example shows how relatively large volumes of DW data can be loaded and aggregated in Oracle OLAP, and how the cube compression and partitioning features first introduced in 10g OLAP have completely changed the game compared to what was previously possible. Taken in isolation, loading 300 million source records is not a major achievement (not for Oracle OLAP anyway), neither is having a 10 dimensional cube, or indeed is aggregating across 28 hierarchical levels. What is more impressive is doing all of these three things combined in a single cube (which is only one cube out of a total of six), and still being able to deliver all of the key benefits you would associate with an well implemented OLAP system - fast query performance and lots of advanced calcs (literally 100's in this case) serving a reasonably sized user community.
All things considered, it is easy to see why Oracle OLAP is a key, strategic component of the Oracle Data Warehouse platform.
Let's hope for some more customer features in the near future.
Greetings of the season to everyone!
BTW - you can have the OLAP newsletter sent directly to your email box each quarter by following the link at the top of the current newsletter (Unsubscribe/Subscribe to this Newsletter)
Tuesday, December 16, 2008
ComputerWeekly.com : E.on transforms financial insight with Oracle OLAP Option
http://www.computerweekly.com/Articles/2008/12/11/233863/e.on+transforms+financial+insights+with+bare-knuckle.htm
The article above, published last week in ComputerWeekly, follows an earlier customer profile posted on OTN. E.on, one of Europe's leading energy suppliers, has gone live with a financial transformation software project that will give it an accurate view of the profits generated by each customer and provide better forecasting of future demand. E.on has accounts with over eight million customers in the UK. To quote directly from the project leader Lawrence Edwards: "It (accurate forecasting of demand, and, therefore, margin) is a massive problem because of the data volumes and complexity. Others have tried and failed, but we persevered."
It provides excellent proof points for the use of Oracle OLAP to solve business problems that require rapid data loading and analysis of large data volumes. The E.on system is currently operating at about 6Tb and is growing rapidly, with 150Gb of new data added every 14 hours. There is a great quote from Lawrence in the OTN PDF explaining what they have achieved using Oracle OLAP Option:
"The analytical power, centralized administration, and scalability of Oracle OLAP have allowed us to process and present data in a way that was not previously possible. This has provided us with an unprecedented depth of understanding of customers’ energy use and the demand for all our products and offerings"
The article above, published last week in ComputerWeekly, follows an earlier customer profile posted on OTN. E.on, one of Europe's leading energy suppliers, has gone live with a financial transformation software project that will give it an accurate view of the profits generated by each customer and provide better forecasting of future demand. E.on has accounts with over eight million customers in the UK. To quote directly from the project leader Lawrence Edwards: "It (accurate forecasting of demand, and, therefore, margin) is a massive problem because of the data volumes and complexity. Others have tried and failed, but we persevered."
It provides excellent proof points for the use of Oracle OLAP to solve business problems that require rapid data loading and analysis of large data volumes. The E.on system is currently operating at about 6Tb and is growing rapidly, with 150Gb of new data added every 14 hours. There is a great quote from Lawrence in the OTN PDF explaining what they have achieved using Oracle OLAP Option:
"The analytical power, centralized administration, and scalability of Oracle OLAP have allowed us to process and present data in a way that was not previously possible. This has provided us with an unprecedented depth of understanding of customers’ energy use and the demand for all our products and offerings"
Monday, September 29, 2008
Oracle OLAP Newsletter - September 2008
The latest edition of the excellent Oracle OLAP Newsletter has just been released here
Highlights this time include a customer feature on Oss Council in the Netherlands who use Oracle OLAP for management reporting, details of the new 11.1.0.7 release, and a guide to delivering summary management through cube materialized views.
Highlights this time include a customer feature on Oss Council in the Netherlands who use Oracle OLAP for management reporting, details of the new 11.1.0.7 release, and a guide to delivering summary management through cube materialized views.
Subscribe to:
Posts (Atom)
