Forum Discussion

benmac360's avatar
benmac360
New Contributor III
9 months ago

Pass Results from Business Rule into UD8 Formula

Hi - I have a dashboard XFBR business rule that calculates totals for members with a specific text value in a cube view. The rule is working as designed, and I have a couple GetDataCell functions in ...
Finance
XFBR
JackLacava's avatar
JackLacava
Honored Contributor

I believe that would depend on how the rule is written.

I would suggest to keep it simple: write a simple UD8 to calculate things for one entity. You can then see how it looks like on the CV, and in the worst case perform sums on the CV itself with GetDataCell.

benmac360's avatar
benmac360
New Contributor III
8 months ago

Thanks Jack - I appreciate the help so far. Now that I have the calculations for the entity, how would I pass or reference the calculation to the other UD8 to produce the Y or N? The variance UD8 is supposed to check if the absolute value of one column exceeds the absolute value of another - if it does, its supposed to return a Y.

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    8 months ago

    With your original UD8 😊 since you can now easily pull up with api.Data.GetDataCell the values of the intersections generated by the new UD8s. They are just cube data now!