Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

LNum Element (XMLA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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