I have a requirement where i would need to navigate from a Direct DB request to a prebuild child report.
Navigation works fine by setting up the Intraction on the column properties on the Direct DB request, but i would need to restrict data at the child report while navigating.
is there any way i can use GO URL here, if yes, how to pass a column filter from Direct DB Request to a Prebuild OBIEE report.
Instead of Navigation try to do it HTML link by modifying the for column value something like
select last_name,'<a href=http://localhost/analytics/repName?colname='||dname||'>' from emp
check syntax, and its not straight forward as any BI report.
if helps mark and update us back
The Direct DB Request SQL is very complex, i cannot add a HTML link into that now.
Currently the GO URL looks like below:
I would need to pass a column value in the above URL instead of passing a static value "Energy". Please suggest.