Prompt to display user name after a rule is ran

Mar 13, 2024 4:05AM · Mar 13, 2024 4:05AM

Hi There,

I am trying to create a rule which will display the scenario, version, date and user name which the rule is ran for.

The section of the rule that does this:

FIX ("BegBalance", [[getStartYear({Tar_Sce})]], "AUD_Reporting", "AUD", "NZD", "No Entity", "No Activity code", "No Intercompany", "No Plan Element", "No Custom 1", "No Custom 2", {Tar_Ver})

{Tar_Sce} (

"Base Version Selected" = [[PlanningFunctions.getIdForString({SRC_Ver})]];

"Base Scenario Selected" = [[PlanningFunctions.getIdForString({SRC_Sce})]];

"Created On" = @DATEPART(@TODAY(), DP_YEAR) * 10000 + @DATEPART(@TODAY(), DP_MONTH) * 100 + @DATEPART(@TODAY(), DP_DAY);

"Created By" = {User_Name};

)

ENDFIX

Everything else returned as expected but the "Created by " account always returns 0 in smartview.

Prompt to display user name after a rule is ran

Howdy, Stranger!