The business model now looks like this. To use the BMM lookups, lets create a new logical table in the BMM layer to hold the exchange rates table as shown below To denote a table as a BMM lookup table, we need to enable the lookup option if you notice, there is no more bridge table check box option like in 10g but just a lookup option When we enable a logical table as a lookup table, that means that this logical table does not require any BMM joins to either the fact or the dimension. By continuing to use this website, you agree to their use. Gathering Statistics should remove row chaining. If there is more than one column acting as a primary key, ensure that the key contains all the columns.
nest...