nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Oracle AI and Analytics

Child Item

Child Item

OTBI Question: comparing columns from two subject areas

Hi All,

I have a question on creating a filter using columns from two subject areas.

For example,

"Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."Effective Start Date" < "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Notified Termination Date"

results in an error.

Is it invalid to compare columns across like this?

Columns in this analysis are taken from these two subject areas and the results are coming fine. Comparison, or calculation between columns though, is an error.

Appreciate help on this.

Here is what the analysis looks like:

Hi All,

I have a question on creating a filter using columns from two subject areas.

For example,

"Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."Effective Start Date" < "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Notified Termination Date"

results in an error.

Is it invalid to compare columns across like this?

Columns in this analysis are taken from these two subject areas and the results are coming fine. Comparison, or calculation between columns though, is an error.

Appreciate help on this.

Here is what the analysis looks like:

Find more posts tagged with

Accepted answers

All comments

I am facing this issue. I have one party name from contracts subject area and party name from payables subject area. When I try to compare party name = party name from each of these subject areas, it fails.

Please let me know if you have were able to resolve this