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.

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.

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

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.

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

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

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.

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.

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