Oracle Business Intelligence Applications

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

OBIEE Dashboard Prompt Variable

Received Response
73
Views
24
Comments

Hi,

I have created a Dashboard prompt which gets its value from another Dashboard prompt but doesnt get updated till I click on the "Apply" button... Is there a way to have this prompt updated as soon as I select the value from the previous prompt?

«13

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    You can remove the Apply button from the prompt so that the value is applied as soon as you select a value.

    pastedImage_0.png

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Thanks but then how would Users run the Dashboard after applying all the promtps?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That's the whole point of google-stlye "go-less" prompts. Everything that gets selected is automatically applied.

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Thanks a bunch and it works

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Couldnt agree more

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    If this is done then can you please close the thread?

  • KashSidd
    KashSidd Rank 5 - Community Champion

    I presented to the team but they dont like "Apply" button being removed because we have 8 prompts and they didnt like the Dashboard to be keep updating while changing prompts. Would I have any other options to go about this?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    So the don't like it with button and they don't like it without?

    Well you gotta go one way or the other I'm afraid...

  • KashSidd
    KashSidd Rank 5 - Community Champion

    With the Apply button its fine but its doesnt limit the values from one prompt to the other... Is there any other way around this? Basically, I want the Dashboard Prompt with the embedded SQL to be limiting its values from the previous prompt.

  • KashSidd
    KashSidd Rank 5 - Community Champion

    I was reading about Dashboard Filters and Variables and wondering if that can somehow play a role in this situation:

    pastedImage_0.png