Create a GetDataCell Calculation

GetDataCell expressions run a calculation directly in a cube view by referencing specific dimension members.

In the Member Filter Builder, use the Samples tab to create simple GetDataCell expressions.

Some common errors when developing GetDataCell expressions are:

  • Not having the correct dimension listed. Make sure to use the Member Filter Builder if you are not sure what to use.

  • Not having the correct number of parentheses. Make sure to use the correct number of opening and closing parentheses.

To add a row expression to a column in a cube view:

  1. In OneStream, go to Application > Presentation > Cube Views.

  2. Select a cube view group and then a cube view.

  3. Expand the Rows and Columns slider.

  4. To add a row to insert the CVC/CVR calculation, in Rows and Columns, click the plus sign.

  5. In Member Filters, rename the row.

  6. Click Member Filter Builder for the row to insert a calculation.

  7. Delete any existing content in the Member Filter field.

  8. Click Samples.

  9. Expand Column/Row Expressions.

  10. Click Sum of Rows (CVR). The GetDataCell syntax is generated and displays in Member Filter.

  11. Update the row names to add the rows together. Rename Row1 to Cash and Row2 to AR.

  12. Replace the name at the end of the expression to reflect the row name. The expression is complete.

  13. Click OK and then click Save.

  14. Click Open Data Explorer to run the cube view and verify the result.