2 Replies Latest reply on Jan 14, 2015 8:25 AM by dileraco

    Maybe silly but do not know


      Hello everybody,


      I want to learn something about OBIEE modeling. (I have little experience on it) One of our fact table contains 'PERIOD' column (eg: 201401) and want to join it to 'Time Dimension' table. However, it does not contain 'PERIOD' as a column. I can create a logical column by YEAR || MONTH via this table.


      So, my question is;


      Can I join these two tables by using this logical column :S That is;


      my_fact.period = time_dim.period   (this is logical col)


      Or, I have to add physical PERIOD column to my time dimension table?