Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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