*** Moved from Tue to Mon because of the big race ****
OLAP, what is it good for?
Richard will show the insides (and outsides) of an OLAP cube created to assist in monitoring and managing a 6 node Oracle RAC database that sustains 600 transactions per second from 30,000 online users. Richard will go through the early prototypes, development cycle and design considerations for the cube, which has 12 measure groups, dozens of measures, and dozens of hierarchies. The demonstration will also look into the transformation package that incrementally loads the cube, Excel access and the RS reports available to the masses. This cube is an effective demonstration of the value in having complex data in a cube. All the data in the cube is available to guru DBAs from base tables. But without the cube, getting this information is time consuming and error prone.
Richard is a well known Microsoft expert in the large database and business intelligence fields. He is the author of ThinSlicer, the first publicly available thin client cube browser, which is used by companies around the world. For more about Richard goto http://RichardLees.com.au
Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney
5:30pm Dinner - Session 6pm until 8pm
Monday, 6 November 2006