Reset to last applied values is not working in obiee 12c — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reset to last applied values is not working in obiee 12c

Received Response
92
Views
7
Comments
3167974
3167974 Rank 4 - Community Specialist
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

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.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Robert already said it, also maybe a screenshot will help to clearly see what you see when and where

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    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.

  • 3167974
    3167974 Rank 4 - Community Specialist

    Hi,

    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.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.

  • 3167974
    3167974 Rank 4 - Community Specialist

    hi,

    yes we have 2016 as default value in dashboard prompt and so forth we have data related to these intersection in db

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi @3167974

    2017-02-22_11-20-03.png

    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