[Datamart-News] OBIEE filter tip

[WALLACE Aaron * DAS]

I wanted to pass along some helpful OBIEE filter information. The below info is used throughout the state and should help with your conversions.

If you want to create a 'not begins with' type of filter, in OBIEE, then it is recommended to use the 'is not like (pattern match)' filter operator. In addition, include '%' or '_' characters to provide greater detail.

The '%' symbol means 'any characters' and the underscore symbol means 'one character'.

Here is a well-used 'Cur Doc No' filter example.

[cid:image001.png at 01D82E08.687C43E0]

The '%' symbol is used, in this case, because the 'Cur Doc No' field is an eight character field. Therefore, the filter looks for data that starts with ZE, FS and GA, then ignores any characters after. If the underscore symbol was used it would look for only a three-digit character field and would bring back zero results.

Make sure to separate all values with a semicolon and not include spaces between values. In addition, the capitalization of ZE, FS, and GA are also important as this is the same format as the Database.

Good luck,
Aaron Wallace
Sr. Datamart Business Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20220302/80af5508/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 11703 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20220302/80af5508/attachment.png>