OLAPValues (Collection)

Member of:

OLAPLevelOrHierarchy object

Description:

Represents the content values in a dimension.

Tip:

All collections have the “Item(NameOrIndex)” method. This is the default method for all collections that returns collection items at a particular index or by name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements are identical: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy")

Example:

This example shows how to count values in dimensions:

Alert(ActiveDocument.Sections["OLAPQuery"].Catalog.Dimensions["Location"]["Values"].Count)

Methods:

Item(Value NameOrIndex)

Properties:

Read-only: Property Count As Number,