OTBI dashboards using 2 fields prompts based on one
Summary:
Dashboard with two prompts fields based on one field, and currency prompt
Content (please ensure you mask any confidential information):
I'm creating a dashboard that primarily utilizes compensation subject fields from both open and closed compensation plans. I would like this dashboard to allow users to search using either "person number" or "person name" through prompt fields. Additionally, I want to implement filtering based on the person number and set a default value for the person number as well. What steps should I take to develop this functionality?
Furthermore, I want to include a currency prompt that allows users to select between Local Currency and Corporate Currency. However, I'm currently seeing options for Ledger and Entered currencies and am unable to modify this to include Local Currency or Corporate Currency. How can I address this issue?