RDB

This function returns values from a relational list that has been created with a SQL query.

Syntax

=RDB(HYPERBLOCK("hyperblock_name"),row_index,"column_title")

Using RDB

The contents of relational databases are displayed on the spreadsheet using hyperblocks and SQL queries.

Drag a relational list from the Database Structure to create a hyperblock. Select the value cell and open the Edit OLAP Formula dialog. Select Relational Values as the formula type.

In the Database section, select the table and column of the relational database. The RDB formula is displayed in the OLAP formula field.

Note: Only data fields selected in the SQL query can be displayed by the RDB formula.