OLAPLevelOrHierarchyNew (Collection)

Member of:

OLAPDimensionNew collection

Description:

Represents a collection of members at the selected dimension level in a CubeQuery.

The Count property of the collection reads the number of members in this level of this dimension. If the number of members is greater than the value of the CatalogDisplayMembers (Property), then only CatalogDisplayMembers are put into the collection and the value returned by the Count property is the same as the value of CatalogDisplayMembers (Property).

Example 1:

This example shows how to display the number of members in the “Year” dimension:

Alert(ActiveDocument.Sections["Query"].Catalog.Dimensions["Year"].Count)

Example 2:

This example shows how to count the number of members and return them to the Item (Method):

duct"]["Colas"];
if (opts.CatalogDisplayMembers == products.Count) {
    // There may be more members at level 2 of the dimesion
    // than will be returned by the Item method. To get access
    // to all of them set CatalogDisplayMembers to 0.
}
y the Count property is the same as the value of EssbaseSpecific.CatalogDisplayMembers.

Examples

Example 3:

This example shows how to return the name of the dimension:

var products = Sections["Query"].Catalog.Dimensions["Product"]["100"];
for (var i = 1; i <= products.Count; i++) {
    Console.Writeln(products[i].Name);
    Console.Writeln(products.Item(i).UniqueName);
    Console.Writeln(products.Item(i).ParentName);
}

Methods:

OLAPLevelOrHierarchyNew value as Name or Index.

Properties:

Read only: AttributeDimension as Boolean, Count as Number, Name as String, UniqueName as String