Components of GetDataCell

A GetDataCell expression is the performance section of a dynamic calculation. It tells the dynamic calculation what it will be doing. The following example shows a common GetDataCell expression. GetDataCell expressions are simpler versions of dynamic calculations.

Return api.Data.GetDataCell("Divide(A#CurrentAssets,A#CurrentLiabilities)")

  • Return api.Data: Tells OneStream which results to display.

    NOTE: This is not required for GetDataCell expressions, but it is required for dynamic calculations.

  • GetDataCell: Performs the calculation.

  • ("Divide(A#CurrentAssets,A#CurrentLiabilities): Math syntax in a string format to calculate.

You can use the Samples tab to create simple GetDataCell expressions in your cube view.