After upgrading BI-Publisher from Obiee 11G to Obiee 12C, Action link has been changed
Solution:
Step 1:
We need to get the URL from xmlpserver, instead of Analytics.
Ex: login into xmlpserver, then navigate to report, and open that report
http://Localhost:9502/xmlpserver/servlet/home
Click on Actions -> Share Report link -> Current Page, copy the url,
Step 2:
In BI-Publisher report , right click on the column where we need to enable a hyperlink,
then navigate to -> Link -> InsertLink
here paste the URL, that we copied from the step1. then upload the RTF template. test the results.
How to pass a parameters to Navigation report.
Step 3:
we need to modify the url to pass to parameters to the navigational report.
for example, we have one parameter in dataset
for that dataset related report we generated and copied a url in step1.
Example url as mentioned below:
Before modifying the url
in this url it has one parameter, as we have only one parameter defined in the dataset. and passing the related variable that url to pass the parameters to the navigational report.
Solution:
Step 1:
We need to get the URL from xmlpserver, instead of Analytics.
Ex: login into xmlpserver, then navigate to report, and open that report
http://Localhost:9502/xmlpserver/servlet/home
Click on Actions -> Share Report link -> Current Page, copy the url,
Step 2:
In BI-Publisher report , right click on the column where we need to enable a hyperlink,
then navigate to -> Link -> InsertLink
here paste the URL, that we copied from the step1. then upload the RTF template. test the results.
How to pass a parameters to Navigation report.
Step 3:
we need to modify the url to pass to parameters to the navigational report.
for example, we have one parameter in dataset
for that dataset related report we generated and copied a url in step1.
Example url as mentioned below:
Before modifying the url
/xmlpserver/xxxxx/yyyy/zzzz/History.xdo?_xpf=&_xpt=0&_xdo=%2Fxxxx%2Fyyyy%2Fzzzz%2FSHistory.xdo&_xmode=&_paramsSERIALNO=&_paramsXDO_ESTIMATE_XML_DATA_SIZE=off&_paramsXDO_GEN_SQL_EXPLAIN_PLAN=off&_paramsXDO_DM_DEBUG_FLAG=off&_paramsXDO_ESTIMATE_XML_DATA_SIZE=off&_paramsXDO_GEN_SQL_EXPLAIN_PLAN=off&_paramsXDO_DM_DEBUG_FLAG=off&_xt=HistoryLayout&_xf=csv&_xautorun=true
After modifying url
/xmlpserver/xxxxx/yyyy/zzzz/History.xdo?_xpf=&_xpt=0&_xdo=%2Fxxxx%2Fyyyy%2Fzzzz%2FSHistory.xdo&_xmode=&_paramsSERIALNO={SERIALNO}&_paramsXDO_ESTIMATE_XML_DATA_SIZE=off&_paramsXDO_GEN_SQL_EXPLAIN_PLAN=off&_paramsXDO_DM_DEBUG_FLAG=off&_paramsXDO_ESTIMATE_XML_DATA_SIZE=off&_paramsXDO_GEN_SQL_EXPLAIN_PLAN=off&_paramsXDO_DM_DEBUG_FLAG=off&_xt=HistoryLayout&_xf=csv&_xautorun=true
