OTBI Question: comparing columns from two subject areas

User618255-OC

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:

ShitalRamteke

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