List of joins — Oracle Analytics

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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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