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 Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

List of joins

Received Response

11

Views

2

Comments

986359

986359 Rank 4 - Community Specialist

Sep 16, 2016 3:05AM edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

Hi All,

How do I get the list of joins used in RPD. I need the dimesnions, fact and join condition.

TIA,

LonaD

0

Answers

rmoff Rank 6 - Analytics Lead

Sep 16, 2016 4:12AM

Have a look at the Administration tool's Query functionality: https://docs.oracle.com/middleware/1221/biee/BIEMG/mngreposfiles.htm#BIEMG643

You can use the Columns... option to add/remove columns from the view, including the table names and join condition.

0
plyskovich Rank 3 - Community Apprentice

Sep 19, 2016 3:23AM

Hi,

Perhaps, you need obiee data dictionary

0