OBIEE 11g: How to pass specific column value to filter another report?

Question

Hi Gurus,

I have a unique problem. I want to pass a value from Report 1 (lets say "employee code") to Report 2 and filter based on the condition below

Report1=>Employee_Code=Report2=>Manager_Code

Can you please let me know how it can be done? I tried to make the question simple to understand, but I can elaborate if required.

Thanks in advance.

Regards

Sudipta

Shams Abbasi · Answer

If you want to filter results based on the other report you can go to filter and use the option Filter results based on result of another analysis, there you can specify the column u want to filter the results on.

Let me know if it helps.

[Deleted User] · Answer

Have you looked at the documentation link and Nico's page? They describe precisely how that works.

You pass values from the originating analysis into the Go URL by using the URL parameter interface of any normal URL action:

Sudipta Gupta · Answer

Hi Christian,

How can I pass a value to a specific filter from Report 1 to Report 2? I want to pass the value of "Employee_Code" from Report 1 to target column "Manager_Code" of  Report2

What would be the syntax in Go URL? Is there any other way to do the same?

Thanks for your help.

Regards

Sudipta