Skip to main content
Contributor
February 7, 2025
Solved

Dynamic Column Headers in the PLPRegister

  • February 7, 2025
  • 2 replies
  • 0 views

Hello All,

Anyone know if it is possible to pass a parameter value into the PLP Register?  I have a method query returning a value based on scenario & year and need that to be the column header in the register.  This is more of a POC than a hard requirement at this point.

Any creative suggestions are welcome.

 

Best answer by victortei

This can only be handled through custom coding. You’ll likely need to modify the function called from the SQL Table Editor:

Function: GetColFmt in PLP_ParamHelper

Function: GetColFormat in PLP_SolutionHelper

From there, you can plug in your code and return the desired result depending on the current Scenario & Year.

PS: I currently don’t have access to any recent PLP deployments, so I’m not sure if the functions are the same in the newer versions

 

2 replies

victorteiAnswer
Newcomer
February 8, 2025

This can only be handled through custom coding. You’ll likely need to modify the function called from the SQL Table Editor:

Function: GetColFmt in PLP_ParamHelper

Function: GetColFormat in PLP_SolutionHelper

From there, you can plug in your code and return the desired result depending on the current Scenario & Year.

PS: I currently don’t have access to any recent PLP deployments, so I’m not sure if the functions are the same in the newer versions

 

SWilyumsAuthor
Contributor
February 8, 2025

Hello Victor, I will get test this next week and circle back.  Thank you for your help.

SWilyumsAuthor
Contributor
February 13, 2025

You pointed me in the right direction.  Thank you.