Edit Reference to Cube Dialog Box

This dialog box lets you set the element references used in TM1® worksheet functions such as DBRW and DBSW.

The dialog box contains buttons and fields corresponding to each dimension in the cube that the TM1 worksheet function references. For example, the following image shows the Edit Reference to Cube dialog box for a DBRW function that references the SalesCube cube in the TM1 sample database. The dialog box includes buttons for all the dimensions in the SalesCube cube.

When you insert a TM1 function into a worksheet, TM1 attempts to determine if any relevant element references exist in the worksheet. If so, those references are automatically inserted into the appropriate fields on the Edit Reference to Cube dialog box. If relevant element references cannot be determined, TM1 inserts "Undef" in the fields.

You can set references in this dialog box by either:

clicking a dimension button and selecting an element. In this case, the reference is inserted as a string into the appropriate field.
entering a cell reference directly in a field. You can use row-relative, column-relative, or absolute cell references.

If the cube for which you are creating a reference contains more than 16 dimensions, click Previous to page backward to the previous 16 dimensions, or click Next to page forward to the next 16 dimensions.