Forum Discussion

RehaanAbdulla's avatar
RehaanAbdulla
New Contributor III
3 months ago

Writing a value to a cubeview cell

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

Regards

 

Cube View
Parameters
  • Henning's avatar
    Henning
    Valued Contributor II
    3 months ago

    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.