Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Comparing to a string value in a physical join

Received Response
1
Views
1
Comments
Adam Wickes
Adam Wickes Rank 6 - Analytics Lead
in Oracle Business Intelligence Applications

Hi all,

Seems like a fairly simple one but getting some issues with a join in my physical layer.
Basically I want to join two tables together using the primary key but I want to also add that I want to see only active records using our active flag.
So for example, the join would look like:

a.key = b.key AND
a.active = 'Y' AND

b.active = 'Y'

This throws up the following error:

[nQSError:30001] Only columns, designated predicates and operators are allowed.


Interestingly, if I reverse the relationship of the join so it goes from being "one to many" to "many to one", it doesn't error, although this is obviously not an option going forward.

I have read that complex joins are not allowed in the Physical layer but not sure why that would be.


Cheers,
Adam

Answers

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    I think i've answered my own question.
    The above error occurs when I try and edit an already existing join which has been defined as a "physical foreign key join".
    If I delete the existing join and create a new one, adding in the comparison to the string value, the join is saved as a "complex join" and everything is hunky dorey.

    Apologies for wasting people's times but hopefully this can help others in the future.

    Cheers,

    Adam