Joins between two date dimensions

Claudia Ogrezeanu-Oracle

Hi all,

I have one file which contains the following:

Open order month// Open orders

Jan 2021 // 400

Feb 2024 // 100

Another one for closed orders:

Closed order month// Closed orders

Jan 2021 // 100

I am trying to get the following output:

Month // Open // Closed

Jan 2021 // 400 // 100

Feb 2024 // 100 // 0

I tried creating duplicate files, as the data was in one table only, and used full outer join - it does not work properly.

What other suggestions do you have?

Regards,

C

Gianni Ceresa

Isn't this the exact same thing as your other thread? (despite you deleting the content of the question…)

https://community.oracle.com/products/oracleanalytics/discussion/21738/join-between-two-date-columns-from-separate-tables

I assume your "orders" are just like the SRs you were trying to analyze in the other thread. Or how is this one different? (Because you marked the other one as answered.)