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

GetOpenPeriod

Use this function to return the open period symbol for the year. The function determines the root symbol for the symbol designated by either the SGPTimePerActivity or SGPTimePerYTD attributes, and then returns the symbol whose attribute ZFXTimePerOpenList contains that root symbol. If an open period cannot be found, the function returns a blank.

For more information on attributes, see the Longview Application Administrator Guide.

Syntax

GETOPENPERIOD(SymName)

where:

  • SymName is the name of a symbol in the time periods dimension. The symbol must be a descendent of a symbol specified in either the SGPTimePerActivity or SGPTimePerYTD attributes.

    Note: GetOpenPeriod returns an error message if the user does not have access to that particular symbol.

Syntax example

CREATE VARIABLE X AS STRING

SET VARIABLE X = GetOpenPeriod(A0503)

Published:

GetOpenPeriod

Use this function to return the open period symbol for the year. The function determines the root symbol for the symbol designated by either the SGPTimePerActivity or SGPTimePerYTD attributes, and then returns the symbol whose attribute ZFXTimePerOpenList contains that root symbol. If an open period cannot be found, the function returns a blank.

For more information on attributes, see the Longview Application Administrator Guide.

Syntax

GETOPENPERIOD(SymName)

where:

  • SymName is the name of a symbol in the time periods dimension. The symbol must be a descendent of a symbol specified in either the SGPTimePerActivity or SGPTimePerYTD attributes.

    Note: GetOpenPeriod returns an error message if the user does not have access to that particular symbol.

Syntax example

CREATE VARIABLE X AS STRING

SET VARIABLE X = GetOpenPeriod(A0503)

For an optimal Community experience, Please view on Desktop