3 Replies Latest reply: Aug 30, 2013 10:44 AM by mjmoore52 RSS

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

    mjmoore52

      Hello,

       

      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.