Syntax Guidelines

Use the following guidelines to enter parameters for functions.

See Function Descriptions for the syntax of individual functions.

• The connection parameter is the user-defined name for a connection.

  The connection parameter must precede the POV.

• The POV is composed of dimension#member pairs, for example:

  Entity#Connecticut

• Parent-child relationships are designated by a period, (.); for example:

  Entity#UnitedStates.Maine

• The connection and each POV dimension#member pair can be split into separate function parameters, each parameter enclosed in quotation marks, ("), and separated by a comma, (,); for example:

  "MyVision","Entity#UnitedStates","Account#Sales"

  The use of semicolons (;) as the dimension#member parameter separator is not supported.

• If a POV dimension#member is not specified, then Smart View adds the top level member of that dimension to the function. For example, in the following HsGetValue function, there is no Period dimension and member specified:

  =HsGetValue("MyVision","Account#Amount","Years#2017","Scenario#Annual, Contract","Version#Final","Entity#AR02-Argentina-,IS_Adjustments","Package#Depreciation","Currency#Local Currency")

  In this case, Smart View will add the top-level Period member, which is Period, to the function, Period#Period. For example:

  =HsGetValue("MyVision","Account#Amount","Period#Period","Years#2017","Scenario#Annual Contract","Version#Final","Entity#AR02-Argentina-IS_Adjustments","Package#Depreciation","Currency#Local Currency")

• Do not mix a dimension name and its aliases in functions. However, for members, you can either use the member name or its alias from the selected alias table.