Looking up a table while doing data load is a common scenario in SAP BW.
Here the look up table can be active table of some other DSO.
You can note a point here that cube cannot be used for look up. This is because, a cube has a fact table which is based on star schema. Hence the primary keys in a fact table will be dimension ids instead of the primary key values.
Now coming to our scenario, suppose data is loaded from DSO1 to CUBE1. Continue reading →