I am relatively new to obiee and wanted to know if the below mentioned query is possible
I wanted to Know if it is possible to compare values between two analysis.
For eg if i have an report which conatins columns a,b,c,d.
and if i have another analysis which contains columns a,b,e,f
Now if i want to display only those rows in Analysis2 where value matches with the values of a in anaysis1(report1).
Any help in this would be really appreciated.
Many thanks in advance.
In the report 2 add filter on column a.
In the operator option select +'is based on results of another analysis'+ ,
browse report 1 in the saved analysis,
select relationship is equal to any ,
use values in column a .
That is an interesting approach but it looks limited to using only one column, the matching columns in the two above reports were a and b - Is there a way to use both with this method or some other method ?
You can do the same for column b as well and then combine the 2 filters with And condition.
In the end the filter in report 2 will look like
a is equal to any a from report 1
b is equal to any b from report 1