3 Replies Latest reply on Aug 30, 2013 3:44 PM by mjmoore52

    Oracle 11 RPD: Create 2 Logical Tables Based on 1 Physical Table




      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.