I have a date dimension table in the physical layer. From that I need to create 2 date dimension tables in the BMM layer. One is for order date and the other is for shipped date. There is a ship_date_key and an order_date_key in my fact table that I'm trying to use as my foreign key. Seems I can create a joined ship date logical table or a joined order date logical table but not both.
Very new to OBI Admin tool. Any help would be greatly appreciated.
If you create only one alias from Date dimension in Physical Layer then you can get only one data either Ship Date or Order date details.
The data from Date dimension gets retrieved on the basis of the Join i.e on which key it was joined to the Fact.
To solve the above ambiguity you should create two separate alias tables in physical layer, hence you will have two logical tables in BMM Layer
Create Dim_Ship_Date and Dim_Order_Date from Date dimension.
And now, you can join the fact with these two aliases on different keys. This practice is usually followed.
If found useful mark the answer