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
8 months ago

You can't. You have this strategy backwards: build your calculations as UD8s, then you can reference them from Cube View filters.

  • benmac360's avatar
    benmac360
    New Contributor III
    8 months ago

    OK, so if I change the XFBR to a UD8 calculation, would the member filter for my column where I'm summing the values of the entities with the text criteria be the UD8 plus the specific entity filter? For example, it would be U8#MyUD8Calc:E#TextEntities?

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      8 months ago

      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.