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
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
I am getting a general error when my workbook's scheduled email tries to send out an excel file (See below error). I have tested and successfully send a scheduled email that sends a PDF - so I am wondering if there is an issue with sending excel files currently? It worked fine until this morning:
