O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filter types and creating the filters

When we create any analysis in OBI, the query will be generated by the BI Server and executed against the database. Regarding the selected columns, all rows will be retrieved. End users should only see the data that they are interested in. So we're going to create the filters in the analyses to eliminate some rows from the result set.

We're going to create another sample analysis that includes the following columns:

  • The Region attribute column
  • The State attribute column
  • The Units Ordered measure column
  • The Units Shipped measure column

How to do it...

  1. We're going to click on the more options icon next to the Region column to access the menu list in the Criteria tab. Select the Filter menu item from the list.
  2. The

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required