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.

Copy

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.

Copy

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.

Copy

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.

Copy

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