Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Drill down using Action links to detail report based on one column and also want to pass master-deta

Received Response
440
Views
6
Comments
3267774
3267774 Rank 1 - Community Starter
edited Aug 13, 2024 5:31PM in Oracle Analytics Cloud and Server

For example I have Master report with Columns A, B and C. master detail is enabled on column A. I want to drill down to child report based on column B and this has to pass Values chosen in Column A and B to child report.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    If you are talking about master detail, which is to say a master report where the user can click on a row and a detail report which listens then the detail report will catch ALL dimensions in the row that you click on.

    https://gerardnico.com/dat/obiee/obips/master_detail

    If you are talking about using an action link to drill into another report then all that you need to do is put is prompted filters on the target columns that you want to be correlated and then use the action link to navigate to the target report, or if your requirement is not related to the same subject area / dimensions in both cases you might need to set parameters to be used in the filter on the target, or if very complex then go_url may be the way to, er... go.

    Passing Parameters Between Reports

    If your requirement is different from both of these situation can you clarify please as I read your requirement over a number of times and was not clear on your requirement.

  • 3267774
    3267774 Rank 1 - Community Starter

    Robert,

    Thanks for your response. I have 2 reports report A and B.

    I have 2 views in report A. Let’s say View 1 and View 2 which are connected by master detail view. i.e., View 1 has 2 columns ‘age’ and ‘Counts’.

    View 2 has ‘Age’, ‘Services’ and ‘counts by services’. When I select a particular age group in view 1 the results in view 2 will change accordingly.

    Now I want to drill down from view 2 to another report B using action links on services column. The problem I am facing is I am not able to pass the ‘age’ chosen in report A view 2 to report B.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi "3267774",
    Robert has already given you the correct answer, and you should mark his answer as such. (I'm not fishing for his points)  I just wanted to point out that when you add the action link to the Services column, use the "Navigate to a Web Page" option, not the "Navigate to BI Content".  Place your Report B on a dashboard page (hidden, if you prefer).  If you are unfamiliar with the action link syntax, add a temporary dashboard prompt containing both "Services" and "Age", with default values to the hidden page.  Under the page options, use the "Create a Prompted link" option.  This will generate a prompted URL to insert in the action link in Report A.  Then, you only have to replace the default values with column.names in the action link editor.

    pastedImage_24.pngThis example generates a url something like this:

    <MyPath/analytics/saw.dll?Dashboard&PortalPath=%2Fusers%2Fmy.folder%2F_portal&Page=action%20link%20test&Action=Navigate&col1=%22Project%20Info%22.%22PIN%22&val1=%22000004.00%22&psa1=%22Productivity%20-%20Projects%22&col2=%22Project%20Info%22.%22Project%20Manager%22&val2=%22Anderson%22&psa2=%22Productivity%20-%20Projects%22 

    My default values show where to add column values in the action link.  Then, you can delete the prompt from your hidden page, if you used one.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Thanks Jerry, was head down in other work but when I came back you had done a better job than I had, kudos!!

    ++Jerry

  • 3267774
    3267774 Rank 1 - Community Starter

    Thanks Jerry for explaining it in detail.

  • 3267774
    3267774 Rank 1 - Community Starter

    Robert,

    Thanks for your response. I have 2 reports report A and B.

    I have 2 views in report A. Let's say View 1 and View2 which are connected by master detail view. i.e., View 1 has 2 columns 'age' and 'Counts'.

    View 2 has 'Age', 'Services' and 'counts by services'. When I select a particular age group in view 1 the results in view 2 will change accordingly.

    Now I want to drill down from view 2 to another report B using action links on service column. The problem I am facing is I am not able to pass the 'age' chosen in report A view 2 to report B.