Saturday, December 29, 2012

Conditional Navigation in OBIEE 11G


I have a report from which, I need to navigate to two different reports based upon the rows in a column.
For Example: For the Year 2010 I have to give one Navigation detail report and for the year 2012 I have to give navigation to other detail report etc..
Lets follow the steps (Simple Example) :
Step1: Create a report .
Step2: For the year column go to column properties .
Step3: Click on Interaction tab and select Action Links as shown in below screenshot.
Step4:Select Navigate to BI Content
Step5: Select detail obiee report and click OK
Step6: Click on conditionally Radio Button and select Per Name Year.
Step7: Select year = 2010(Here if the Year = 2010 then , you can navigate to the particular detail report)
Click OK .
Step8: Click on results and you should be able to see the hyper link on only the year 2010 .
Do the same for all the years and give different detail reports