Business Rule - Assign text value using rules in cloud (e)pbcs

Hello,

Lets consider the following example;

FIX(FY18, Actual, Jan, Entity_NA)
"Sales" = 100;
ENDFIX

Now if we execute this script, it will assign the value 100 to Sales. Suppose we change the below script (assuming "Sales Description" is text member)

FIX(FY18, Actual, Jan, Entity_NA)
"Sales" = 100;
"Sales Description" = "2018 actual sales for Jan"
ENDFIX

The above script gives an error. What if we want to assign text value? Thats when Planning formula expression comes to help Get ID for String .

FIX(FY18, Actual, Jan, Entity_NA)
"Sales" = 100;
"Sales Description" = [[PlanningFunctions.getIdForString("2018 actual sales for Jan")]]
ENDFIX

Currently it works only on cloud, although it is available for 11.1.2.4 on premises.

You can even pass the run time prompt;

FIX({vYear}, Actual, Jan, Entity_NA)
"Sales" = 100;
"Sales Year" = [[PlanningFunctions.getIdForString({vYear})]]
ENDFIX

It will give error "expression expected after []" which can be ignored, once executed from data form or planning rules it will populate the selected year in the member "Sales Year"

Unfortunately, right now it works only with hard coded text or run time prompt, any dynamic text value like @CONCATENATE("2018", "Sales") doesn't work

Hope you like this :)