Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maybe silly but do not know

dilekJan 14 2015 — edited Jan 14 2015

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
This post has been answered by FTisiot on Jan 14 2015
Jump to Answer

Comments

jflack
You might want to ask this in the ApEx forum - 3139 This is the ApEx Listener forum.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 11 2015
Added on Jan 14 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
584 views