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:
Units Orderedmeasure column
Units Shippedmeasure column
Regioncolumn to access the menu list in the Criteria tab. Select the Filter menu item from the list.