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