OLAPSlicers (Collection)

Member of:

OLAPQuerySection object

Description:

Consists of the OLAP Query Slicers (Collection). These collections correspond to the slicer within a OLAP Query section. This is the column added to the slicer in the outliner.

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: 1:

This example shows how to add a slicer that limits the scope to Oakland, California:

ActiveDocument.Sections["OLAPQuery"].Slicers.Add(‘ProductLocation.{hierachy}. Store Type’,’USA.California.Oakland’)

Example 2:

This example shows how to add a slicer that limits the scope to a company called Eastern Winds:

ActiveDocument.Sections["OLAPQuery"].Slicers.Add('Store Region.Region.Territory.Country.State.City.Name', 'Americas.North America.USA.New York.Manhattan.Eastern Winds New York')

Methods:

Add(LevelName As String, MemberName As String, Variable As Boolean) As OLAPSlicer, Item(Value As NameOrIndex) As OLAPSlicer, RemoveAll()

Properties:

Read-only: Property Count As Number

Read-Write: Property VariableSlicerMode as BqSlicerDisplayOptions

Methods and Properties Syntax:

ActiveDocument.Sections["OLAPQuery"].Slicers.Add(‘LevelName’,’UniqueName’)
ActiveDocument.Sections["OLAPQuery"].Slicers.Item()
ActiveDocument.Sections["OLAPQuery"].Slicers.RemoveAll()
ActiveDocument.Sections["OLAPQuery"].Slicers.Count
ActiveDocument.Sections["OLAPQuery"].Slicers[‘SlicerName’].Remove()