1 person found this helpful
Create a Level Based Hierarchy on the three tables and select drill down It will work,
Let me know if you need any help in creating the same.
Mark if helps,
thanks for response
this should be done in the repository level right ?
if yes i am just using the BI Publisher at this point
not integrated with OBIEE or repository
If no please guide me how to do it through publisher
Are you using RTF template or On-Line Editor?
take a look at Oracle BI Publisher YouTube Channel
Thanks for the links
what i wanted something like this
the third picture
dunno if it is possible or not
You might want to spend some time reviewing
Primarily - 4 Adding Parameters and Lists of Values
Seems that i have explained it in wrong way or something
what am trying to do is
in the main dashboard i was the main page include categories
like for departments, and under each one to have a drill down list of the reports related to it like the picture
hope this clarify what am trying to do