Get ID for String
In Oracle Hyperion Planning, when the account type is text, you can write a formula in Oracle Hyperion Calculation Manager to assign a text value.
Calculation Manager Syntax:
[[PlanningFunctions.getIdForString("text")]]
Example:
In Planning, you have an account named "acct1 text" that is of type text. You want to copy your values from FY16 Dec to FY17 Mar, and change the text account to "Not Budgeted."
FIX (Actual, Working, P_000, "210")
DATACOPY FY16->Dec TO FY17->Mar;
Mar("acct1 text"->FY17 = [[PlanningFunctions.getIdForString("Not Budgeted")]];)
ENDFIX