On the forums every so often you see the question: “I want to navigate from report A to report B and pass the value where the user clicks as filter” . This is actually quite simple in OBIEE. Let’s start with a simple base report showing a list of available markets:
Next create a target report containing markets and revenue:
Next go back to your base report and open the column properties screen for your “Market” column:
Set the navigation target:
If you now test the report you will see that the clicked value isn’t passed as filter
This is because the report isn’t let “filter” aware. Go to your target report and set a filter on the “Market” column of the type is prompted.
If you now test it again, you will see the filter value is passed:
Till Next Time