Pivot Class Reference

This persistent class represents a saved DeepSee pivot table. More...

Inheritance diagram for Pivot:

Collaboration diagram for Pivot:

Public Attributes
	autoExecute
	pivotTable autoExecute flag. More...
	backgroundImage
	Optional image to show in background of pivot table. More...
	backgroundOpacity
	Opacity (0 to 1) of pivot table background image. More...
	borderBottomCell
	More...
	borderBottomCol
	More...
	borderBottomRow
	More...
	borderLeftCell
	Table borders. More...
	borderLeftCol
	More...
	borderLeftRow
	More...
	borderRightCell
	More...
	borderRightCol
	More...
	borderRightRow
	More...
	borderTopCell
	More...
	borderTopCol
	More...
	borderTopRow
	More...
	calculatedMembers
	This contains the (local) calculated memmers for this pivot table. More...
	canDrillDown
	More...
	caption
	Caption to display. More...
	cellHeight
	This is the height (in pixels) used for all cells within the table. More...
	cellStyle
	Optional style to apply to cells. More...
	cellWidth
	This is the width (in pixels) used for all cells within the table. More...
	chartMarginBottom
	Page bottom margin when chart is printed. More...
	chartMarginLeft
	Page left margin when chart is printed. More...
	chartMarginRight
	Page right margin when chart is printed. More...
	chartMarginTop
	Page top margin when chart is printed. More...
	colorScale
	If set, this is the name of the color-scaling scheme to apply. More...
	columnAxisOptions
	This is used to define functions to apply to the entire column axis. More...
	columnHeaderStyle
	Optional style to apply to column headers. More...
	columnLabelSpan
	This specifies how parent column labels with multiple child labels are displayed. More...
	columnLevels
	This contains the definition of the column dimensions for this pivot table. More...
	columnTotalAgg
	Aggregate for column totals. More...
	columnTotals
	If true, then display column totals. More...
	cubeName
	Name of the cube that will provide data for this pivot table. More...
	drillLevels
	This contains the drillLevels for this pivot table. More...
	filterTableCaptionStyle
	filterTableCaptionStyle; More...
	filterTableItemStyle
	filterTableItemStyle; More...
	filterTableStyle
	filterTableStyle More...
	filters
	This contains the definition of the filters for this pivot table. More...
	fontFamilyCell
	Table styles. More...
	fontFamilyCol
	More...
	fontFamilyRow
	More...
	fontSizeCell
	More...
	fontSizeCol
	More...
	fontSizeRow
	More...
	formatRules
	This contains the formatting rule for this pivot table. More...
	hideMeasures
	hide measure captions or not for pivot. More...
	listing
	Name of listing to use for detail listings. More...
	listingFields
	This contains the definition of the listing fields for this pivot table. More...
	listingFilters
	This contains the definition of the listing filters for this pivot table. More...
	listingFontSize
	Font size for listings. More...
	listingRows
	Maximum number of rows to show in a listing. More...
	manualMode
	pivotTable manualMode (dataSource) flag. More...
	maxRows
	Max rows exported to PDF. More...
	mdx
	If defined and <property>dataSource</property> is set to "manual", then. More...
	measureLocation
	measureLocation for pivot. More...
	measures
	This contains the default measure(s) (e.g., "[Measures].[Sales]") to show for this pivot table. More...
	nowDisplayFormat
	nowDisplayFormat More...
	pageSize
	Number of result rows to show at one time. More...
	previewMode
	Save of previewMode setting. More...
	printCellWidth
	Width of data cells when the pivot is printed. More...
	printLabelWidth
	Width of row labels when the pivot is printed. More...
	printMarginBottom
	Page bottom margin when pivot is printed. More...
	printMarginLeft
	Page left margin when pivot is printed. More...
	printMarginRight
	Page right margin when pivot is printed. More...
	printMarginTop
	Page top margin when pivot is printed. More...
	printOrientation
	Orientation when pivot is printed. More...
	printPageSize
	Page size when pivot is printed. More...
	printSubtitle
	Subtitle to display when pivot is printed. More...
	printSubtitleOn
	Display subtitle when exporting to PDF. More...
	printTitle
	Title to display when pivot is printed. More...
	rowAxisOptions
	This is used to define functions to apply to the entire row axis. More...
	rowHeaderStyle
	Optional style to apply to row headers. More...
	rowLabelSpan
	This specifies how parent row labels with multiple child labels are displayed. More...
	rowLevels
	This contains the definition of the row dimensions for this pivot table. More...
	rowTotalAgg
	Aggregate for row totals. More...
	rowTotalSource
	Where row totals come from. More...
	rowTotals
	If true, then display row totals. More...
	showDate
	showDate - on, off More...
	showEmptyColumns
	If true, display columns containing only empty values. More...
	showEmptyRows
	If true, display rows containing only empty values. More...
	showFilters
	showFilters - byTable, byTitle, off More...
	showListingFilters
	showListingFilters - on, off More...
	showRowCaption
	If true, then display row captions. More...
	showStatus
	If true, show status area along the bottom of the table. More...
	showUser
	Display the user when exporting to PDF. More...
	showZebra
	If true, then display zebra striping. More...
	showZebraStripes
	showZebraStripes - on, off More...
	sqlRestriction
	This contains an SQL restriction that should be applied to this pivot table. More...
	userMDX
	pivotTable manualMode query. More...
Public Attributes inherited from FolderItem
	bookCover
	Specification string for the book cover associated with this folder item. More...
	category
	Category used by the book cover view of this item. More...
	createdBy
	Name of the user that originally created this item. More...
	description
	Optional description for this item. More...
	documentName
	Name of this item used in document import/export and source control (including folder and type extension plus .DFI). More...
	folder
	Folder this item belongs to. More...
	folderName
	Full name of the folder this item belongs to. More...
	fullName
	Full name of this item (including folder and type extension). More...
	keywords
	Csv-list of keywords associated with the item. More...
	lastAccessed
	Time that this item was last accessed. More...
	locked
	If true, then users are not allowed to save modifications to this item without first unlocking it. More...
	name
	Name of this item. More...
	owner
	User name of the owner of this item. More...
	public
	If true, this this item is listed in the user portal (if the user has permission to see it). More...
	resource
	The resource needed to view or edit this item: More...
	shared
	If true, then anyone with permission can view this item, otherwise only the owner can view this item. More...
	timeCreated
	Time that this item was originally created. More...
	timeModified
	Time that this item was last saved. More...
	title
	Option title displayed for this item. More...
Public Attributes inherited from AbstractPortalModel
	ReadOnly
	Flag to indicate whether the current object should be handled in ReadOnly mode. More...
	Timestamp
	The most recent time that the underlying class definition was changed. More...

Static Public Attributes
	PUBLIC = None
	Default value of public property for the class.
Static Public Attributes inherited from FolderItem
	ICON = None
	URL of icon for this item.
	ITEMTYPE = None
	This is the extension returned by this type from the Finder.
	LARGEICON = None
	URL of large icon for this item.
	LISTED = None
	If true, then items of this type (class) are displayed in the user portal table.
	PUBLIC = None
	Default value of public property for the class.
Static Public Attributes inherited from Persistent
	XCOMPACTANCESTRY
	XCOMPACTANCESTRY can be set to a string to replace the value of the %CLASSNAME property (x__classname field) More...
	DATALOCATIONGLOBAL = None
	Global name containing master map data for this class. More...
	DEFAULTGLOBAL = None
	DSCONDITION = None
	DSCONDITION is the expression that will be evaluated before deciding whether certain actions must be taken. More...
	DSINTERVAL = None
	DSINTERVAL is the number of seconds between one DSTIME value and the next. More...
	DSTIME = None
	If the DSTIME parameter is set to AUTO then the most recent filing operation in the current DSTIME value. More...
	EXTENTQUERYSPEC = None
	The EXTENTQUERYSPEC parameter defines the properties to be retrieved in. More...
	EXTENTSIZE = None
	The EXTENTSIZE parameter is used to inform the SQL Query Optimizer More...
	GUIDENABLED = None
	If this parameter is set to 1 then a GUID will be assigned (to the GUID property) to each new object. More...
	IDENTIFIEDBY = None
	The IDENTIFIEDBY parameter can optionally be set to the name. More...
	MANAGEDEXTENT = None
	The MANAGEDEXTENT parameter can be set to 0 (zero) to cause the Extent Manager. More...
	READONLY = None
	READONLY = 1 means that objects can be created, opened but not saved or deleted. More...
	ROWLEVELSECURITY = None
	ROWLEVELSECURITY = 1 | <property> means that row level security is active and the list More...
	SQLPREVENTFULLSCAN = None
	SQLPREVENTFULLSCAN = 1 means an attempt to prepare a query that will result in a full scan More...
	STORAGEDEFAULT = None
	STORAGEDEFAULT defines the default storage allocation to use for properties in this class. More...
	USEEXTENTSET = None
	VERSIONCLIENTNAME = None
	VERSIONCLIENTNAME can be set to a valid CLIENTNAME (see property CLIENTNAME) value. More...
	VERSIONPROPERTY = None
	VERSIONPROPERTY = <property> means that the <property> in memory will be compared to. More...
Static Public Attributes inherited from SwizzleObject
	DEFAULTCONCURRENCY = None
	DEFAULTCONCURRENCY is the default value for the concurrency formal argument. More...
	JOURNALSTREAM = None
	If OBJJOURNAL is true then the value of the JOURNALSTREAM parameter defines whether or not. More...
	OBJJOURNAL = None
	if OBJJOURNAL is TRUE then inserts, updates and deletes will be logged in ^OBJ.JournalT More...
Static Public Attributes inherited from RegisteredObject
	CAPTION = None
	Optional name used by the Form Wizard for a class when generating forms. More...
	JAVATYPE = None
	The Java type to be used when exported.
	PROPERTYVALIDATION = None
	This parameter controls the default validation behavior for the object. More...
Static Public Attributes inherited from Adaptor
	ATTRIBUTEQUALIFIED = None
	ATTRIBUTEQUALIFIED controls the format of exported XML by controlling whether attributes. More...
	ELEMENTQUALIFIED = None
	ELEMENTQUALIFIED controls the format of exported XML. More...
	NAMESPACE = None
	NAMESPACE specifies the XML namespace to be used when projecting the. More...
	SUPPRESSTYPEPREFIX = None
	SUPPRESSTYPEPREFIX allows the type name that refers to this class. More...
	XMLDEFAULTREFERENCE = None
	XMLDEFAULTREFERENCE specifies the default value of the XMLREFERENCE property parameter. More...
	XMLENABLED = None
	If this parameter is true then XML-enabling methods. More...
	XMLFORMAT = None
	The XMLFORMAT parameter controls the generation of the XMLExport and XMLImport. More...
	XMLIGNOREINVALIDATTRIBUTE = None
	The XMLIGNOREINVALIDATTRIBUTE parameter allows the programmer to control handling of unexpected. More...
	XMLIGNOREINVALIDTAG = None
	The XMLIGNOREINVALIDTAG parameter allows the programmer to control handling of unexpected. More...
	XMLIGNORENULL = None
	XMLIGNORENULL allows the programmer to override the default XML handling. More...
	XMLINCLUDEINGROUP = None
	XMLINCLUDEINGROUP allows the programmer to control whether a class is included. More...
	XMLINHERITANCE = None
	If the XMLINHERITANCE parameter is set to "LEFT", then in the case of multiple. More...
	XMLNAME = None
	This parameter provides the default XMLNAME for the class. More...
	XMLNIL = None
	The XMLNIL class parameter controls the use of xsi:nil by XMLExport. More...
	XMLNILNOOBJECT = None
	The XMLNILNOOBJECT parameter allows creation of an object to be skipped for elements. More...
	XMLPREFIX = None
	The XMLPREFIX parameter controls the prefix to be used for the XML namespace that. More...
	XMLSEQUENCE = None
	If the XMLSEQUENCE = 1, then the order of the XML elements must match the. More...
	XMLSUMMARY = None
	The summary fields to be used when an object is referenced are specified. More...
	XMLTYPE = None
	This parameter provides the default XMLTYPE for the class. More...
	XMLUNSWIZZLE = None
	If the XMLUNSWIZZLE parameter is set to 1, then single object. More...
	XMLUSEEMPTYELEMENT = None
	If the XMLUSEEMPTYELEMENT parameter is set to 1, then the empty element shorthand (<tag>) More...

Private Member Functions
_.Library.Status	CopyToDao (_.Library.DynamicObject pPivotJSON)
	Copy the contents of this pivot definition to an Dao.
_.Library.String	GetCubeName ()
	Return the cube name that provides data for this pivot.
_.Library.Status	GetDependencies (_.Library.String pList)
	Return a list of all other folder items (including cubes or kpis) that this item depends upon.
_.Library.String	GetTypeName ()
	Return the localized type name for this item.
_.Library.String	GetURL ()
	Return the URL for this item.

Additional Inherited Members
Public Member Functions inherited from FolderItem
_.Library.String	documentNameGet ()
	Getter method for document name that can be imported/exported.
_.Library.String	folderNameGet ()
	Getter method for folder name.
_.Library.Status	folderNameSet (_, _.Library.String val)
	Setter method for folder name.
_.Library.String	fullNameGet ()
	Getter method for full name.
_.Library.Status	fullNameSet (_, val)
	Setter method for full name.
Public Member Functions inherited from Persistent
_.Library.Status	AcquireLock (_.Library.String locktype)
	Acquires a lock for the current instance. More...
_.Library.Status	LoadData (_.Library.String id)
	LoadData() - loads an object from storage. More...
_.Library.Status	OnAfterSave (_.Library.Boolean insert)
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...
_.Library.Status	OnBeforeSave (_.Library.Boolean insert)
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...
_.Library.Status	OnOpen ()
	This callback method is invoked by the <METHOD>Open</METHOD> method to. More...
_.Library.Status	OnReload ()
	This callback method is invoked by the <METHOD>Reload</METHOD> method to. More...
_.Library.Status	OnRollBack ()
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...
_.Library.Status	ReleaseLock (_.Library.String locktype)
	Releases a lock for the current instance. More...
_.Library.Status	SaveData (_.Library.String id)
	SaveData() - saves an object to disk, checks uniqueness and referential More...
Public Member Functions inherited from SwizzleObject
_.Library.Status	OnJournalObject (_.Library.Integer tranid, _.Library.Integer jrnid, _.Library.String filter)
	This callback method is invoked by the <METHOD>JournalObject</METHOD> method to. More...
Public Member Functions inherited from RegisteredObject
_.Library.Status	OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)
	This callback method is invoked when the current object is added to the SaveSet,. More...
_.Library.Status	OnClose ()
	This callback method is invoked by the <METHOD>Close</METHOD> method to. More...
_.Library.Status	OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)
	This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More...
_.Library.Status	OnNew ()
	This callback method is invoked by the <METHOD>New</METHOD> method to. More...
_.Library.Status	OnValidateObject ()
	This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More...
Public Member Functions inherited from Adaptor
_.Library.Status	XMLExport (_.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent, _.Library.Boolean local, _.Net.MIMEPart mimeAttachments)
	Serialize an XML enabled class as an XML document and write. More...
_.Library.Status	XMLExportToStream (_.Stream.Object export, _.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent)
	Serialize an XML enabled class as an XML document and appends it to a stream. More...
_.Library.Status	XMLExportToString (_.Library.String export, _.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent)
	Serialize an XML enabled class as an XML document and write it to a string. More...
Static Public Member Functions inherited from Persistent
_.Library.Status	DeleteData (_.Library.String id, _.Library.Integer concurrency)
	This method is normally generated by the storage class for persistent classes using. More...
_.Library.Status	KillExtentData (_.Library.Boolean killstreams)
	KillExtentData() - kills extent data in storage. More...
_.Library.Status	OnAfterBuildIndices (_.Library.String indexlist)
	This callback method is invoked by the <METHOD>BuildIndices</METHOD> method after all work is completed. More...
_.Library.Status	OnAfterDelete (_.Library.ObjectIdentity oid)
	This callback method is invoked by the <METHOD>Delete</METHOD> method to. More...
_.Library.Status	OnAfterPurgeIndices (_.Library.String indexlist)
	This callback method is invoked by the <METHOD>PurgeIndices</METHOD> method after all work is completed. More...
_.Library.Status	OnBeforeBuildIndices (_.Library.String indexlist)
_.Library.Status	OnBeforePurgeIndices (_.Library.String indexlist)
_.Library.Status	OnDelete (_.Library.ObjectIdentity oid)
	This callback method is invoked by the <METHOD>Delete</METHOD> method to. More...
Static Public Member Functions inherited from Adaptor
_.Library.Status	XMLDTD (_.Library.String top, _.Library.String format, _.Library.Boolean input, dtdlist)
	Write the DTD to the current device for this XML enabled class serialized as. More...
_.Library.RegisteredObject	XMLNew (_.XML.Document document, _.Library.Integer node, _.Library.RegisteredObject containerOref)
	Get an instance of an XML enabled class. More...
_.Library.Status	XMLSchema (_.Library.String top, _.Library.String format, _.Library.String namespacePrefix, _.Library.Boolean input, _.Library.Boolean refOnly, schema)
	Write an XML Schema fragment to the current device which describes an XML enabled class and dependent classes. More...
_.Library.String	XMLSchemaNamespace ()
	Get the namespace to which this class belongs for use in schema generation. More...
_.Library.Status	XMLSchemaType (_.XML.Schema schemaInstance, _.XML.Node node, _.Library.String top, _.Library.Boolean encoded, _.Library.Boolean summary, _.Library.Boolean input, _.Library.Boolean refOnly)
	Add a complexType to the schema that is respresented by an <class>XML.Schema</class> instance. More...

Detailed Description

This persistent class represents a saved DeepSee pivot table.

Member Data Documentation

autoExecute

autoExecute

pivotTable autoExecute flag.

 

backgroundImage

backgroundImage

Optional image to show in background of pivot table.

 

backgroundOpacity

backgroundOpacity

Opacity (0 to 1) of pivot table background image.

 

borderBottomCell

borderBottomCell

 

 

borderBottomCol

borderBottomCol

 

 

borderBottomRow

borderBottomRow

 

 

borderLeftCell

borderLeftCell

Table borders.

 

borderLeftCol

borderLeftCol

 

 

borderLeftRow

borderLeftRow

 

 

borderRightCell

borderRightCell

 

 

borderRightCol

borderRightCol

 

 

borderRightRow

borderRightRow

 

 

borderTopCell

borderTopCell

 

 

borderTopCol

borderTopCol

 

 

borderTopRow

borderTopRow

 

 

calculatedMembers

calculatedMembers

This contains the (local) calculated memmers for this pivot table.

 

canDrillDown

canDrillDown

 

 

caption

caption

Caption to display.

If not specified, the caption for the cube will be used.

 

cellHeight

cellHeight

This is the height (in pixels) used for all cells within the table.

The default is 22.  

cellStyle

cellStyle

Optional style to apply to cells.

 

cellWidth

cellWidth

This is the width (in pixels) used for all cells within the table.

 

chartMarginBottom

chartMarginBottom

Page bottom margin when chart is printed.

This is in the same units as the page size.

 

chartMarginLeft

chartMarginLeft

Page left margin when chart is printed.

This is in the same units as the page size.

 

chartMarginRight

chartMarginRight

Page right margin when chart is printed.

This is in the same units as the page size.

 

chartMarginTop

chartMarginTop

Page top margin when chart is printed.

This is in the same units as the page size.

 

colorScale

colorScale

If set, this is the name of the color-scaling scheme to apply.

red-to-black,green-to-black,blue-to-black,salmon-to-black,purple-to-black,gray-to-black or "custom:r1,g1,b1:r2,g2,b2".  

columnAxisOptions

columnAxisOptions

This is used to define functions to apply to the entire column axis.

 

columnHeaderStyle

columnHeaderStyle

Optional style to apply to column headers.

 

columnLabelSpan

columnLabelSpan

This specifies how parent column labels with multiple child labels are displayed.

If true, then one parent label is displayed for each set of children. If false, then the parent row label is repeated for each child.  

columnLevels

columnLevels

This contains the definition of the column dimensions for this pivot table.

 

columnTotalAgg

columnTotalAgg

Aggregate for column totals.

 

columnTotals

columnTotals

If true, then display column totals.

 

cubeName

cubeName

Name of the cube that will provide data for this pivot table.

 

drillLevels

drillLevels

This contains the drillLevels for this pivot table.

 

filterTableCaptionStyle

filterTableCaptionStyle

filterTableCaptionStyle;

 

filterTableItemStyle

filterTableItemStyle

filterTableItemStyle;

 

filterTableStyle

filterTableStyle

filterTableStyle

 

filters

filters

This contains the definition of the filters for this pivot table.

 

fontFamilyCell

fontFamilyCell

Table styles.

 

fontFamilyCol

fontFamilyCol

 

 

fontFamilyRow

fontFamilyRow

 

 

fontSizeCell

fontSizeCell

 

 

fontSizeCol

fontSizeCol

 

 

fontSizeRow

fontSizeRow

 

 

formatRules

formatRules

This contains the formatting rule for this pivot table.

 

hideMeasures

hideMeasures

hide measure captions or not for pivot.

 

listing

listing

Name of listing to use for detail listings.

If not specified, the default listing for the cube will be used.

 

listingFields

listingFields

This contains the definition of the listing fields for this pivot table.

 

listingFilters

listingFilters

This contains the definition of the listing filters for this pivot table.

 

listingFontSize

listingFontSize

Font size for listings.

 

listingRows

listingRows

Maximum number of rows to show in a listing.

If not specified, the default value used.  

manualMode

manualMode

pivotTable manualMode (dataSource) flag.

 

maxRows

maxRows

Max rows exported to PDF.

 

mdx

mdx

If defined and <property>dataSource</property> is set to "manual", then.

this is the MDX statement used to provide the contents of the pivot table.  

measureLocation

measureLocation

measureLocation for pivot.

 

measures

measures

This contains the default measure(s) (e.g., "[Measures].[Sales]") to show for this pivot table.

 

nowDisplayFormat

nowDisplayFormat

nowDisplayFormat

 

pageSize

pageSize

Number of result rows to show at one time.

 

previewMode

previewMode

Save of previewMode setting.

The Analyzer will transfer this value to the previewMode property,

widgets will not.  

printCellWidth

printCellWidth

Width of data cells when the pivot is printed.

This is in the same units as the page size.

 

printLabelWidth

printLabelWidth

Width of row labels when the pivot is printed.

This is in the same units as the page size.

 

printMarginBottom

printMarginBottom

Page bottom margin when pivot is printed.

This is in the same units as the page size.

 

printMarginLeft

printMarginLeft

Page left margin when pivot is printed.

This is in the same units as the page size.

 

printMarginRight

printMarginRight

Page right margin when pivot is printed.

This is in the same units as the page size.

 

printMarginTop

printMarginTop

Page top margin when pivot is printed.

This is in the same units as the page size.

 

printOrientation

printOrientation

Orientation when pivot is printed.

 

printPageSize

printPageSize

Page size when pivot is printed.

This takes the form "8.5x11 in" (w x h).

 

printSubtitle

printSubtitle

Subtitle to display when pivot is printed.

 

printSubtitleOn

printSubtitleOn

Display subtitle when exporting to PDF.

 

printTitle

printTitle

Title to display when pivot is printed.

 

rowAxisOptions

rowAxisOptions

This is used to define functions to apply to the entire row axis.

 

rowHeaderStyle

rowHeaderStyle

Optional style to apply to row headers.

 

rowLabelSpan

rowLabelSpan

This specifies how parent row labels with multiple child labels are displayed.

If true, then one parent label is displayed for each set of children. If false, then the parent row label is repeated for each child.  

rowLevels

rowLevels

This contains the definition of the row dimensions for this pivot table.

 

rowTotalAgg

rowTotalAgg

Aggregate for row totals.

 

rowTotalSource

rowTotalSource

Where row totals come from.

 

rowTotals

rowTotals

If true, then display row totals.

 

showDate

showDate

showDate - on, off

 

showEmptyColumns

showEmptyColumns

If true, display columns containing only empty values.

If mdx is specified, this is ignored.  

showEmptyRows

showEmptyRows

If true, display rows containing only empty values.

If mdx is specified, this is ignored.  

showFilters

showFilters

showFilters - byTable, byTitle, off

 

showListingFilters

showListingFilters

showListingFilters - on, off

 

showRowCaption

showRowCaption

If true, then display row captions.

 

showStatus

showStatus

If true, show status area along the bottom of the table.

 

showUser

showUser

Display the user when exporting to PDF.

 

showZebra

showZebra

If true, then display zebra striping.

 

showZebraStripes

showZebraStripes

showZebraStripes - on, off

 

sqlRestriction

sqlRestriction

This contains an SQL restriction that should be applied to this pivot table.

 

userMDX

userMDX

pivotTable manualMode query.