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.