Technical Aggregate Navigation using Oracle BI Server In this example I'm going to show you how to create an aggregate table, register it with the Oracle BI Server, and have Oracle Answers and Dashboard use it to speed up queries. Oracle BI server lets you register aggregate (summary) tables that contain the precomputed sums, averages
Technical Oracle BI & SOA - Hype or Here Now? I mentioned in my posting yesterday [http://www.rittman.net/2006/10/29/back-home-and-reflections-on-open-world/] that, whilst at Open World last week, I was struck by the many conversations I had with people around Oracle business intelligence and Service Orientated Architectures (generally shortened to SOA
Technical Partitioned tables and statistics Elsewhere [http://www.dizwell.com/prod/node/322] a question popped up relating to binds on partition keys. David Aldridge ran some tests (also posted here [http://oraclesponge.wordpress.com/2006/10/28/partition-pruning-and-bind-variables/] ) that indicated that binds would use global table stats rather than partition
Technical Back Home, and Reflections on Open World Well I'm back in the UK now, and I've had yesterday and this morning to myself before the family gets back from Ireland. We're all back at work tomorrow (well school and nursery for the kids, we haven't got them working as
New Jonathan Lewis Blog I just happened to check out the dashboard on my wordpress installation and noticed a trackback [http://jonathanlewis.wordpress.com/2006/10/29/virtual-columns-11g/] from Jonathan Lewis' new blog [http://jonathanlewis.wordpress.com/]. I bumped into Jonathan in the lobby of the King George last week and
Oracle Open World Day 5 - Discoverer Futures, and Wrap-Up Yesterday was the Business Intelligence CAB meeting, which consisted of a number of presentations to BI customers and partners on Oracle's ongoing product direction. As it's all under an NDA I can't go in to most of it, but one presentation that I can
Oracle Open World Day 4 - 11g Performance & Scalability Features An early night for me for once, as I'm back now from the Oracle Press event and catching up with the last few presentations of the day. In the end I went to the Server Technology Beta Program event, then the Oracle Press event, and I got a
Oracle Open World Day 4 - Oracle BI EE 10.1.3.2 New Features I've just come out of the "What's New with Oracle Business Intelligence 10.1.3.2" presentation by David Granholm, and there's a bunch of new details on what's coming up with this new release. I should say that, as
Oracle Open World Day 3 - Blogger Meetup Tonight was the night that we organized our second annual Oracle Open World blogger meetup, this time at the Thirsty Bear bar next door to the Moscone. For a variety of reasons I've ended up in the Thirsty Bear every night since I've been here (and
Oracle Open World Day 3 - BI Suite EE & BI Publisher I woke up this morning with the mother of all hangovers after spending the evening in an Irish Bar [http://www.flickr.com/photos/markrittman/278528765/] around the corner from the Moscone, but at least my bag was still with me with my laptop still in it. Compared to leaving
Oracle Open World Day 2 Cont. - Oracle BI SE & EE Roadmaps This afternoon I firstly went along to Kurt Wolff's "Oracle BI Suite Enterprise Edition Tips & Tricks" presentation, followed afterwards by Paul Rodwick's "Oracle BI Roadmap" session. Kurt is one of the original nQuire guys and has worked with what is now
Reminder - Oracle OOW2K6 Blogger Meetup Just a short reminder that we're holding an Oracle Blogger meetup at the Thirsty Bear bar and restaurant, from 7.00pm onwards on Tuesday, October 24th. If you've got an Oracle blog, please feel free to come along, we'll be there from 7.00pm
Oracle Open World Day 2 Cont. - Oracle BI SE & EE Roadmaps This afternoon I firstly went along to Kurt Wolff's "Oracle BI Suite Enterprise Edition Tips & Tricks" presentation, followed afterwards by Paul Rodwick's "Oracle BI Roadmap" session. Kurt is one of the original nQuire guys and has worked with what is now
Keeping on top of news With a lot of the Oracle focused Blogdom away at OOW, and various pictures of people [http://flickr.com/photos/markrittman/277028156/in/set-72157594340309513/] that should know better than be seen with empty glasses in hand it seems to be a minority of us stick-at-home types keeping
Technical Oracle Open World Days 1,2 - Database Roadmaps I'm sitting now in the Speaker Ready-room down in the Moscone South mezzanine, in between sessions on Oracle Database 11g and the BI Suite Enteprise Edition & Standard Edition presentations later this afternoon. The morning started off with the Chuck Rozwat keynote on Oracle's database
Oracle Open World Day 0 - Arrivals and Meetups Yesterday was arrivals day at Oracle Open World, with my flight getting in around 1pm and arrival at the King George Hotel around an hour later. Although I said to myself two years ago that I'd never stay in the King George again (I remember having to phone
Getting MOLAP Storage Working with OWB10gR2 Even though the new release of Oracle Warehouse Builder has support for the creation of Analytic Workspaces, up until recently I've still been using Analytic Workspace Manager to create them, as it's the tool I'm familiar with and it gets the job done with
Quick reporting wins One of the risks of presenting a reporting tool to IT professionals is that they go for the geek-factor; the sort of "wow, that's clever" type of reporting that in reality business users would never use because: * It does not contain information the business can
Blogger Meetup - UKOUG Conference, Tuesday November 14th If you're at the UKOUG Conference in Birmingham next month, and you're one of the Oracle bloggers, we're organizing a meetup on Tuesday, November 14th from around 8pm. The venue will be All Bar One, in the Brindley complex next to the ICC; this
OT : Tom Baker Sings “How Soon Is Now” OK, so you probably have to be British to get this, and over 30. BT some time ago launched a service [http://www.engadget.com/2006/01/31/let-dr-who-read-your-text-messages/] where you can send an SMS message to a regular BT landline, and the message
Next Stop, Bratislava I'm over in Bratislava, Slovakia this evening in preparation for the next leg of my BI Seminar tour. My luck with regards to hotels seems to have run out, as rather than being in the local Radisson SAS I'm actually in the Hotel Ibis, which is
Technical New BI-Related Papers and Downloads On OTN I noticed the other day that a number of new BI-related papers and downloads have gone up recently on OTN. "New Features and Performance Enhancements in Oracle OLAP 10g Release 2" [http://www.oracle.com/technology/products/bi/olap/OLAP_10gR2_New%20Features.pdf] goes into a
Oracle Open World Blogger Meetup - Attendee List Lock up your daughters - the Oracle Openworld blogger meetup is scheduled for Tuesday, October 24th at 7.00pm at the Thirsty Bear Brewing Company [http://www.rittman.net/2006/09/18/oow2006-blogger-meetup-tuesday-24th-october-thirsty-bear-brewing-company-7pm/] , 611 Howard Street, San Francisco. Here's
Oracle OLAP 10gR2 Incremental Load Improvements : The Mystery Solved… Right, I've been meaning to post this to the blog for a couple of weeks now but I keep getting sidetracked. If you followed the debate around my Incremental Load Improvements in Oracle OLAP 10gR2 [http://www.rittman.net/archives/001336.html] posting a couple of months ago
Technical Marketing, spin and substance? One of the functions of marketing is to promote a company's services or products. Traditionally this is achieved by talking up the good points of the promoted item, ignoring the bad points and maybe talking down the opposition. What marketing departments are bad about is emphasising the positives
