For example I have Master report with Columns A, B and C. master detail is enabled on column A. I want to drill down to child report based on column B and this has to pass Values chosen in Column A and B to child report.
If you are talking about master detail, which is to say a master report where the user can click on a row and a detail report which listens then the detail report will catch ALL dimensions in the row that you click on.
https://gerardnico.com/dat/obiee/obips/master_detail
If you are talking about using an action link to drill into another report then all that you need to do is put is prompted filters on the target columns that you want to be correlated and then use the action link to navigate to the target report, or if your requirement is not related to the same subject area / dimensions in both cases you might need to set parameters to be used in the filter on the target, or if very complex then go_url may be the way to, er... go.
Passing Parameters Between Reports
If your requirement is different from both of these situation can you clarify please as I read your requirement over a number of times and was not clear on your requirement.
Robert,
Thanks for your response. I have 2 reports report A and B.
I have 2 views in report A. Let’s say View 1 and View 2 which are connected by master detail view. i.e., View 1 has 2 columns ‘age’ and ‘Counts’.
View 2 has ‘Age’, ‘Services’ and ‘counts by services’. When I select a particular age group in view 1 the results in view 2 will change accordingly.
Now I want to drill down from view 2 to another report B using action links on services column. The problem I am facing is I am not able to pass the ‘age’ chosen in report A view 2 to report B.
Hi "3267774",Robert has already given you the correct answer, and you should mark his answer as such. (I'm not fishing for his points) I just wanted to point out that when you add the action link to the Services column, use the "Navigate to a Web Page" option, not the "Navigate to BI Content". Place your Report B on a dashboard page (hidden, if you prefer). If you are unfamiliar with the action link syntax, add a temporary dashboard prompt containing both "Services" and "Age", with default values to the hidden page. Under the page options, use the "Create a Prompted link" option. This will generate a prompted URL to insert in the action link in Report A. Then, you only have to replace the default values with column.names in the action link editor.
This example generates a url something like this:
<MyPath/analytics/saw.dll?Dashboard&PortalPath=%2Fusers%2Fmy.folder%2F_portal&Page=action%20link%20test&Action=Navigate&col1=%22Project%20Info%22.%22PIN%22&val1=%22000004.00%22&psa1=%22Productivity%20-%20Projects%22&col2=%22Project%20Info%22.%22Project%20Manager%22&val2=%22Anderson%22&psa2=%22Productivity%20-%20Projects%22
My default values show where to add column values in the action link. Then, you can delete the prompt from your hidden page, if you used one.
Thanks Jerry, was head down in other work but when I came back you had done a better job than I had, kudos!!
++Jerry
Thanks Jerry for explaining it in detail.
I have 2 views in report A. Let's say View 1 and View2 which are connected by master detail view. i.e., View 1 has 2 columns 'age' and 'Counts'.
View 2 has 'Age', 'Services' and 'counts by services'. When I select a particular age group in view 1 the results in view 2 will change accordingly.
Now I want to drill down from view 2 to another report B using action links on service column. The problem I am facing is I am not able to pass the 'age' chosen in report A view 2 to report B.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
