I am using Oracle Business Intelligence. For my analysis, I want to add a filter to it so that user can type in textfield and then the data related to input in textfield is displayed. Table prompts only suggest drop-down list, while column prompts do what I want but they appear before I see the analysis. I want to filter when I have the analysis on the screen.
While we did that kind of work in BI publisher using data models and reports, it was possible to run the report and give the parameters to get the desired data. How can I do this in the analysis? Is there something similar to parameters or list of values that are in BI Publisher?
Sure. That's normal prompt functionality. Just click on the column prompt options and choose to display the prompt as a free text field and allow user to enter their own values instead of choosing from the dropdown.