O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating the multidimensional Business Model

Creating a Business Model for cubes is easier than RDBMS tables. Actually, the structure of cubes is very similar to the Business Models. Cubes contain dimensions and measures. We can see that structure in the Physical layer as well.

Dimensions and their levels are already created in the cubes. Measures are also specified in the cubes. So all required object definitions already exist in the cubes.

How to do it...

  1. First step will be creating a blank Business Model in the BMM layer. Then we're just going to drag-and-drop a cube from the Physical layer onto the new Business Model. At this step, all logical dimensions and fact tables will be created automatically, plus dimensions and their hierarchies are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required