Hello,
I am creating an analysis and i want to have a prompt filtering both graphs , how can i do it ?
Thank you , i dont use OBIEE that much !
If you are trying to put the analyses on the dashboard. Please create a dashboard prompt and you can search internet on how to create dashboard prompts in OBIEE
Thanks
DNK
If i create a dashboard prompt , then i will have to choose a prompt then to execute the report , i can't after that change the value of the prompt .
Is there any dynamic prompt to change a prompt value without executing again the report ?
Thank youu
In dashboard properties or prompt page properties , if you hide apply and reset button ...it will not ask you to submit the report again. It will apply new prompt as soon as it is selected. Check if this is what you want ... Par your requirement you need to use dashboard prompt.
Your screenshot looks like a single analysis with 2 views, right? If it's the case the easiest way is to set a master-detail, so the table view where you have the year prompt will drive the other view on the left (a chart I guess) and change the year directly.
If it's 2 analysis or you want it in a dashboard page than you can also do what others above posted with a prompt (just remove the column YEAR from the prompt area of the table view as it will always contains a single value, so useless).
Thank you Gianni , One more question
When i put the prompt and the Report in the same dashboard the prompt doesn't filter the report ... do i have to make the link somwhere ?
Thank you
In the analysis you need to add a filter on the column as "is prompted".
Because it's a real filter (so the query sent to the source contains a WHERE clause filtering the value, you change the value a new query is executed), while the one you used as example is just a visualization filter (so the query is executed once without filters).
Hello GIanni ,
Just to understand well
Case of Analysis report ( not dashboard ) :
I have 2 Graphs in the same report , if i want to have only one prompt for both graphs , i try to create a master detail channel MD01 with my YEAR_ID column
then i go to my second graph ( in the same report ) i make the YEAR_ID as a prompt and define the graph as a listener to my Master detail MD01 but it doesnt work
It works Thank you Gianni !
So you managed to get master-detail to work?
Or you managed to fix the dashboard prompt issue not filtering your analysis?
I used the filter prompt with the dashboard , for the master-detail i didn't try it ! but the second solution is better tho.
When i try to see the report as a .pdf it becomes in disorder , is it normal ?
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…
