Action links wont pass parameter — Oracle Analytics

Oracle Analytics Cloud and Server

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

Action links wont pass parameter

Received Response
1
Views
5
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead

Hi i am using obiee 12c

I have one report in which i count some subjects.

What i want to is when I click on the number it shifts me to another report which is showing me what subjects  are counted.

I managed to do that except one thing, action links pass every parameter  to detail report i want except one.

So it pases every prompt value and column value but not this from row

pastedImage_0.png

Any suggestions??

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Are both reports based on the same subject area?

    Does the target report include an is prompted filter on the field in question?

    Is it a field, not based on a calculation?

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    Same subject area, i have a is prompted filter for that field, and yes it is a field. I have almost the  report and it passes parameter corectly.

    Cant figure out why this one doesnt work.

    I did a workaround, I placed   --is based on another analysis--   filter and it works fine.

    But that still didnt clarify my first question.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    And your action link is at row level and is invoked on the highlighted column?

    As a workaround you could create a dashboard prompt for the same column, and set a presentation variable with it, filtering based on the presentation variable.

    You can then display the presentation variable whilst testing and that way you will have assurance that it is 'catching' the parameter, which might give you more of a clue on what is happening on your second report - particularly if you add a show sql presentation or similar for further diagnostics.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Two other questions; -

    Did you try the above as a table rather than pivot table to see if you get the same result?

    Would a master / detail serve your purpose better if you are looking for a row level coordinated detail?

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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Did you resolve your issue?

    If not can you provide any further detail or if it is resolved can you close the question?