Skip to main content

%DeepSee.Query.memberData

Class %DeepSee.Query.memberData Extends %DeepSee.Query.member [ System = 3 ]

Specialized version of the member class used for data dimensions.

Methods​

%FindMemberByName​

Method %FindMemberByName(pName As %String, pDim As %Integer, pHier As %Integer, Output pFlag As %Boolean, pLevel As %Integer = "", Output pMemberKey As %String) As %Status [ Internal ]

See if there is a member with the given name within the specified dimension,hierarchy, and/or level.
If pLevel is supplied, only look in that level.
Set pFlag true if a member is found.
On return, fills in memberSpec
memberSpec(level) = $LB(name,key)

memberSpec(0) = $LB("All Time")
memberSpec(1) = $LB(2006,2006)
memberSpec(2) = $LB("Quarter 1", "Q1 2006")
memberSpec(3) = $LB("January","Jan 2006")

%FindMemberByKey​

Method %FindMemberByKey(pKey As %String, pDim As %Integer, pHier As %Integer, Output pFlag As %Boolean, Output pMemberValue As %String, pRecurse As %Boolean = 1) As %Status [ Internal ]

Find the member with the given key.

%GetMembers​

ClassMethod %GetMembers(pCubeName As %String, pDimNo As %Integer, pHierNo As %Integer, pLevelNo As %Integer, pRollupKey As %String, pParent As %Integer, pKey As %String, ByRef pNodeNo As %Integer, pRecurse As %Integer = 0, ByRef pRange As %String, ByRef pMemberList) As %Status

Get members and place them into pSet.

%GetRelatedMember​

ClassMethod %GetRelatedMember(pCubeName As %String, pDimNo As %Integer, pHierNo As %Integer, pLevelNo As %Integer, pRollupKey As %String, pParent As %Integer, Output pSet As %List, pKey As %String = "", pRelation As %String, pOffset As %Integer = 0, pValue As %String = "", pAllowMissing As %Integer = 0) As %Status [ Internal ]

Get one member and place it into pSet.
pKey, is the key for the base member to return. pRelation indicates how this member is related to the base member. "same","lead", "lag", etc.
pOffset, is an optional offset to apply to the relation.

%GetParentMember​

ClassMethod %GetParentMember(pCubeName As %String, pDimNo As %Integer, pHierNo As %Integer, pLevelNo As %Integer, pParent As %Integer, Output pSet As %List, pKey As %String) As %Status [ Internal ]

Get the parent of the current member and place it into pSet.

%GetNthChild​

ClassMethod %GetNthChild(pCubeName As %String, pDimNo As %Integer, pHierNo As %Integer, pLevelNo As %Integer, pParent As %Integer, Output pSet As %List, pKey As %String, pNumber As %Integer) As %Status [ Internal ]

Get the nth child of the current member and place it into pSet.

%GetPropertyValue​

ClassMethod %GetPropertyValue(pCubeName As %String, pDimNo As %Integer, pHierNo As %Integer, pLevelNo As %Integer, pProperty As %String, pParent As %Integer, Output pSet As %List, pKey As %String) As %Status [ Internal ]

Lookup the value of the given dimension property.

%GetMemberOffset​

Method %GetMemberOffset(Output pOffset As %Integer, pKey As %String, Output pParentKey As %String) As %Status [ Internal ]

Return the ordinal position of this member within its parent group. For convenience, also return the parent key for this member.