OLAPQuerySection object, OLAPCatalog object
Consists of the OLAP Query Measures collections. These collections correspond to measures in an OLAP Query section. These are columns added to the side and top labels groups in the outliner.
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") |
This example shows how to add a measure limit called “Units Plan”:
ActiveDocument.Sections["OLAPQuery"].Measures.Add(“Units Plan”)
Add(Measure As String), AddComputed(ColumnName as String, Expression as String), Item(Value As NameOrIndex) As OLAPLabel, ModifyComputed (ColumnName as String), Expression As String), RemoveAll(), ShowAll()