Using RDB Formulas

Instead of using multiple output cells, you can extend a hyperblock and enter separate RDB formulas in each of the cells created.
Note: DataLink lists do not support RDB formulas. For DataLink lists, use multiple output cells or formula lists.

See Formula lists.

RDB formulas cannot be used unless at least one hyperblock is linked to a relational list on the worksheet.

You can create RDB formulas in cells outside the hyperblock as well as inside. When created inside a hyperblock, the row index in the RDB formula is the cell reference of the key output cell of the hyperblock. This dynamically references the row index and inserts the corresponding data field for each data record.

When created outside a hyperblock, only one value results from the RDB formula. In this case, you must use a specific row number as the row index. For example:
=RDB(HYPERBLOCK("Hyperblock3");1;"column_name")

To use separate RDB formulas instead of multiple output cells.

  1. Extend the hyperblock that contains the relational selection. Click in the cell that is to contain the additional column of the relational table.
  2. Click Edit OLAP Formula and select Relational Values in the Formula type list.
  3. From the Column list in the Database section, select the next column of the table to display in the hyperblock. The data formula is displayed in the OLAP Server Formula section.
  4. Repeat these steps for each column of the table to be displayed in the hyperblock.
    Note: In Design Mode .#VALUE is displayed in the cells. But, in Debug Mode or View Mode, the correct values are displayed.