OBIEE11g Master_Detailed events

Creating   Send Master_Detail Events:

This is used when Customer wants to see the details of Summary  report side by side.

Prerequisites:

1. Specify Channel should be unique.
2. Should give that unique name in Properties of the detail event.
3. prompt is mandatory whatever view you are using.(i.e. graph or table or pie etc..)

Steps:

This  Example is when Customer click on particular portion of Pie Chart, The details of that portion should be shown side of that report.

1.  Create Report with different Views (table,Graph,Pie etc..)

2.   Click on “Column Properties “ of the column in the Criteria

and click on “ Interaction” tab

Under the “value “

Select Primary Interaction  as “Send Master-Detail Events”

Give  Specify Channel “ A unique Name” and  ok

3. Go to “Result “tab & Edit Table View

Click on table properties

  

4. Check the “”Listen to Master-Detail Events

And in the “Event Channel “Give the Unique name  give at step 2.

5. Give the Table Prompt (Drag the column in the “Table Prompts”)

Giving prompt is mandatory whatever view you are using. (I.e. graph or table or pie etc..)

6. Now run the report and click on pie chart, the details of that report will be shown in tabular format.

Save the report.

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 .