[Datamart-News] OBIEE features help (filters)

[Datamart Support * DAS]

OBIEE users,

I wanted to pass along some information that should be helpful when building filters in OBIEE.

OBIEE Feature demonstration: How to use 'not begins with' in a filter.

OBIEE (Option #1): To create a 'not begins with' in OBIEE, there are multiple options. First, you can use the "is not LIKE (pattern match)" with the % (multi-character) or _ (single character) symbol as a wildcard. This can be found in an 'Analysis' and within the filter window. The example below would create a filter that 'does not begin with 3'. This option would be the optimal choice for our Datamart setup.
[cid:image002.jpg at 01D76742.0B07C500]
Another option #1 example:
OBIEE: Current Doc Number does not begin with ZE or GA (Make sure to separate the two values with a semi-colon)
[cid:image001.png at 01D920DC.3CDC6130]

OBIEE (Option #2): You can alter the formula of a filter. Start by creating a filter that is opposite of what you want, for example, you create 'GL Acct begins with 3' when you desire 'GL Acct does not begin with 3'. Next, check the box for 'convert this filter to SQL' and click 'ok'. An 'advanced SQL filter' window will pop-up and you will add the word 'not' into the formula. (See example screen shots below)

[cid:image003.png at 01D7AEF0.C4FA48C0]   [cid:image005.png at 01D7AEF1.F9F6C750]    [cid:image007.jpg at 01D920E6.87C7B780]

Note: The 'is not like (pattern match)' filter works better than the 'does not contain' filter option.

If you have additional features that could be passed along, please send them to Datamart.Support at das.oregon.gov<mailto:Datamart.Support at das.oregon.gov>.

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230105/0d9058e2/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 7063 bytes
Desc: image002.jpg
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230105/0d9058e2/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5844 bytes
Desc: image003.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230105/0d9058e2/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 1835 bytes
Desc: image005.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230105/0d9058e2/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6576 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230105/0d9058e2/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 5876 bytes
Desc: image007.jpg
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230105/0d9058e2/attachment-0001.jpg>