Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
LNum Element
Collapse the table of content
Expand the table of content

LNum Element (XMLA)

 

Applies To: SQL Server 2016 Preview

Contains information about level ordinal positions for the parent HierarchyInfo or Member element.


<HierarchyInfo> <!-- or Member -->
   ...
   <LNum>...</LNum>
   ...
</HierarchyInfo>

Characteristic

Description

Data type and length

int

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Relationship

Element

Parent elements

HierarchyInfo, Member

Child elements

None

For HierarchyInfo elements, the LNum element contains the name of the property that provides the level ordinal positions of the hierarchy. The value is equivalent to the LEVEL_NUMBER property defined for axis rowsets in the OLE DB for OLAP specification.

For Member elements, the LNum element contains the zero-based ordinal position, from the root level of the hierarchy, of the member represented by the parent Member element. A value of zero represents the root level of the hierarchy.

Community Additions

ADD
Show:
© 2015 Microsoft