Bloomberg Entitlements Filter

This page explains how row level entitlements work in the Bloomberg accelerator.

To ensure that query results only include rows a user is permitted to see, the Bloomberg Entitlements Accelerator provides filter functions. When row level entitlements are configured and a query is executed, either through the UI or API, the active filter function is applied to restrict the results accordingly.

Enabling row level entitlements

To enable row level filtering of query results the feature needs to be configured using the command line interface of Insights Enterprise.

Row level entitlements can be configured as part of setting up the data entitlements for an assembly.

Refer to row level entitlements for detailed steps on how to enable them. In this case, row level entitlements should be enabled on the fsi-app-bbg-entl assembly.

There are two filter functions supplied in the Bloomberg Entitlements Accelerator, .bbgEnt.dataFilter and .bbgEnt.todayDataFilter.

• .bbgEnt.dataFilter - filters all data based on the values of the EID column the user has permission to.

• .bbgEnt.todayDataFilter - filters data from today based on the values of the EID column the user has permission to. Data from previous days is unrestricted.

.bbgEnt.dataFilter can be applied to any table with an EID column. .bbgEnt.todayDataFilter can be applied to any table with both an EID and eventTimestamp column.

At this stage of enabling row level entitlements, either can be applied as a row policy on a table.

Adding additional policies

Additional policies can be created and applied in addition to, or instead of, the supplied examples. Read more on how to define and apply row policies. The example filter functions in the Bloomberg Entitlements Accelerator can be viewed in the fsi-app-bbg-entl/src/bbgEnt.da.q file.