Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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:
Answers
-
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
0