Now it’s time to actually start creating objects in the Warehouse Builder for our target structure. In the previous topic, we decided what our cube and dimensions were going to be in our logical design and now we are at the point where we can implement that design in OWB. We’ll create the objects using the wizards that the Warehouse Builder provides for us to simplify the task of building cubes and dimensions. We’ll look at the data object editors in a little more detail than we saw in topic 2. Let’s begin with creating the dimensions. We’ll cover the following list of topics in this topic:
• Creating dimensions in OWB
° The Time dimension and wizard ° The Product dimension ° The Store dimension
• Creating a cube in OWB
° Creating a cube with the wizard
