How to navigate to child report based on value in parent report.

Robert Angel

I don't currently have access to OBIEE, but there is a means of generating the links - which takes most of the work out of GO_URL, so go the target report, filter it as you need and then capture the url at that point and compare with what you have.

See the below; -

https://docs.oracle.com/cd/E10383_01/doc/bip.1013/e10416/dashbdlinks.htm

User_JL3CW

Hi Robert,

As and when i click on the value in the report 1, my prompt does not change. Please see the following steps:

1. Report 1 has source agreement column.

2. Dashboard prompt created and presentation variable:

3. In dashboard properties set hidden dashboard prompt to filter.

4. In the dashboard pulled report1, and dashboard prompt.

5. I clicked on BPA-TAWSEEL-10 value (action link to target report) now source agreement prompt does not show anything. Target report is displaying in another without any result.

Target report:

Please let me know how to resolve this.

Regards,

Chandra.

Robert Angel

Hi,

it seems you have the filter as the explicit value 'pv_agreementvar' - this will never work, unless you have an agreement of that name!?

When you create the filter one of the options is to use a presentation value as the equal to / in value, you need to use this and it will then pull the variable, not use the variable name as a literal as you have currently, see =>

User_JL3CW

Hi Robert,

I have done in similar way as you explained.

For target report the filter applied as shown below. For agreement number column, filter created as shown. But no result

Regards,

Chandra.

Robert Angel

On your previous slide where you show the prompt I cannot see the value that you have created the prompt on, is it definitely the column that you are invoking the drill behaviour from?

Also check the scope of your dashboard prompt - is it global?

User_JL3CW

Hi Robert,

I am asking in the first dashboard page where my first report and prompt with same column resides. As i click on the value in the report, prompt should catch that value but it is not.

As you mentioned in your one of the reply:

say your source report has 3 columns A,B,C that need to be prompted and various others that don't.

You create a dashboard prompt for each of the three and you set variables in the dashboard prompt for each {MyVarA} {MyVarB} {MyVarC}

When you click on a row of data you will see that the prompts "catch" the values you click on setting the prompt to the values in the row.

Let us come to my report:

I have a first report with one column and its name is: Source Agreement.

I have created dashboard prompt for the same column and has presentation variable name: pv_agreementvar.

I have placed the report (with one column) and prompt in the dashboard page. As click on the value the prompt should capture the value but it is not.

Please see the steps for the screen shots:

1. Report with one column:

2. Dashboard prompt with the same column as shown in the report:

3. I have placed the above report and prompt in the dashboard page:

4. My requirement is when i click on the value for ex: BPA-TAWSEEL-11 in the report. then below prompt has to capture the value. But it is not capturing the value. Why? I followed the steps you have mentioned.

Regards,

Chandra.

Robert Angel

And did you check the scope of the variable is not restricted to page?

And is your prompt coming from the same subject area as the one in the report?

Can you put a text or heading on the same source page to ascertain if the variable is being set?

User_JL3CW

Hi Robert,

Above report and prompt created from same subject area.

I have created the static text, but it is not showing any value after clicking the value in the report.

Regards,

Chandra

Robert Angel

Can you repeat the test, I would try a shorter name, all upper case, no special characters, see if it makes any difference.

If it doesn't make any difference I would log an SR, this is standard functionality and should work!

Robert Angel

On should work -  does the variable get set if you actually use the prompt and select a value and click go?