Forum Discussion

emclend's avatar
emclend
New Contributor
8 days ago

Calculate based on Text4 field

Hello,

We are creating a cube view where the columns are dynamically filtered by the text fields of Entity and UD1.  I am fairly confident in building a business rule to return the correct result, but I am uncertain of how to then present that in a "totals" column within the cube view.

  1. What type of business rule should I use for this?
  2. Once I create the business rule to calculate the value, how do I get it to display in a cube view column? (extender rule, dynamic calc, etc.)

Any help or guidance on this would be much appreciated.

Cube View
Reports

1 Reply

  • carbon's avatar
    carbon
    New Contributor III
    7 days ago
    Dim TextPull As String = BRApi.Finance.Entity.Text(si, entityID, 7, Nothing, Nothing)

    I'm not sure how to answer the rest due to limited experience and knowledge, but this atleast pulls the text field from each member. In this case its entity dimension and text field 7. I have this encased in a FOR EACH loop to run through each entity member.

    I would think you will use a cube view extender and reference that in your CV.