OBIEE Go URL

Go Url:

The GO URL is useful when you are accessing the report in a different subject area.

Please follow the detailed steps to create Go Url Functionality:  

1. Create a summary report.

2. We would like to see the invoice line details which belong to different subject area and our requirement is that,after clicking the invoice number will get the invoice line details.

Go to the invoice number column properties à Data Format à Enable the Override default data format check box à Make the Treat text as Html

      3.Create a detailed report. Note that detailed report belongs to different subject area and make the invoice number as prompted.

4    4. Copy the navigation of detail report url.

http://172.21.7.92:7001/analytics/saw.dll?Answers&Action=results&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP

      5. Go to the summary report and select the invoice number properties and click on edit formula

and update the following url in column formula. http://172.21.7.92:7001/analytics/saw.dll?Answers&Action=results&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP

i)<a> </a> à this is an html tag which is used to represent hyper link.

ii) href is the property to specify the destination report. Copy the detail report URL: http://172.21.7.92:7001/analytics/saw.dll?GO&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP

iii) action is the event which specifies navigation and the value is action = navigate.

iv) P0 is the parameter which specifies the number of parameters that are transferring from source to destination. Here in our example invoice number is the only parameter so P0 = 1

v) P1 is the parameter to represent the assignment (example values are eq is equal, gt refers greater than, etc).

vi) P2 is the destination parameter where this source parameter is transferred to corresponding destination value. (Value = ="-%20Nx_APG0_Invoice_Distributions%20(Payables%20Views)"."Invoice%20Number").

Note: Browser unable to identify the spaces in the URL so please replace the space with hexadecimal value of space %20.

Column variable name for the destination column "- Nx_APG0_Invoice_Distributions (Payables Views)"."Invoice Number".(Replace this column name without spaces).

"-%20Nx_APG0_Invoice_Distributions%20(Payables%20Views)"."Invoice%20Number"

vii) P3: Source column name('||"- Nx_APG0_Invoices (Payables Views)"."Invoice Number"||')

Note: Here we are not replacing the spaces with hexadecimal value because while navigating browser assign the value of source parameter.

Final value is: '<a href=http://172.21.7.92:7001/analytics/saw.dll?GO&path=%2Fshared%2FAK%2FTEST_GO_URL_DETAIL_SP&Action=Navigate&P0=1&P1=eq&P2="-%20Nx_APG0_Invoice_Distributions%20(Payables%20Views)"."Invoice%20Number"&P3='||"- Nx_APG0_Invoices (Payables Views)"."Invoice Number"||'>'||"- Nx_APG0_Invoices (Payables Views)"."Invoice Number"||'</a>'

Run the Source report and click on invoice number and it will navigate to next destination report .