![olap cube excel mac olap cube excel mac](https://scch.co.in/Uploads/Cancer/CancerDetail/Service-cancer-desc-44801886.png)
IncludeNewItemsInFilter the IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables.
![olap cube excel mac olap cube excel mac](https://etl-tools.info/images/olap-cube-summarized-fields.jpg)
HierarchizeDistinct returns or sets whether to order and remove duplicates when displaying the specified named set in a PivotTable report based on an OLAP cube.
![olap cube excel mac olap cube excel mac](https://thuthuat.taimienphi.vn/cf/Images/tt/2021/9/1/ham-cubememberproperty-trong-excel-31.jpg)
HasMemberProperties returns True when there are member properties specified to be displayed for the cube field. The default value is False.įlattenHierarchies returns or sets whether items from all levels of hierarchies in a named set cube field are displayed in the same field of a PivotTable report based on an OLAP cube. The default value is True.ĮnableMultiplePageItems set to True to allow multiple items in the page field area for OLAP PivotTables to be selected. The default value is True.ĭragToRow true if the field can be dragged to the row position. The default value is True.ĭragToPage true if the field can be dragged to the page position. The default value is True.ĭragToHide true if the field can be hidden by being dragged off the PivotTable report. The default value is True.ĭragToData true if the specified field can be dragged to the data position. Can be one of the XlCubeFieldType constants.ĬurrentPageName returns or sets the page name for a CubeField.ĭragToColumn true if the specified field can be dragged to the column position.
#Olap cube excel mac manual#
Dim cbf As CubeFieldĪddMemberPropertyField - Adds a member property field to the display for the cube field.ĪutoGroup - Automatically groups the cube fields in an OLAP cube, optionally in the specified orientation and/or at the specified position.ĬlearManualFilter - The ClearManualFilter method provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList/VisibleItemsList collections in OLAP PivotTables.ĬreatePivotFields - The CreatePivotFields method enables users to apply a filter to PivotFields not yet added to the PivotTable by creating the corresponding PivotField object.ĪllItemsVisible the AllItemsVisible property checks whether manual filtering is applied to a PivotField or CubeField.Ĭaption returns a String value that represents the label text for the cube field.ĬubeFieldSubType specifies the type of a CubeField.ĬubeFieldType indicates whether the OLAP cube field is a hierarchy field or a measure field. Here is an example of processing the CubeField items in a collection. The following procedures can be used to set variables of type CubeField: CubeFields.AddSet, CubeFields.GetMeasure, CubeFields.Item, PivotField.CubeField and PivotFilter.DataCubeField. To use a CubeField class variable it first needs to be instantiated, for example Dim cbf as CubeField In a PivotTable report, the CubeField object is a member of the CubeFields collection. The class CubeField represents a hierarchy or measure field from an OLAP cube.