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.
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 slicer that limits the scope to Oakland, California:
ActiveDocument.Sections["OLAPQuery"].Slicers.Add(‘ProductLocation.{hierachy}. Store Type’,’USA.California.Oakland’)
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')
Add(LevelName As String, MemberName As String, Variable As Boolean) As OLAPSlicer, Item(Value As NameOrIndex) As OLAPSlicer, RemoveAll()
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()