Analytics Software

Hi All,

I am in OBIEE 11g v6.

Let's say, I have two dashbaord pages P1 and P2.

P1 page contains
1. Prompt PR1 - containing a single column EmpName
2. Report R1

P2 page contains
1. Prompt PR2 - containing a single column EmpName (same column as in PR1)
2. Report R2

Requirement :
Let's say a user select a value = David from the EmpName column in prompt PR1. In the Report R1, on one the measure columns 'Sales', I am using an action link - Navigate to URL ( I can't use Navigate to BI Content for some reasons). In the URL, I am giving the URL to page P2. Can I pass the selected value (which is David) to the EmpName column of the Prompt PR2 of Page P2 so that Report R2 is automatically limited by David when I land on that page through the URL?

Few things to consider are, I can't use EmpName column in my report R1 on page P1, I just want to pass the value of a common column from one prompt on Page1 to another prompt on Page2. Is that possible. Can anybody please help?

Thanks,
Ronny