Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to navigate to child report based on value in parent report.
Answers
-
Hi,
another poster has given you the answer to this.
Create a hidden dashboard prompt that includes a prompt for the value that you want to coordinate. On that prompt have it set a variable.
It is worth starting with this initially not hidden to check that it is catching the click on the data item as it should be.
Use that variable as the filter on the target column that isn't the same name.
Have your column open the other report, this has worked for me many times.
Or build up the GO_URL, it is a good deal easier than it used to be.
Best Regards,
Robert.
0 -
HI Robert,
I am not clear on one thing how will you have the value in the hidden prompt column (Source Agreement).
As when i click on the measure value in the report the corresponding agreement value (for example: BPA-TAWSEEL-10) has to pass to prompt column. How it will pass to the prompt column?
Regards,
Chandra.
0 -
It will not pass. Only the one you clicked will be captured and can be used in another subject area.
0 -
HI asim,
If i click on Source agreement (report 1) column then how will you capture value. Request you please detail me for my scenario.
Regards,
Chandra.
0 -
Dear Chandra,
Create a prompt and presentation variable for the column source agreement and use it as default prompt in a dashboard page and keep the report in the same page . Also keep it in the page where your first report resides. Check the screenshots above and let me know which part is not clear for you.
0 -
Hi,
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.
All you need to do then is set your on click value on ANY of the columns to navigate to the other report.
And in the target report for the equivalent columns AA, BB, CC, you need to filter each to be equal to your presentation variable {MyVarA} etc.
As I said I have used this on very complex reports and the hidden prompts will catch multiple columns data level values and the target report will then give you correctly correlated data.
Hope this helps,
Robert.
0 -
HI asim,
I have created prompt and pv for source agreement column. PV name is pv_agreementvar.
Step1: I have placed prompt and report1 in dashboard page1
In the above screen i have placed report and below prompt. Now i will click on last column value (BPA-TAWSEEL-10) then how my prompt capture that value here. In report1 column Source agreement, I have navigated to report2 through action link.
Step2: I have placed same prompt and report 2 in dashboard page 2
How this prompt captures value from 1st db page and filters 2nd report here.
Pls correct me where i am wrong here.
Regards,
Chandra.
0 -
Any help please
0 -
Hi all,
I am trying with GO URL from column formula.
I have written the following formula in the 1st report column. I am trying to pass Source Agreement column value to another report column (Agreement Number) in another subject area. But target report is not filtering with value as when i click on value (BPA-TAWSEEL-10) in first report. Displaying complete report.
Formula:
1st report screen shot:
'<a href=saw.dll?Go&Path=/Shared/Custom/Procurement/BPA%20Details%20report&Action=Navigate&P0=1&P1=eq&P2="Blanket Agreement Header Detail"."Agreement Number"&P3="- Purchase Order Line Detail"."Source Agreement">'||'Link'||'</a>'
"BPA Details report" is target report and built with another subject area. Column to filtered is Agreement Number.
Please let me know what is wrong with code written.
Regards,
Chandra.
0 -
Hi,
two things to check; -
1. Make your prompt visible if it is not. Click on your value that invokes the navigation, but make sure it does it in a new window - go back to the original window, did the prompt change to the value that you just clicked on?
2. On the target page add a title / text area or similar and display the parameter that you should have set in 1 above
If point one fails then check your parameter corresponds to the column that you are drilling from
If point two fails then check the syntax on the parameter that is being set by the prompt
Also, I assume that you have added a filter to the column on the target to filter the value explicitly to the presentation variable?
Hope this helps,
Robert.
0
