MemberFromID

Gets the dimension member for the specified ID number. This function can be used in these types of rules:

  • Calculation

  • Translation

  • Consolidation

  • Allocation

Syntax

HS.<Object>.MemberFromID(ElementID)
HS.Custom(Dimension).MemberFromID(ElementID)

Table 12-36 Syntax for MemberFromID Function

Parameter Description

<Object>

One of these object keywords:

  • Account

  • Custom1...4

  • Custom (Custom Dimension Label)

  • Entity

  • ICP

  • Parent

  • Period

  • Scenario

  • Value

  • Year

  • View

Parent

A valid Parent member.

ElementID

Depending on the object selected, the ID number of a valid member of one of these dimensions:

  • Account

  • Custom1...4

  • Custom

  • Entity

  • ICP

  • Parent

  • Period

  • Scenario

  • Value

  • Year

Return Value

The dimension member name.

Example

This example gets the member for the ID number 001:

strEntity = HS.Entity.MemberFromID(001)
strCustom = HS.Custom("Prod").MemberFromID(001)