Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence Idea Lab

Ability for joins beyond inner for excel data set to SQL data set

Submitted

Views

Comments

MLawrence Rank 1 - Community Starter

Oct 8, 2020 4:06PM edited May 8, 2025 10:26PM in Oracle Transactional Business Intelligence Idea Lab

Organization Name

University of Kansas

Description

Reporting users are finding the limited ability for inner joins only from the UI when creating a link between imported excel file data set and SQL data set to be problematic.

Use Case and Business Need

Outer join for excel to SQL data models.

More details

Records are dropped.

Original Idea Number: 7072d4037e

Excel to SQL join example.png

1 votes