Skip to main content
W
WillVitale
March 11, 2025

Dynamic Substitution Variable

  • March 11, 2025
  • 1 reply
  • 0 views

Hello,

I'm working on writing a budget report for my company and we have these summary accounts that all start with "S_" and the parent name (i.e. ExtSales would be S_ExtSales). Is there a way I can use substitution variable on my column override, where I wouldn't have to go in and change every line to update the override?

Thanks,

Will

1 reply

J
JimmyReaves
March 11, 2025

Hard to say without seeing the cubeview, but you could try something like X#MyMember.Descendants.Where((Name Startswith S_) and (Name Contains |PovParent|))

W
WillVitaleAuthor
March 11, 2025

Hey Jimmy,

It's a pretty basic cube view on the row side. Just a UD1 and Account on the rows

Right now I just hard coded all the overrides, but just wanted to see if there's a quicker dynamic way into doing this.

 

Thanks,

Will

T
T_Kress
March 12, 2025

You could consider a dynamic U8 to possible transform the account name, perhaps something like the below.  Then use that U8# on the rows or columns as required.

Dim AccountName As String = api.Pov.Account.Name

Return api.Data.GetDataCell("A#S_" & AccountName& ":U8#None")

 

Terms & ConditionsAccessibility statement