Paper accepted at Open World 2007

I am delighted to be able to let you know that I have had a Discoverer paper accepted for Oracle Open World 2007. I will be presenting my famous Build an EUL in one hour paper. Perhaps you have already seen it? Perhaps you have heard of it and would like to see for yourself?

Either way, this will be a live demonstration, using the Discoverer 10.1.2 Administration tool of how to create a fully working End User Layer inside one hour. You will be shown all of the steps involved in creating a fully working Oracle Discoverer EUL. If you have a copy of the Oracle Discoverer 10g Handbook, this presentation will take you through all of the steps required to build the tutorial database.

I will start by selecting the schema owner and tables required. Using the Load Wizard, you will be walked through all of the steps involved in loading the meta data definitions from the source database. Sticking close to the wizard's defaults, you will see how Discoverer automatically builds joins and lists of values.

After I have the base folders loaded, now the fun stuff begins. You will now be shown how to add some new items, in particular we will add new columns for calculating standard margin and mark up, as well as for profit and profit percentage. We do this so that the end users do not need to build these for themselves.

Next, you will be shown how to build complex folders out of the simple folders that we have just created. We will create fiscal date folders, linking these back to the sales order folder. After creating these new folders, you will be shown how to create fiscal date hierarchies so that users can drill from day, to fiscal month, fiscal quarter and so on.

After you have been shown how to build complex data folders, you will be shown how to build a geographic rollup. This rollup will allow the users to drill from City to District to Region.
After building the complex folders for fiscal date and geography, we will have created a psudo star schema with the our sales folder at the center.

The presentation will conclude with a walk through of some of the most often used features of Discoverer's Administrator edition. As I have said many times, you are only limited by your own imagination when it comes to working with Discoverer.

If you're going to be in San Francisco in November come and join me and say hello.