Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

StrValue

Use this function to retrieve a string value from a data intersection and store it to another data intersection, or a string variable. This function will only return a string value for a DataArea if the user has access to that DataArea.

Note: This function will only return string data. If the intersection contains a numeric value, then the function will return an empty string ("").

Syntax:

STRVALUE (""|"DataAreaName1", "Dim1Set", "Dim2Set", …, "Dim7Set")

where:

  • "" is used in a model to reference the same data area that the model is executed against.
  • DataAreaName is the name of the DataArea in which the symbols are found, and must be used in a procedure.
  • DimNSet is the name of a symbol for each dimension in your system.

Note: Symbol names must be enclosed in double quotation marks.

Syntax example:

SALEST### = STRVALUE ("DataArea1", "CASHT###", "Dim2Set", …, "Dim7Set")

SALEST### = STRVALUE ("", "CASHT###", "Dim2Set", …, "Dim7Set")

SET VARIABLE myString = STRVALUE ("DataArea1", "CASHT", "Dim2Set", …, "Dim7Set")
Published:

StrValue

Use this function to retrieve a string value from a data intersection and store it to another data intersection, or a string variable. This function will only return a string value for a DataArea if the user has access to that DataArea.

Note: This function will only return string data. If the intersection contains a numeric value, then the function will return an empty string ("").

Syntax:

STRVALUE (""|"DataAreaName1", "Dim1Set", "Dim2Set", …, "Dim7Set")

where:

  • "" is used in a model to reference the same data area that the model is executed against.
  • DataAreaName is the name of the DataArea in which the symbols are found, and must be used in a procedure.
  • DimNSet is the name of a symbol for each dimension in your system.

Note: Symbol names must be enclosed in double quotation marks.

Syntax example:

SALEST### = STRVALUE ("DataArea1", "CASHT###", "Dim2Set", …, "Dim7Set")

SALEST### = STRVALUE ("", "CASHT###", "Dim2Set", …, "Dim7Set")

SET VARIABLE myString = STRVALUE ("DataArea1", "CASHT", "Dim2Set", …, "Dim7Set")
For an optimal Community experience, Please view on Desktop