Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 31, 2013 4:02 AM by
two date column in a table
Jan 31, 2013 3:38 AM
I have a Sales Data warehouse of Retail shops which operate 24x 7 with 2 shifts of 12 hours each. Time for each shift is 7 to 7.
I have a Calendar Dimension which has all the dates listed.
I have a Sales table which has two dates columns: one is the Sales Date whereas another one is the shift date. So there are two joins (Foreign keys) from Sales Table to the Calendar Table.
I need to develop an analysis on these tables where the Area managers look at the sales by day, month and year and Shift Supervisor and Shift Managers want to look at sales by shifts. (Shift Date).
When I define two joins in OBIEE Administrator, it say that I can have a single join from one dimension. (From Calendar Dimenstion to Sales). this way I can report only by Sales Date.
How can I report by Shift Date?
This content has been marked as final.
Show 1 reply
Re: two date column in a table
Jan 31, 2013 4:02 AM
in response to
Create 2 date dimensions: one for calendar date, one for shift date.