BI Journey

Column Filter Prompt is a prompt,it is used provide a general filtering of a column in a request. in other words it used to filter all the views in particular request.we can set all choice or constrained choice for a column.it can be combined with other column filter prompt. Adding a column filter prompt to report: step 1: select prompt tab in answers. step 2:in create filter prompt button,select column filter prompt step 3:Enter the caption and description step 4:select column name and filter step 5:select way in which user should choose values, drop down list or Browse through choices and/or type in directly step 6:select way values that should be shown to the user none:user must type values(not allowed with drop down) all values , limited values and sql results,limited choice is useful when prompting for multiple columns,it prevents a user from choosing values that would result in no data. step 7:...

Many of beginners still don't know what is the difference between filter and prompt.Here is a simple solution for them filter only filter a particular report but prompt is used filter a page or dashboard which contain one or more report. Now the Difference between global filter and dashboard prompt. global filters are also called saved filters,It can apply to multiple reports.Dashboard prompt is a special kind of filter that filters request that are embedded with the dashboard. Building Dashboard Prompt : Step 1: In Oracle BI Answers select new dashboard button in that select Subject area. Step 2:Select the scope of the dashboard,if we select scope as page then prompt will filter only reports in a particular page.scope is dashboard then it will filter all the reports that are present in that dashboard. step 3:select column and operator step 4:select control and constraints step 5:set defaults and set presentation variables if needed. step 6: create label step 7:save...