Forum Discussion

WillVitale's avatar
WillVitale
Contributor
5 months ago

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
    5 months 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

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

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

Will