hi,
i have requirement to show the reports based on report selection. but when i select any report from prompt to be shown and after that when i apply reset to last applied values. its not working at all.
please give me any solution for the same.
I am struggling understanding exactly what you are saying your problem is.
Can you kindly clarify are you talking about dashboard prompts?
Can you give the exact sequence of events with navigation path to describe exaactly what you are doing, and what happens when you do it?
Robert already said it, also maybe a screenshot will help to clearly see what you see when and where
Hi,
Maybe what you are looking for is the "Apply" button which sometimes can be hidden.
In cases when the Apply button is hidden then the prompts are automatically enabled after the selection.
e.g. If all set correctly your report will be filtered for 'Austria' just after you select 'Austria' in your prompt. no further click is needed.
If you click on Reset, then the dashboard page will be filtered for the original set of prompts.
my requirement is that i have some columns in prompt and there we have written sql query so its sql based prompt and also in our prompt there are some columns which are directly coming from subject area and that columns are limited by some other column. so what happen is when i select any value say for ex year ='2016' from prompt and click on apply button it shows me the results after if i select any other value say for ex. year ='2017' from prompt and click on reset to last applied values its not resetting to last applied value i.e, year ='2016' instead its staying on the year ='2017'.please let me know about the same.
You don't say if '2016' is a valid value (does it exist in the underlying data set of the subject area you are filtering?)
You also don't say if you only have one dashboard prompt and if so is the 'limited by some other column' on the same dashboard prompt as the value that it is being limited by?
Also if it is on the same dashboard prompt as the value it is being limited by, what value does that revert to AND does 2016 validly exist with whatever that selection is?
i.e. If your quarter last applied value is say 2017 Q1 then because of your 'limited by value of quarter' the year could not be anything other than '2017'
Help us to help you please in future, to get the best answers on these boards you need to provide the best information as to all of the relevant aspects of your problem.
yes we have 2016 as default value in dashboard prompt and so forth we have data related to these intersection in db
Hi @3167974
What you are clicking on is Reset to last applied values -> in your case if you APPLIED 2017 it will of course bring back 2017 -> this actions basically "deletes" all changes made on the prompt but not APPLIED.
What you're looking for is Reset to default values option
If this answer your question, please mark the thread as closed so others with the same question can benefit
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…
