Oracle Business Intelligence 11g - How To Limit Data In Your Analyses? Part II

I’m going to demonstrate how to use prompts in an analysis in order to limit data. After I create the analysis, I check the result. , click the “Prompt” tab create 3 column prompts.  As a result end users are going to select the values from the dropdown list eliminate the records based on the user selections. In the first dropdown list, they will select the “Company” , “Organization” at last “Department”.

The last example is about the selections. So I create a report with 4 columns gr totals. 

I exp the selection steps section to edit the selections. edit the selections.  I select the “Start with selected members” from the actions dropdown list add two departments. You’ll see that the gr total is changed.

In the last example I’m going to show you how to use remove action in the selections. It starts with all members remove one member in the second step. As a result the selections are applied after the aggregation the gr total isn’t changed.