Forum Discussion

WillVitale's avatar
WillVitale
Contributor
2 years ago
Solved

Dynamic Formula Name within a Cube View

Hello, I was wondering if it's possible to have a formulas name changed based on what entity it is on? Currently I have a formula that adds up the intercos of a specific account but when I overwrit...
Cube View
Reports
  • WillVitale's avatar
    WillVitale
    2 years ago

    I was able to solve it by changing the name on the level 1 filter using the |MFEntityDesc| substitution variable. 

    Will

WillVitale's avatar
WillVitale
Contributor
2 years ago

Hi Carlos,

Yes, I was thinking of making another UD8, but my row definition is currently using a UD8 in the Row definition to pull the sums of these specific interco partners, so I don't think I can use 2 UD8s in the same member filter?

 

CarlosAlvear's avatar
CarlosAlvear
Contributor II
2 years ago

Hi Will,

Actually, you can. You'd have to change the U8# call in the row and move it to the columns. For instance, in the 1st column you'd use the new UD8 dynamic member (this is only to write the text as you want), and then in all the remaining columns you can use the current U8#CFC_IC member.

Regards,

Carlos

  • WillVitale's avatar
    WillVitale
    Contributor
    2 years ago

    Hi Carlos,

    It wouldn't work out if I put my CFC_IC UD8 in the columns. The data just doesn't work that way. Can I make an XFBR or something to use as a parameter that could pick up the 

    return "Sum: " & api.Pov.Entity.Name

    you suggested?

    Will

    • WillVitale's avatar
      WillVitale
      Contributor
      2 years ago

      I was able to solve it by changing the name on the level 1 filter using the |MFEntityDesc| substitution variable. 

      Will