This discussion is archived
3 Replies Latest reply: Aug 30, 2013 8:44 AM by mjmoore52 RSS

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

mjmoore52 Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points