Oracle Transactional Business Intelligence

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

How to join two different tables PVO's in oracle BICC based on primary key connection?

Received Response
193
Views
2
Comments

How to join two different tables PVO's in oracle BICC based on primary key connection?

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Sep 17, 2024 8:34AM

    Hi, You must extract each view object to CSV then join them post extract using whatever you are doing with the data outside of oracle. Or you need a custom view object in the first place to replace the 2 pre-defined view objects.

  • PrasadN
    PrasadN Rank 1 - Community Starter

    thanks. Is there a way to have the join directly on offering creation ? When you say Custom View Object, what it is ?