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

    Maybe silly but do not know

    dileraco

      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?

       

      Regards,

      Dilek