Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

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

Comments

Hi Asim, Please see the screen shots. 1. Report 1 has source agreement column. 2. Dashboard prompt created and presentation variable for Source Agreement Column: 3. In dashboard properties set hidden dashboard prompt to filter. 4. In the dashboard pulled report1, and dashboard prompt (Report and prompt has same column from…

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 27, 2017 2:40AM
Hi Robert, Presentation variable is not setting as i click on the report value. I dont know what is the problem. Regards, Chandra.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 12:13PM
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

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 11:31AM
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…

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 11:02AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 10:29AM
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…

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 9:46AM
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 How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 9:01AM
Any help please

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 25, 2017 3:10AM
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…

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 24, 2017 11:33AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 24, 2017 10:19AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 24, 2017 9:49AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 24, 2017 9:18AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 24, 2017 8:32AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 23, 2017 8:34AM
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…

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 23, 2017 7:20AM
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.

in How to navigate to child report based on value in parent report. Comment by User_JL3CW Aug 23, 2017 5:41AM
hi, One more thing, I have installed OBIEE in my personal laptop and I am working on it. I have installed windows 7 OS. Do i require to install Server OS? Regards, Chandra.

in Unable to open analytics in OBIEE 11.1.1.9.0 Comment by User_JL3CW Apr 20, 2017 11:27AM
HI, Please guide where exactly i could find, the Adminserver and nodemanager logs and also managed server log. Regards, Chandra.

in Unable to open analytics in OBIEE 11.1.1.9.0 Comment by User_JL3CW Apr 20, 2017 11:22AM
Hi, OS is real one only. Regards, Chandra.

in Unable to open analytics in OBIEE 11.1.1.9.0 Comment by User_JL3CW Apr 20, 2017 10:27AM
Hi, PFA. Regards, Chandra

in Unable to open analytics in OBIEE 11.1.1.9.0 Comment by User_JL3CW Apr 20, 2017 9:43AM

More Comments

MFA for Oracle Community

Welcome to the Oracle Analytics Community

User_JL3CW Rank 6 - Analytics Lead

Comments