Understanding Oracle OLAP Dimensions And Cubes
Understanding Oracle OLAP Dimensions And Cubes is a good introduction by Mark Rittman on how to access the Oracle OLAP features. Lots of code examples that ideally illustrate the how to implement the concepts of dimensions and cubes in an Oracle database.
Bookmark that page! High end Oracle features are considered a bit of a black art because its tough to find good examples, but heres one with it all laid out.
If you are familiar with Analysis Services, you'll notice quickly one of the reasons AS's market share continues to increase, while Oracle's OLAP share continues to decline. The knowledge level to effectively implement an OLAP soultion requires a skill level far, far above that required for Analysis Services (and without any difference in results.)
posted by Duncan @ 9:29 AM
1 comments
links to this post
1 Comments:
Hi Duncan,
One point I would make is that with Oracle 10g (10.1.0.3) and the new version of Analytic Workspace Manager, the process is considerably simpler and with a proper GUI. I'm not allowed to write too much about these new products until they come out in a few weeks time, but you'll be pleasantly suprised as what's coming along.
regards
Mark
Post a Comment
Links to this post:
Create a Link
<< Home