I got two reports developed in obiee. I wanted to create a drill through from report 1 to report 2. I was serching for option but i couldn't find and i searched one the web also didn't get any usefull help either. can anybody guide me to achieve this task.
oracle biee 220.127.116.11
oracle database 11.2
Thanks in advance
First just a bit of clarification, you can drill up and down a heirarchy... but going from one report to another is called navigating. This tutorial walks you through the process...
Adding to what Jason has suggested, Also try the Master Detail report linking process. It might meet your requirement.
The below article helps for master detail reporting
Hi Guys, Thank you for your consern. Navigation to another BI content is working fine and its filtering for selected value, thats all fine. I need you help with couple things pointed below
The easiest way to filter report B and show those values would be to use presentation variables. You also mention that report A is filtered for period, so you already have a prompt for that. Within that prompt, set a variable P_PERIOD. In report B, filter the period using P_PERIOD. You can use a narrative, static text, etc. to show the selected values stored in P_PERIOD.
Do the same thing for area. Create a prompt, set a variable, filter report B using that variable. If you don't want the user to see the area prompt, you can hide it by setting the custom CSS to display:none;