Creating Database Send (DBS) Formulas

You can create DBS formulas that send numeric data values to the cube because:

  • You converted codes that map to elements in the Actvsbud dimension.
  • You converted codes that map to elements in the Region dimension.
  • You mapped multiple data values to their appropriate months.

Insert the DBS formulas in a row beneath the rows containing the data and mapping instructions. Do not insert them in the first row because they will be overwritten as TM1 reads in records into the processing worksheet.

Procedure

  1. Click cell D4, an empty cell that will store the first DBS formula.
  2. Click TM1 > Edit Formula.

    The Edit Formula bar opens.

  3. Click DB Send.

    TM1 prompts you to select the value to be sent to the cube.

  4. Double-click cell D1, which contains the Jan cell value.

    TM1 prompts you to select the type of cell reference.

  5. Click Column Rel.

    The DBS formula always references row 1, but the column reference will be relative to the location of the formula.

    TM1 prompts you to indicate the type of data in the cell.

  6. Click Numeric.

    The Select Cube dialog box prompts you to select the cube to be populated.

  7. Click Pick.

    A different Select Cube dialog box opens.

  8. Select the local:SalesCube cube and click OK.

    The Edit Reference to Cube dialog box displays with most of the mapping instructions for the value (cell D1) to be sent to the cube.

    Cell A3 supplies an element in the Actvsbud dimension.

    • Cell B1 supplies an element in the Region dimension.
    • Cell C1 supplies an element in the Model dimension.
    • Cell D3 supplies an element in the Month dimension.

    To complete the mapping, you must identify an element for the Account1 dimension. Price.cma contains price values, so all DBS formulas should map to the price element.

  9. Click account1.

    The Subset Editor opens.

  10. Select Price and click OK.

    The account1 field of the Edit Reference to Cube dialog box now displays Picked.

  11. Click OK.

    The Edit Formula bar displays the generated DBS function:

    DBS(D$1,"local:SalesCube",$A$3,$B$3,$C$1,"Price",D$3)

    For a full explanation of the formula, see DBS Syntax.

  12. Click OK to place this formula in the processing worksheet.
  13. Copy the formula in D3 to the range E3:O3.
  14. Save the PriceProcessing worksheet.