Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

BI Publisher - Prompts that update other prompts

edited Aug 2, 2019 8:41PM in Reporting and Analytics for HCM 3 comments

Summary

Refresh Other Parameters on Change causing parameters to blank

Content

Hello Experts!

I have a data model where we've built 8 parameters and I'm trying to make them interact with each other.

Each of the parameters is a menu that is based on a query. In each of the prompts I've made connections and references to the other parameters in attempts to filter each of the prompted values on the previous selections you've made. This should help guide the user to valid selections when they want to filter the data.

When trying to view the data from the data model, I'm able to populate the first prompt, and it will update the rest, but trying to update a second has caused the entire list of prompts to change back to the All value. If I remove the option to refresh other parameters on change on all except one, I not longer see that behavior but changing the others doesn't update their respective lists. (as expected)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!