The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

BCG's avatar
BCG
New Contributor II
3 years ago

Unable to populate the results into the destination intersection using GetDataBufferUsingFormula

Hi All, I have written below rule where, I am not able to see the results, But rule is executed without any errors. Rule is about : Writing up the source values based on the Tex1 and Tex2 assigne...
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

I'd make sure your source databuffer is not empty, try logging that.

  • BCG's avatar
    BCG
    New Contributor II
    3 years ago

    Thank you JackLacav for swift reply. i can see this error

    • JackLacava's avatar
      JackLacava
      Icon for OneStream Employee rankOneStream Employee
      3 years ago

      you're filtering on View, which means the view id gets set to common, and then you never set a new one.

    • MarcusH's avatar
      MarcusH
      Valued Contributor
      3 years ago

      This message usually means that the dimension member in the data buffer is XFCOMMON rather than the actual member name. The LogDataBuffer call you have will show the values that are being saved. If you have XFCommon in any dimension you will need to update the DataBufferCellPk with the correct value.

      On another note I don't think <> vbnullstring is working as you expect. I think it is actually looking for the string vbnullstring rather than an empty value. It will work because I guess you don't have the text vbnullstring in your Text1 and Text2 fields but it will also bring back members where Text1 and Text2 are blank. I would change vbnullstring to '' (2 single quotes). I am not 100% about whether the single quote character works - I know it's not necessary, I just don't know if it must not be used.