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

How to return text values from a Business Rule (without using Smart Lists)?

edited Nov 17, 2025 3:49AM in Planning 2 comments

Hi everyone,

I’m trying to write a Groovy Business Rule in Planning (EPBCS) that returns or assigns a text value to a member.

The requirement is to store a text string (for example, a JSON log or timestamp like "202511150830|user").


I do not want to use Smart Lists, because the value must be free-text and dynamically generated.

However, it seems that:

  • Calculation scripts can only assign numeric values
  • Text assignments like "ABC" Or functions that return strings cause a type error
  • @CalcMgrConcat () and similar text functions also return a string, but cannot be assigned to a normal member
  • Regular members (Numeric data type) reject any text

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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