OBIEE - Navigate to a detail report with the cell passed as a parameter

Johan Hammes-92061

Hi

I have a summary report in OBIEE and want to click on an account(e.g. I2500) on the summary report which would then navigate/open a detail report as per below:

Although the account number is the link between the summary and detail reports, the column names are not the same so it would no know what to link on. Therefore Is Prompted would not work in the detail report as a filter.

If I click on I2500 in the summary report the detail report with accounts I2500 only must open. The same applies to other accounts.

Please provide a link to OBIEE documentation where the proposed solution is explained.

Gianni Ceresa

You have to write the URL with the filter expression yourself because of using 2 different columns.

https://datacadamia.com/dat/obiee/obips/url_filter

Here you can see the format of passing a filter to an analysis. The receiving analysis can use "is prompted", because it will not see the value comes from a different column (the URL will clearly say that it's the target column to be filtered, doesn't matter where the value come from).

Johan Hammes-92061

Thank you Gianni.

The OBIEE target detail analysis that is using IsPrompted as a filter is however a case statement and not a single column so the IsPrompted is not working. So I therefore need to set a presentation variable. How do I use the Go URL to pass the cell that I am clicking on in the summary report as a presentation variable to the detail analyses?

In the detail/target analysis I tried to end the column's CASE statement with... END as "Target_Column" as part of the IsPrompted column formula and then reference Target_Column in the GO URL as a parameter, but that also did not work.

Johan Hammes-92061

Hi Gianni

I cannot get the GO URL with parameters to work. Will you please have a look at my screenshots below. I have also attached the XML. All records in the target/detail analysis are returned... so the IsPrompted filter column is being ignored.

1Action_Parameters_Screenshot.png

1Action_Parameters_Text.txt

1Summary_Analysis_XML.txt

2Target_Analysis_Screenshot.png

2Target_Detail_Analysis_XML.txt

Thank you.

Johan

Gianni Ceresa

The navigation passing parameters works well even if you have a CASE WHEN formula or whatever else in the target analysis. Of course the filter should still be on the column itself, even if it isn't part of the selection criteria.

The navigation URL is quite simple (also documented in the documentation)

?Go => navigate to just the analysis, without the tool header/footer
  or 
?PortalGo => navigate to the analysis inside the usual tool header/footer

&Action=Navigate 
&Path=<the path of the target analysis/dashboard page>
&P0=1
&P1=eq
&P2=<the reference to the target column>
&P3=<the value>



Johan Hammes-92061

dhaesejan

you can use a help report.

In this help report you use 1 column 'account', which is prompted.

So when you click on account 12500, only 1 row will show.

In the detailreport, you can filter your column 'based on results of another analysis'. Here you choose the account from the help report.