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?