OTBI - Filters Vs. Selection Steps

 OTBI - Filters Vs. Selection Steps

Hi Everyone,

This is a small post explaining differences between Selection steps and Filters in OTBI Reports.

OTBI stands for Oracle Transactional Business Intelligence, an analysis tool and low code approach to develop reports for real time data.

It provides us with numerous options, today we will discuss one of those:

Filters:

Filters are used to limit data based on the requirement like we want to see particular item data or particular state and so on..

We can compare Filter to Where Clause so first filters are considered then query will be fired.

Selection Steps:

Selection Steps are different from Filters.

We can compare Selection Steps to Having Clause.

They affect only field but not values.

And Selection steps can be applied to Dimensional Data like Attributes, Hierarchical Columns, Groups and Calculations but not Measures.

Data appear in the order they are selected in Selection List.