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

User_JL3CW

Hi all,

I have requirement to drill to another report (which is in Subject Area from Parent report (Which is made of Subject Area A).

The below report data build on Subject Area A.

As when i click on Agreed Spend amount then it has to take to the below report (Built on Subject Area .

It has to show only one record BPA-TAWSEEL-10, but showing entire report.

I tried with Action link to the child report but not filtering. It's showing entire report (may be because column names are not same (Source agreement in Subject area A, Agreement Number in Subject area ). Please let me know how to filter based on value (BPA-TAWSEEL-10) from the parent report.

Regards,

Chandra.

[Deleted User]

3319067 wrote:(may be because column names are not same (Source agreement in Subject area A, Agreement Number in Subject area )

Not maybe - that IS the reason. You could cheat the system by having both columns in both subject are have a matching fully qualified alias so that the match can happen.

Alternatively - and this is the more proper solution - is to use parametrized GO urls: https://docs.oracle.com/middleware/12212/biee/BIEIT/apiwebintegrate.htm#BIEIT363

User_JL3CW

Hi Christian,

Thanks for the reply.

Where do i require to do "fully qualified alias" for two columns.

This is cloud environment (using 11.1.1.9 version). Do not have access to RPD. Please let me know.

Regards,

Chandra.

[Deleted User]

3319067 wrote:This is cloud environment (using 11.1.1.9 version). Do not have access to RPD. 

You see that's exactly the reason why it's a good idea to always, right away from the start, state what your version and your context are. It wastes a lot less of everybody's time!

So then check out the Go URL I posted

asim cholas

Create and keep the second report in a dashboard page and keep the reports with hidden prompt in second dashboard for the column u need to filter and use presentation variable

User_JL3CW

Hi Christian,

Currently Agreed Spend measure (1st report) column having the following formula.

FILTER("Procurement - Purchasing Real Time"."- Purchase Order Distribution"."Purchase Order Distribution Amount" USING ("Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Agreement Reference Flag" = 'Yes'))

I am unable to write Go URL from this column.

2nd report name: BPA Details report.

Column name: "Blanket Agreement Header Detail"."Agreement Number"

I have written the following query but throwing an error.

<a href=https://efjj-test.bi.em3.oraclecloud.com/analytics/saw.dll?&Path=/Shared/Custom/Procurement/BPA%20Details%20report&Action=Navigate&P0=1&P1=eq&"Blanket%20Agreement%20Header%20Detail"."Agreement%20Number"="Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Source Agreement">Report Name</a>

Request you please help me.

Regards,

Chandra.

asim cholas

Did you try the second approach?

Keep the report in a dashboard page and use a presentation variable and a prompt. Let me try in my environment and will update you.

Below two reports are from two different subject areas.

Prompt  Settings

You can choose the default prompt for dashboard page  from dashboard page properties (or keep it in section itself)

User_JL3CW

Hi,

Here i am clicking on Agreed Spend column and i need to pass  Source Agreement value to another report (another subject area).

1st report

Not able to get the result.

Regards,

Chandra.

User_JL3CW

HI all,

Please suggest how to pass parameter to the child report from column formula (href).

Please see above i have written formula but was unable to correct.

Regards,

Chandra.

asim cholas

Clicking on one value and passing another, also navigating to another subject area ... Why not navigate from source agreement column, so that you can pass the value.

Check the below blog. May be helpful though i am not sure.

User_JL3CW

Hi Asim,

I have placed the Source Agreement column for understanding problem description. Real scenario the Source agreement column will be hidden.

User has to click on measure to drill down to another report. Please let me know how to correct the href script.

Regards,

Chandra.