Skip to main content
R
RehaanAbdulla
November 6, 2024

Writing a value to a cubeview cell

  • November 6, 2024
  • 1 reply
  • 1 view

Hi 

I have a form and there is a balance sheet account, total input and validation columns. The condition is to check if the balance sheet account value has a value and total input has no value, if balance sheet account is 0 and total input has a value and total input is greater than balance sheet then validation should be 0. 

If balance sheet is greater  then total input then validation is 1. 

This validation is stored in a member formula and I was wondering how can I get the validation column to show 1 or 0 based on the condition

I have tried the SetDataCell() first but found out that on a member formula that does not work, which other function can be used. Your assistance will be greatly appreciated


RehaanAbdulla_0-1730902663150.png

Regards

 

1 reply

H
Henning
November 7, 2024

Hi,

first of all, why does it need to be a stored account? Using this for validations pushes data into the database, usually unnecessarily.

Confirmation rules is where validations take place in OneStream, via the workflow. If one wishes to see some validations in a cube view, I tend to recommend dynamic accounts / members. You can also use the annotation member for those, displaying a "fail" or "pass" text instead of a "1".

If you want to go down the route of storing the result, refer e.g. to case 4 of the example given in the documentation:

Avoiding Data Explosion

api.Data.Calculate(“A#MyAccount:F#None:O#Import:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None = 1”)

Make sure to specify each dimension in the target (left hand side of the equal sign) and do not use "All" in order to avoid unwanted data explosion.

Terms & ConditionsAccessibility statement