Skip to main content

%DeepSee.Dashboard.Pivot

persistent class %DeepSee.Dashboard.Pivot extends %DeepSee.UserLibrary.FolderItem

SQL Table Name: %DeepSee_Dashboard.Pivot

This persistent class represents a saved DeepSee pivot table.

Property Inventory

Method Inventory

Parameters

parameter ICON = deepsee/ds2_layers2_44.png;
Inherited description: URL of icon for this item
parameter ITEMTYPE = pivot;
Inherited description: This is the extension returned by this type from the Finder.
parameter LARGEICON = deepsee/ds2_layers2_44.png;
Inherited description: URL of large icon for this item
parameter PUBLIC = 0;
Default value of public property for the class.
parameter XMLNAME = pivot;
Inherited description: This parameter provides the default XMLNAME for the class. If it is empty then the class name will be used to construct a default XML name. The default XMLNAME is used as the top level tag when exporting objects and the export context did not provide an XML container name.

Properties

property autoExecute as %ZEN.Datatype.boolean [ InitialExpression = 1 ];
pivotTable autoExecute flag.
Property methods: autoExecuteDisplayToLogical(), autoExecuteGet(), autoExecuteGetStored(), autoExecuteIsValid(), autoExecuteLogicalToDisplay(), autoExecuteLogicalToOdbc(), autoExecuteLogicalToXSD(), autoExecuteNormalize(), autoExecuteSet(), autoExecuteXSDToLogical()
property backgroundImage as %ZEN.Datatype.uri;
Optional image to show in background of pivot table.
Property methods: backgroundImageDisplayToLogical(), backgroundImageGet(), backgroundImageGetStored(), backgroundImageIsValid(), backgroundImageLogicalToDisplay(), backgroundImageLogicalToOdbc(), backgroundImageNormalize(), backgroundImageSet()
property backgroundOpacity as %ZEN.Datatype.float [ InitialExpression = 0.12 ];
Opacity (0 to 1) of pivot table background image.
Property methods: backgroundOpacityDisplayToLogical(), backgroundOpacityGet(), backgroundOpacityGetStored(), backgroundOpacityIsValid(), backgroundOpacityLogicalToDisplay(), backgroundOpacityLogicalToOdbc(), backgroundOpacityNormalize(), backgroundOpacitySet()
property borderBottomCell as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderBottomCellDisplayToLogical(), borderBottomCellGet(), borderBottomCellGetStored(), borderBottomCellIsValid(), borderBottomCellLogicalToDisplay(), borderBottomCellLogicalToOdbc(), borderBottomCellNormalize(), borderBottomCellSet()
property borderBottomCol as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderBottomColDisplayToLogical(), borderBottomColGet(), borderBottomColGetStored(), borderBottomColIsValid(), borderBottomColLogicalToDisplay(), borderBottomColLogicalToOdbc(), borderBottomColNormalize(), borderBottomColSet()
property borderBottomRow as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderBottomRowDisplayToLogical(), borderBottomRowGet(), borderBottomRowGetStored(), borderBottomRowIsValid(), borderBottomRowLogicalToDisplay(), borderBottomRowLogicalToOdbc(), borderBottomRowNormalize(), borderBottomRowSet()
property borderLeftCell as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Table borders
Property methods: borderLeftCellDisplayToLogical(), borderLeftCellGet(), borderLeftCellGetStored(), borderLeftCellIsValid(), borderLeftCellLogicalToDisplay(), borderLeftCellLogicalToOdbc(), borderLeftCellNormalize(), borderLeftCellSet()
property borderLeftCol as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderLeftColDisplayToLogical(), borderLeftColGet(), borderLeftColGetStored(), borderLeftColIsValid(), borderLeftColLogicalToDisplay(), borderLeftColLogicalToOdbc(), borderLeftColNormalize(), borderLeftColSet()
property borderLeftRow as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderLeftRowDisplayToLogical(), borderLeftRowGet(), borderLeftRowGetStored(), borderLeftRowIsValid(), borderLeftRowLogicalToDisplay(), borderLeftRowLogicalToOdbc(), borderLeftRowNormalize(), borderLeftRowSet()
property borderRightCell as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderRightCellDisplayToLogical(), borderRightCellGet(), borderRightCellGetStored(), borderRightCellIsValid(), borderRightCellLogicalToDisplay(), borderRightCellLogicalToOdbc(), borderRightCellNormalize(), borderRightCellSet()
property borderRightCol as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderRightColDisplayToLogical(), borderRightColGet(), borderRightColGetStored(), borderRightColIsValid(), borderRightColLogicalToDisplay(), borderRightColLogicalToOdbc(), borderRightColNormalize(), borderRightColSet()
property borderRightRow as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderRightRowDisplayToLogical(), borderRightRowGet(), borderRightRowGetStored(), borderRightRowIsValid(), borderRightRowLogicalToDisplay(), borderRightRowLogicalToOdbc(), borderRightRowNormalize(), borderRightRowSet()
property borderTopCell as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderTopCellDisplayToLogical(), borderTopCellGet(), borderTopCellGetStored(), borderTopCellIsValid(), borderTopCellLogicalToDisplay(), borderTopCellLogicalToOdbc(), borderTopCellNormalize(), borderTopCellSet()
property borderTopCol as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderTopColDisplayToLogical(), borderTopColGet(), borderTopColGetStored(), borderTopColIsValid(), borderTopColLogicalToDisplay(), borderTopColLogicalToOdbc(), borderTopColNormalize(), borderTopColSet()
property borderTopRow as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: borderTopRowDisplayToLogical(), borderTopRowGet(), borderTopRowGetStored(), borderTopRowIsValid(), borderTopRowLogicalToDisplay(), borderTopRowLogicalToOdbc(), borderTopRowNormalize(), borderTopRowSet()
property calculatedMembers as list of CalculatedMember (XMLNAME = "calculatedMember", XMLPROJECTION = "ELEMENT");
This contains the (local) calculated memmers for this pivot table.
Property methods: calculatedMembersBuildValueArray(), calculatedMembersCollectionToDisplay(), calculatedMembersCollectionToOdbc(), calculatedMembersDisplayToCollection(), calculatedMembersGet(), calculatedMembersGetObject(), calculatedMembersGetObjectId(), calculatedMembersGetStored(), calculatedMembersGetSwizzled(), calculatedMembersIsValid(), calculatedMembersOdbcToCollection(), calculatedMembersSet(), calculatedMembersSetObject(), calculatedMembersSetObjectId()
property canDrillDown as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 1 ];
Property methods: canDrillDownDisplayToLogical(), canDrillDownGet(), canDrillDownGetStored(), canDrillDownIsValid(), canDrillDownLogicalToDisplay(), canDrillDownLogicalToOdbc(), canDrillDownLogicalToXSD(), canDrillDownNormalize(), canDrillDownSet(), canDrillDownXSDToLogical()
property caption as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Caption to display. If not specified, the caption for the cube will be used.
Property methods: captionDisplayToLogical(), captionGet(), captionGetStored(), captionIsValid(), captionLogicalToDisplay(), captionLogicalToOdbc(), captionNormalize(), captionSet()
property cellHeight as %ZEN.Datatype.integer (XMLPROJECTION = "attribute") [ InitialExpression = 22 ];
This is the height (in pixels) used for all cells within the table. The default is 22.
Property methods: cellHeightDisplayToLogical(), cellHeightGet(), cellHeightGetStored(), cellHeightIsValid(), cellHeightLogicalToDisplay(), cellHeightLogicalToOdbc(), cellHeightNormalize(), cellHeightSet()
property cellStyle as %ZEN.Datatype.style (XMLPROJECTION = "attribute");
Optional style to apply to cells.
Property methods: cellStyleDisplayToLogical(), cellStyleGet(), cellStyleGetStored(), cellStyleIsValid(), cellStyleLogicalToDisplay(), cellStyleLogicalToOdbc(), cellStyleNormalize(), cellStyleSet()
property cellWidth as %ZEN.Datatype.integer (XMLPROJECTION = "attribute") [ InitialExpression = 120 ];
This is the width (in pixels) used for all cells within the table.
Property methods: cellWidthDisplayToLogical(), cellWidthGet(), cellWidthGetStored(), cellWidthIsValid(), cellWidthLogicalToDisplay(), cellWidthLogicalToOdbc(), cellWidthNormalize(), cellWidthSet()
property chartMarginBottom as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page bottom margin when chart is printed. This is in the same units as the page size.
Property methods: chartMarginBottomDisplayToLogical(), chartMarginBottomGet(), chartMarginBottomGetStored(), chartMarginBottomIsValid(), chartMarginBottomLogicalToDisplay(), chartMarginBottomLogicalToOdbc(), chartMarginBottomNormalize(), chartMarginBottomSet()
property chartMarginLeft as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page left margin when chart is printed. This is in the same units as the page size.
Property methods: chartMarginLeftDisplayToLogical(), chartMarginLeftGet(), chartMarginLeftGetStored(), chartMarginLeftIsValid(), chartMarginLeftLogicalToDisplay(), chartMarginLeftLogicalToOdbc(), chartMarginLeftNormalize(), chartMarginLeftSet()
property chartMarginRight as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page right margin when chart is printed. This is in the same units as the page size.
Property methods: chartMarginRightDisplayToLogical(), chartMarginRightGet(), chartMarginRightGetStored(), chartMarginRightIsValid(), chartMarginRightLogicalToDisplay(), chartMarginRightLogicalToOdbc(), chartMarginRightNormalize(), chartMarginRightSet()
property chartMarginTop as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page top margin when chart is printed. This is in the same units as the page size.
Property methods: chartMarginTopDisplayToLogical(), chartMarginTopGet(), chartMarginTopGetStored(), chartMarginTopIsValid(), chartMarginTopLogicalToDisplay(), chartMarginTopLogicalToOdbc(), chartMarginTopNormalize(), chartMarginTopSet()
property colorScale as %ZEN.Datatype.string;
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".
Property methods: colorScaleDisplayToLogical(), colorScaleGet(), colorScaleGetStored(), colorScaleIsValid(), colorScaleLogicalToDisplay(), colorScaleLogicalToOdbc(), colorScaleNormalize(), colorScaleSet()
property columnAxisOptions as PivotLevel;
This is used to define functions to apply to the entire column axis.
Property methods: columnAxisOptionsGet(), columnAxisOptionsGetObject(), columnAxisOptionsGetObjectId(), columnAxisOptionsGetStored(), columnAxisOptionsGetSwizzled(), columnAxisOptionsIsEmpty(), columnAxisOptionsIsValid(), columnAxisOptionsNewObject(), columnAxisOptionsSet(), columnAxisOptionsSetObject(), columnAxisOptionsSetObjectId(), columnAxisOptionsUnSwizzle()
property columnHeaderStyle as %ZEN.Datatype.style (XMLPROJECTION = "attribute");
Optional style to apply to column headers.
Property methods: columnHeaderStyleDisplayToLogical(), columnHeaderStyleGet(), columnHeaderStyleGetStored(), columnHeaderStyleIsValid(), columnHeaderStyleLogicalToDisplay(), columnHeaderStyleLogicalToOdbc(), columnHeaderStyleNormalize(), columnHeaderStyleSet()
property columnLabelSpan as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 1 ];
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.
Property methods: columnLabelSpanDisplayToLogical(), columnLabelSpanGet(), columnLabelSpanGetStored(), columnLabelSpanIsValid(), columnLabelSpanLogicalToDisplay(), columnLabelSpanLogicalToOdbc(), columnLabelSpanLogicalToXSD(), columnLabelSpanNormalize(), columnLabelSpanSet(), columnLabelSpanXSDToLogical()
property columnLevels as list of PivotLevel (XMLNAME = "columnLevel", XMLPROJECTION = "ELEMENT");
This contains the definition of the column dimensions for this pivot table.
Property methods: columnLevelsBuildValueArray(), columnLevelsCollectionToDisplay(), columnLevelsCollectionToOdbc(), columnLevelsDisplayToCollection(), columnLevelsGet(), columnLevelsGetObject(), columnLevelsGetObjectId(), columnLevelsGetStored(), columnLevelsGetSwizzled(), columnLevelsIsValid(), columnLevelsOdbcToCollection(), columnLevelsSet(), columnLevelsSetObject(), columnLevelsSetObjectId()
property columnTotalAgg as %ZEN.Datatype.string (XMLPROJECTION = "attribute") [ InitialExpression = "sum" ];
Aggregate for column totals.
Property methods: columnTotalAggDisplayToLogical(), columnTotalAggGet(), columnTotalAggGetStored(), columnTotalAggIsValid(), columnTotalAggLogicalToDisplay(), columnTotalAggLogicalToOdbc(), columnTotalAggNormalize(), columnTotalAggSet()
property columnTotals as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 0 ];
If true, then display column totals.
Property methods: columnTotalsDisplayToLogical(), columnTotalsGet(), columnTotalsGetStored(), columnTotalsIsValid(), columnTotalsLogicalToDisplay(), columnTotalsLogicalToOdbc(), columnTotalsLogicalToXSD(), columnTotalsNormalize(), columnTotalsSet(), columnTotalsXSDToLogical()
property cubeName as %ZEN.Datatype.className (XMLPROJECTION = "attribute");
Name of the cube that will provide data for this pivot table.
Property methods: cubeNameDisplayToLogical(), cubeNameGet(), cubeNameGetStored(), cubeNameIsValid(), cubeNameLogicalToDisplay(), cubeNameLogicalToOdbc(), cubeNameNormalize(), cubeNameSet()
property drillLevels as list of PivotLevel (XMLNAME = "drillLevel", XMLPROJECTION = "ELEMENT");
This contains the drillLevels for this pivot table.
Property methods: drillLevelsBuildValueArray(), drillLevelsCollectionToDisplay(), drillLevelsCollectionToOdbc(), drillLevelsDisplayToCollection(), drillLevelsGet(), drillLevelsGetObject(), drillLevelsGetObjectId(), drillLevelsGetStored(), drillLevelsGetSwizzled(), drillLevelsIsValid(), drillLevelsOdbcToCollection(), drillLevelsSet(), drillLevelsSetObject(), drillLevelsSetObjectId()
property filterTableCaptionStyle as %ZEN.Datatype.style (XMLPROJECTION = "attribute");
filterTableCaptionStyle;
Property methods: filterTableCaptionStyleDisplayToLogical(), filterTableCaptionStyleGet(), filterTableCaptionStyleGetStored(), filterTableCaptionStyleIsValid(), filterTableCaptionStyleLogicalToDisplay(), filterTableCaptionStyleLogicalToOdbc(), filterTableCaptionStyleNormalize(), filterTableCaptionStyleSet()
property filterTableItemStyle as %ZEN.Datatype.style (XMLPROJECTION = "attribute");
filterTableItemStyle;
Property methods: filterTableItemStyleDisplayToLogical(), filterTableItemStyleGet(), filterTableItemStyleGetStored(), filterTableItemStyleIsValid(), filterTableItemStyleLogicalToDisplay(), filterTableItemStyleLogicalToOdbc(), filterTableItemStyleNormalize(), filterTableItemStyleSet()
property filterTableStyle as %ZEN.Datatype.style (XMLPROJECTION = "attribute");
filterTableStyle
Property methods: filterTableStyleDisplayToLogical(), filterTableStyleGet(), filterTableStyleGetStored(), filterTableStyleIsValid(), filterTableStyleLogicalToDisplay(), filterTableStyleLogicalToOdbc(), filterTableStyleNormalize(), filterTableStyleSet()
property filters as list of PivotLevel (XMLNAME = "filter", XMLPROJECTION = "ELEMENT");
This contains the definition of the filters for this pivot table.
Property methods: filtersBuildValueArray(), filtersCollectionToDisplay(), filtersCollectionToOdbc(), filtersDisplayToCollection(), filtersGet(), filtersGetObject(), filtersGetObjectId(), filtersGetStored(), filtersGetSwizzled(), filtersIsValid(), filtersOdbcToCollection(), filtersSet(), filtersSetObject(), filtersSetObjectId()
property fontFamilyCell as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Table styles
Property methods: fontFamilyCellDisplayToLogical(), fontFamilyCellGet(), fontFamilyCellGetStored(), fontFamilyCellIsValid(), fontFamilyCellLogicalToDisplay(), fontFamilyCellLogicalToOdbc(), fontFamilyCellNormalize(), fontFamilyCellSet()
property fontFamilyCol as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: fontFamilyColDisplayToLogical(), fontFamilyColGet(), fontFamilyColGetStored(), fontFamilyColIsValid(), fontFamilyColLogicalToDisplay(), fontFamilyColLogicalToOdbc(), fontFamilyColNormalize(), fontFamilyColSet()
property fontFamilyRow as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: fontFamilyRowDisplayToLogical(), fontFamilyRowGet(), fontFamilyRowGetStored(), fontFamilyRowIsValid(), fontFamilyRowLogicalToDisplay(), fontFamilyRowLogicalToOdbc(), fontFamilyRowNormalize(), fontFamilyRowSet()
property fontSizeCell as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: fontSizeCellDisplayToLogical(), fontSizeCellGet(), fontSizeCellGetStored(), fontSizeCellIsValid(), fontSizeCellLogicalToDisplay(), fontSizeCellLogicalToOdbc(), fontSizeCellNormalize(), fontSizeCellSet()
property fontSizeCol as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: fontSizeColDisplayToLogical(), fontSizeColGet(), fontSizeColGetStored(), fontSizeColIsValid(), fontSizeColLogicalToDisplay(), fontSizeColLogicalToOdbc(), fontSizeColNormalize(), fontSizeColSet()
property fontSizeRow as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Property methods: fontSizeRowDisplayToLogical(), fontSizeRowGet(), fontSizeRowGetStored(), fontSizeRowIsValid(), fontSizeRowLogicalToDisplay(), fontSizeRowLogicalToOdbc(), fontSizeRowNormalize(), fontSizeRowSet()
property formatRules as list of PivotCondition (XMLNAME = "formatRule", XMLPROJECTION = "ELEMENT");
This contains the formatting rule for this pivot table.
Property methods: formatRulesBuildValueArray(), formatRulesCollectionToDisplay(), formatRulesCollectionToOdbc(), formatRulesDisplayToCollection(), formatRulesGet(), formatRulesGetObject(), formatRulesGetObjectId(), formatRulesGetStored(), formatRulesGetSwizzled(), formatRulesIsValid(), formatRulesOdbcToCollection(), formatRulesSet(), formatRulesSetObject(), formatRulesSetObjectId()
property hideMeasures as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
hide measure captions or not for pivot.
Property methods: hideMeasuresDisplayToLogical(), hideMeasuresGet(), hideMeasuresGetStored(), hideMeasuresIsValid(), hideMeasuresLogicalToDisplay(), hideMeasuresLogicalToOdbc(), hideMeasuresNormalize(), hideMeasuresSet()
property listing as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Name of listing to use for detail listings. If not specified, the default listing for the cube will be used.
Property methods: listingDisplayToLogical(), listingGet(), listingGetStored(), listingIsValid(), listingLogicalToDisplay(), listingLogicalToOdbc(), listingNormalize(), listingSet()
property listingFields as list of PivotLevel (XMLNAME = "listingField", XMLPROJECTION = "ELEMENT");
This contains the definition of the listing fields for this pivot table.
Property methods: listingFieldsBuildValueArray(), listingFieldsCollectionToDisplay(), listingFieldsCollectionToOdbc(), listingFieldsDisplayToCollection(), listingFieldsGet(), listingFieldsGetObject(), listingFieldsGetObjectId(), listingFieldsGetStored(), listingFieldsGetSwizzled(), listingFieldsIsValid(), listingFieldsOdbcToCollection(), listingFieldsSet(), listingFieldsSetObject(), listingFieldsSetObjectId()
property listingFilters as list of PivotLevel (XMLNAME = "listingFilter", XMLPROJECTION = "ELEMENT");
This contains the definition of the listing filters for this pivot table.
Property methods: listingFiltersBuildValueArray(), listingFiltersCollectionToDisplay(), listingFiltersCollectionToOdbc(), listingFiltersDisplayToCollection(), listingFiltersGet(), listingFiltersGetObject(), listingFiltersGetObjectId(), listingFiltersGetStored(), listingFiltersGetSwizzled(), listingFiltersIsValid(), listingFiltersOdbcToCollection(), listingFiltersSet(), listingFiltersSetObject(), listingFiltersSetObjectId()
property listingFontSize as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Font size for listings
Property methods: listingFontSizeDisplayToLogical(), listingFontSizeGet(), listingFontSizeGetStored(), listingFontSizeIsValid(), listingFontSizeLogicalToDisplay(), listingFontSizeLogicalToOdbc(), listingFontSizeNormalize(), listingFontSizeSet()
property listingRows as %ZEN.Datatype.integer (XMLPROJECTION = "attribute");
Maximum number of rows to show in a listing. If not specified, the default value used.
Property methods: listingRowsDisplayToLogical(), listingRowsGet(), listingRowsGetStored(), listingRowsIsValid(), listingRowsLogicalToDisplay(), listingRowsLogicalToOdbc(), listingRowsNormalize(), listingRowsSet()
property manualMode as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
pivotTable manualMode (dataSource) flag.
Property methods: manualModeDisplayToLogical(), manualModeGet(), manualModeGetStored(), manualModeIsValid(), manualModeLogicalToDisplay(), manualModeLogicalToOdbc(), manualModeLogicalToXSD(), manualModeNormalize(), manualModeSet(), manualModeXSDToLogical()
property maxRows as %ZEN.Datatype.integer (XMLPROJECTION = "attribute");
Max rows exported to PDF
Property methods: maxRowsDisplayToLogical(), maxRowsGet(), maxRowsGetStored(), maxRowsIsValid(), maxRowsLogicalToDisplay(), maxRowsLogicalToOdbc(), maxRowsNormalize(), maxRowsSet()
property mdx as %ZEN.Datatype.string (MAXLEN = 32000, XMLPROJECTION = "attribute");
If defined and dataSource is set to "manual", then this is the MDX statement used to provide the contents of the pivot table.
Property methods: mdxDisplayToLogical(), mdxGet(), mdxGetStored(), mdxIsValid(), mdxLogicalToDisplay(), mdxLogicalToOdbc(), mdxNormalize(), mdxSet()
property measureLocation as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
measureLocation for pivot.
Property methods: measureLocationDisplayToLogical(), measureLocationGet(), measureLocationGetStored(), measureLocationIsValid(), measureLocationLogicalToDisplay(), measureLocationLogicalToOdbc(), measureLocationNormalize(), measureLocationSet()
property measures as list of PivotLevel (XMLNAME = "measure", XMLPROJECTION = "ELEMENT");
This contains the default measure(s) (e.g., "[Measures].[Sales]") to show for this pivot table.
Property methods: measuresBuildValueArray(), measuresCollectionToDisplay(), measuresCollectionToOdbc(), measuresDisplayToCollection(), measuresGet(), measuresGetObject(), measuresGetObjectId(), measuresGetStored(), measuresGetSwizzled(), measuresIsValid(), measuresOdbcToCollection(), measuresSet(), measuresSetObject(), measuresSetObjectId()
property nowDisplayFormat as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
nowDisplayFormat
Property methods: nowDisplayFormatDisplayToLogical(), nowDisplayFormatGet(), nowDisplayFormatGetStored(), nowDisplayFormatIsValid(), nowDisplayFormatLogicalToDisplay(), nowDisplayFormatLogicalToOdbc(), nowDisplayFormatNormalize(), nowDisplayFormatSet()
property pageSize as %ZEN.Datatype.integer (XMLPROJECTION = "attribute") [ InitialExpression = 100 ];
Number of result rows to show at one time.
Property methods: pageSizeDisplayToLogical(), pageSizeGet(), pageSizeGetStored(), pageSizeIsValid(), pageSizeLogicalToDisplay(), pageSizeLogicalToOdbc(), pageSizeNormalize(), pageSizeSet()
property previewMode as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
Save of previewMode setting. The Analyzer will transfer this value to the previewMode property, widgets will not.
Property methods: previewModeDisplayToLogical(), previewModeGet(), previewModeGetStored(), previewModeIsValid(), previewModeLogicalToDisplay(), previewModeLogicalToOdbc(), previewModeLogicalToXSD(), previewModeNormalize(), previewModeSet(), previewModeXSDToLogical()
property printCellWidth as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Width of data cells when the pivot is printed. This is in the same units as the page size.
Property methods: printCellWidthDisplayToLogical(), printCellWidthGet(), printCellWidthGetStored(), printCellWidthIsValid(), printCellWidthLogicalToDisplay(), printCellWidthLogicalToOdbc(), printCellWidthNormalize(), printCellWidthSet()
property printLabelWidth as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Width of row labels when the pivot is printed. This is in the same units as the page size.
Property methods: printLabelWidthDisplayToLogical(), printLabelWidthGet(), printLabelWidthGetStored(), printLabelWidthIsValid(), printLabelWidthLogicalToDisplay(), printLabelWidthLogicalToOdbc(), printLabelWidthNormalize(), printLabelWidthSet()
property printMarginBottom as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page bottom margin when pivot is printed. This is in the same units as the page size.
Property methods: printMarginBottomDisplayToLogical(), printMarginBottomGet(), printMarginBottomGetStored(), printMarginBottomIsValid(), printMarginBottomLogicalToDisplay(), printMarginBottomLogicalToOdbc(), printMarginBottomNormalize(), printMarginBottomSet()
property printMarginLeft as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page left margin when pivot is printed. This is in the same units as the page size.
Property methods: printMarginLeftDisplayToLogical(), printMarginLeftGet(), printMarginLeftGetStored(), printMarginLeftIsValid(), printMarginLeftLogicalToDisplay(), printMarginLeftLogicalToOdbc(), printMarginLeftNormalize(), printMarginLeftSet()
property printMarginRight as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page right margin when pivot is printed. This is in the same units as the page size.
Property methods: printMarginRightDisplayToLogical(), printMarginRightGet(), printMarginRightGetStored(), printMarginRightIsValid(), printMarginRightLogicalToDisplay(), printMarginRightLogicalToOdbc(), printMarginRightNormalize(), printMarginRightSet()
property printMarginTop as %ZEN.Datatype.float (XMLPROJECTION = "attribute");
Page top margin when pivot is printed. This is in the same units as the page size.
Property methods: printMarginTopDisplayToLogical(), printMarginTopGet(), printMarginTopGetStored(), printMarginTopIsValid(), printMarginTopLogicalToDisplay(), printMarginTopLogicalToOdbc(), printMarginTopNormalize(), printMarginTopSet()
property printOrientation as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Orientation when pivot is printed.
Property methods: printOrientationDisplayToLogical(), printOrientationGet(), printOrientationGetStored(), printOrientationIsValid(), printOrientationLogicalToDisplay(), printOrientationLogicalToOdbc(), printOrientationNormalize(), printOrientationSet()
property printPageSize as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Page size when pivot is printed. This takes the form "8.5x11 in" (w x h).
Property methods: printPageSizeDisplayToLogical(), printPageSizeGet(), printPageSizeGetStored(), printPageSizeIsValid(), printPageSizeLogicalToDisplay(), printPageSizeLogicalToOdbc(), printPageSizeNormalize(), printPageSizeSet()
property printSubtitle as %ZEN.Datatype.string (MAXLEN = 2000, XMLPROJECTION = "attribute");
Subtitle to display when pivot is printed.
Property methods: printSubtitleDisplayToLogical(), printSubtitleGet(), printSubtitleGetStored(), printSubtitleIsValid(), printSubtitleLogicalToDisplay(), printSubtitleLogicalToOdbc(), printSubtitleNormalize(), printSubtitleSet()
property printSubtitleOn as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Display subtitle when exporting to PDF
Property methods: printSubtitleOnDisplayToLogical(), printSubtitleOnGet(), printSubtitleOnGetStored(), printSubtitleOnIsValid(), printSubtitleOnLogicalToDisplay(), printSubtitleOnLogicalToOdbc(), printSubtitleOnNormalize(), printSubtitleOnSet()
property printTitle as %ZEN.Datatype.string (MAXLEN = 2000, XMLPROJECTION = "attribute");
Title to display when pivot is printed.
Property methods: printTitleDisplayToLogical(), printTitleGet(), printTitleGetStored(), printTitleIsValid(), printTitleLogicalToDisplay(), printTitleLogicalToOdbc(), printTitleNormalize(), printTitleSet()
property rowAxisOptions as PivotLevel;
This is used to define functions to apply to the entire row axis.
Property methods: rowAxisOptionsGet(), rowAxisOptionsGetObject(), rowAxisOptionsGetObjectId(), rowAxisOptionsGetStored(), rowAxisOptionsGetSwizzled(), rowAxisOptionsIsEmpty(), rowAxisOptionsIsValid(), rowAxisOptionsNewObject(), rowAxisOptionsSet(), rowAxisOptionsSetObject(), rowAxisOptionsSetObjectId(), rowAxisOptionsUnSwizzle()
property rowHeaderStyle as %ZEN.Datatype.style (XMLPROJECTION = "attribute");
Optional style to apply to row headers.
Property methods: rowHeaderStyleDisplayToLogical(), rowHeaderStyleGet(), rowHeaderStyleGetStored(), rowHeaderStyleIsValid(), rowHeaderStyleLogicalToDisplay(), rowHeaderStyleLogicalToOdbc(), rowHeaderStyleNormalize(), rowHeaderStyleSet()
property rowLabelSpan as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 1 ];
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.
Property methods: rowLabelSpanDisplayToLogical(), rowLabelSpanGet(), rowLabelSpanGetStored(), rowLabelSpanIsValid(), rowLabelSpanLogicalToDisplay(), rowLabelSpanLogicalToOdbc(), rowLabelSpanLogicalToXSD(), rowLabelSpanNormalize(), rowLabelSpanSet(), rowLabelSpanXSDToLogical()
property rowLevels as list of PivotLevel (XMLNAME = "rowLevel", XMLPROJECTION = "ELEMENT");
This contains the definition of the row dimensions for this pivot table.
Property methods: rowLevelsBuildValueArray(), rowLevelsCollectionToDisplay(), rowLevelsCollectionToOdbc(), rowLevelsDisplayToCollection(), rowLevelsGet(), rowLevelsGetObject(), rowLevelsGetObjectId(), rowLevelsGetStored(), rowLevelsGetSwizzled(), rowLevelsIsValid(), rowLevelsOdbcToCollection(), rowLevelsSet(), rowLevelsSetObject(), rowLevelsSetObjectId()
property rowTotalAgg as %ZEN.Datatype.string (XMLPROJECTION = "attribute") [ InitialExpression = "sum" ];
Aggregate for row totals.
Property methods: rowTotalAggDisplayToLogical(), rowTotalAggGet(), rowTotalAggGetStored(), rowTotalAggIsValid(), rowTotalAggLogicalToDisplay(), rowTotalAggLogicalToOdbc(), rowTotalAggNormalize(), rowTotalAggSet()
property rowTotalSource as %ZEN.Datatype.string (XMLPROJECTION = "attribute") [ InitialExpression = "page" ];
Where row totals come from.
Property methods: rowTotalSourceDisplayToLogical(), rowTotalSourceGet(), rowTotalSourceGetStored(), rowTotalSourceIsValid(), rowTotalSourceLogicalToDisplay(), rowTotalSourceLogicalToOdbc(), rowTotalSourceNormalize(), rowTotalSourceSet()
property rowTotals as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 0 ];
If true, then display row totals.
Property methods: rowTotalsDisplayToLogical(), rowTotalsGet(), rowTotalsGetStored(), rowTotalsIsValid(), rowTotalsLogicalToDisplay(), rowTotalsLogicalToOdbc(), rowTotalsLogicalToXSD(), rowTotalsNormalize(), rowTotalsSet(), rowTotalsXSDToLogical()
property showDate as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
showDate - on, off
Property methods: showDateDisplayToLogical(), showDateGet(), showDateGetStored(), showDateIsValid(), showDateLogicalToDisplay(), showDateLogicalToOdbc(), showDateNormalize(), showDateSet()
property showEmptyColumns as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 0 ];
If true, display columns containing only empty values.
If mdx is specified, this is ignored.
Property methods: showEmptyColumnsDisplayToLogical(), showEmptyColumnsGet(), showEmptyColumnsGetStored(), showEmptyColumnsIsValid(), showEmptyColumnsLogicalToDisplay(), showEmptyColumnsLogicalToOdbc(), showEmptyColumnsLogicalToXSD(), showEmptyColumnsNormalize(), showEmptyColumnsSet(), showEmptyColumnsXSDToLogical()
property showEmptyRows as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 0 ];
If true, display rows containing only empty values.
If mdx is specified, this is ignored.
Property methods: showEmptyRowsDisplayToLogical(), showEmptyRowsGet(), showEmptyRowsGetStored(), showEmptyRowsIsValid(), showEmptyRowsLogicalToDisplay(), showEmptyRowsLogicalToOdbc(), showEmptyRowsLogicalToXSD(), showEmptyRowsNormalize(), showEmptyRowsSet(), showEmptyRowsXSDToLogical()
property showFilters as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
showFilters - byTable, byTitle, off
Property methods: showFiltersDisplayToLogical(), showFiltersGet(), showFiltersGetStored(), showFiltersIsValid(), showFiltersLogicalToDisplay(), showFiltersLogicalToOdbc(), showFiltersNormalize(), showFiltersSet()
property showListingFilters as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
showListingFilters - on, off
Property methods: showListingFiltersDisplayToLogical(), showListingFiltersGet(), showListingFiltersGetStored(), showListingFiltersIsValid(), showListingFiltersLogicalToDisplay(), showListingFiltersLogicalToOdbc(), showListingFiltersNormalize(), showListingFiltersSet()
property showRowCaption as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 1 ];
If true, then display row captions.
Property methods: showRowCaptionDisplayToLogical(), showRowCaptionGet(), showRowCaptionGetStored(), showRowCaptionIsValid(), showRowCaptionLogicalToDisplay(), showRowCaptionLogicalToOdbc(), showRowCaptionLogicalToXSD(), showRowCaptionNormalize(), showRowCaptionSet(), showRowCaptionXSDToLogical()
property showStatus as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 1 ];
If true, show status area along the bottom of the table.
Property methods: showStatusDisplayToLogical(), showStatusGet(), showStatusGetStored(), showStatusIsValid(), showStatusLogicalToDisplay(), showStatusLogicalToOdbc(), showStatusLogicalToXSD(), showStatusNormalize(), showStatusSet(), showStatusXSDToLogical()
property showUser as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
Display the user when exporting to PDF
Property methods: showUserDisplayToLogical(), showUserGet(), showUserGetStored(), showUserIsValid(), showUserLogicalToDisplay(), showUserLogicalToOdbc(), showUserNormalize(), showUserSet()
property showZebra as %ZEN.Datatype.boolean (XMLPROJECTION = "attribute") [ InitialExpression = 0 ];
If true, then display zebra striping.
Property methods: showZebraDisplayToLogical(), showZebraGet(), showZebraGetStored(), showZebraIsValid(), showZebraLogicalToDisplay(), showZebraLogicalToOdbc(), showZebraLogicalToXSD(), showZebraNormalize(), showZebraSet(), showZebraXSDToLogical()
property showZebraStripes as %ZEN.Datatype.string (XMLPROJECTION = "attribute");
showZebraStripes - on, off
Property methods: showZebraStripesDisplayToLogical(), showZebraStripesGet(), showZebraStripesGetStored(), showZebraStripesIsValid(), showZebraStripesLogicalToDisplay(), showZebraStripesLogicalToOdbc(), showZebraStripesNormalize(), showZebraStripesSet()
property sqlRestriction as %ZEN.Datatype.string (XMLNAME = "sqlRestriction", XMLPROJECTION = "ELEMENT");
This contains an SQL restriction that should be applied to this pivot table.
Property methods: sqlRestrictionDisplayToLogical(), sqlRestrictionGet(), sqlRestrictionGetStored(), sqlRestrictionIsValid(), sqlRestrictionLogicalToDisplay(), sqlRestrictionLogicalToOdbc(), sqlRestrictionNormalize(), sqlRestrictionSet()
property userMDX as %ZEN.Datatype.string (MAXLEN = 5000);
pivotTable manualMode query.
Property methods: userMDXDisplayToLogical(), userMDXGet(), userMDXGetStored(), userMDXIsValid(), userMDXLogicalToDisplay(), userMDXLogicalToOdbc(), userMDXNormalize(), userMDXSet()

Methods

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

Inherited Members

Inherited Properties

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: Storage (%DeepSee.UserLibrary.FolderItem)

^DeepSee.FolderItemD(ID)
=
%%CLASSNAME
folder
name
keywords
owner
shared
resource
timeCreated
timeModified
dummy
description
title
locked
public
createdBy
bookCover
category
lastAccessed

Storage Model: Storage (%DeepSee.Dashboard.Pivot)

^DeepSee.FolderItemD(ID,"Pivot")
=
mdx
cellWidth
rowLabelSpan
columnLabelSpan
cellHeight
showEmptyRows
showEmptyColumns
cubeName
caption
showFilters
showStatus
rowAxisOptions
columnAxisOptions
rowLevels
columnLevels
filters
measures
pageSize
drillLevels
colorScale
formatRules
listing
rowTotals
columnTotals
calculatedMembers
columnHeaderStyle
rowHeaderStyle
cellStyle
listingRows
showZebra
showRowCaption
rowTotalAgg
columnTotalAgg
rowTotalSource
printTitle
printSubtitle
printPageSize
printOrientation
printMarginTop
printMarginLeft
printMarginRight
printMarginBottom
printLabelWidth
printCellWidth
autoExecute
manualMode
userMDX
chartMarginTop
chartMarginLeft
chartMarginRight
chartMarginBottom
listingFields
filterTableStyle
filterTableCaptionStyle
filterTableItemStyle
borderLeftCell
borderRightCell
borderTopCell
borderBottomCell
borderLeftCol
borderRightCol
borderTopCol
borderBottomCol
borderLeftRow
borderRightRow
borderTopRow
borderBottomRow
maxRows
showListingFilters
showDate
showZebraStripes
listingFontSize
printSubtitleOn
nowDisplayFormat
showUser
listingFilters
measureLocation
backgroundImage
backgroundOpacity
fontFamilyCell
fontSizeCell
fontFamilyCol
fontSizeCol
fontFamilyRow
fontSizeRow
hideMeasures
previewMode
sqlRestriction
canDrillDown
FeedbackOpens in a new tab