LOOKUP

The LOOKUP function can look up values from an Infobridge query and load them inside an Inforiver visual. It can fetch measure values directly from Infobridge without creating an integration and importing measures/rows into your report.  

Syntax

LOOKUP(queryIdentifier:string,measure:string,rows:[string],columns:[string])
//fetches data from the specified query and measure

Arguments

queryIdentifier - String. Required. It is used to identify the query from which data has to be fetched.

Copy the query GUID from Infobridge

key- String. Required. It specifies the key whose value is to be extracted.

rows - Array. Optional. Specify specific row dimension category values or use dimension names.

columns- Array. Optional. Specify specific column dimension category values or use dimension names.

Examples

Example 1: Refer to a specific row and column and fetch the measure value from Infobridge.

The bridge contains the quarterly rebate rates for a set of products.

Bridge to lookup measure values

In the target visual, we can pull the rebate rate for the "Velo" product for Q4 using the LOOKUP function as shown.

LOOKUP function for specific row and column dimension categories

Example 2: Fetch values when the row and column dimensions are the same in the bridge and the target visual.

The bridge contains the country-wise rebate rates for a set of products.

Bridge to lookup measure values

In the target visual, we can pull the rebate rate without specifying the rows and columns. They are automatically mapped within Inforiver.

LOOKUP function when the row and column dimensions match in the bridge and target visual

You can use the ROW/COLUMN identifiers when the row and column dimensions in the bridge and identical to the target visual.

Using the ROW and COLUMN identifiers

Example 2: Fetch values when the row and column dimensions in the bridge and the target visual are not identical.

The bridge contains a flat discount rate for product categories.

Bridge to lookup measure values

In the target visual, we can pull the discount rate although the the bridge does not contain column dimensions and the row dimension hierarchy is different.

Lookup when dimensions do not match

You can also fetch values from a bridge and map them to a visual column.