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 ?
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4
So I have an action passing a value to another workbook. On the other workbook, I have an expression filter and a parameter I created and it does not seem to work. Any ideas. See the images
We know you can directly export workbooks and folders from within OAC, and we know you can migrate OAC content using the FDI Content bundle. However, it's unclear what settings or steps are required in order to ensure any calculations in "Shared Objects" still carry over. When making a .dva artifact export from OAC for…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
