OBIEE 11g: Filtering report by passing parameters thriugh Action Link not working — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g: Filtering report by passing parameters thriugh Action Link not working

Received Response
121
Views
2
Comments
Sudipta Gupta
Sudipta Gupta Rank 2 - Community Beginner

Hi Gurus,

I created 2 reports. On clicking a column from Report1 should initiate action link to show Report 2 and filter Report 2 by passing one parameter from Report 1.

But the Report 2 is not being filtered out after passing a parameter from Report 1.

In the Report 1, First column, I created the Action link and passing the parameter value as shown below.

URL: https://XXXXXXXXXXXXXX/analytics/saw.dll?PortalGo&Action=@{1}&path=@{2}&3=@{3}&4=@{4}&5=@{5}&6=@{6}

Report1.jpg

In The second (target) Report 2, I used the same column as Prompted, as shown below

Report2.jpg

Still, the target report is not filtering the value and showing all result.

Please advice where it could get wrong?

Thanks in advance

Regards

Sudipta

Answers

  • green4x
    green4x Rank 1 - Community Starter

    Hi

    Could it be helpful to set up filtering the report based on presentation variale (clicking on "Add More Options" in New Filter menu)?

    IKdUU4E.png

  • DanPryke
    DanPryke Rank 3 - Community Apprentice

    Hi,

    Are you navigating to a report that is coming from the same subject area/prompting the same column?

    If so, you should be able to set a navigate action link on the column you want and point it at the dashboard/report you want.

    action link.png(SELECT NAVIGATE TO BI CONTENT)

    report select.png

    Add a filter on the second report to saying 'is prompted' on your column

    prompt.png

    This should carry over the values.

    report link.png

    report done.png

    Hope this meets your needs