You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Prompt to display user name after a rule is ran

Received Response
edited Mar 13, 2024 5:32AM in Planning 2 comments

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};



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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!