HierarchyCaption (PQL)

Returns the caption of the target or source member's hierarchy used in a cross-model interaction

  • Returned Output: Text
  • Library: PQL \ Action \ Cross-Model
  • Version: 2018.00.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

HierarchyCaption()

Comments
  • The function returns the caption of the designated member object's hierarchy or column in the interaction.
  • The function can only be used together with the SourceMember and TargetMember functions.

Examples

The example below shows how to get the caption of the source member's hierarchy in an interaction to be used in the mapping formula. If the source member was "[Customer].[Country].[Australia]" , the formula would return "Country"

sourceMember().HierarchyCaption()

For a more complete example, please see member captions.