class %DeepSee.Component.pivotLevel
extends %ZEN.Component.object
Defines an axis, measure, or filter level
within a %DeepSee.Component.pivotTable component.
• parameter NAMESPACE = "http://www.intersystems.com/deepsee";
This is the XML namespace used for library components.
• property advanced
as %ZEN.Datatype.boolean;
If true, then spec contains an "advanced" specification
(such as an advanced filter).
• property aggEnabled
as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, apply the Aggregate function to this level.
• property aggFunction
as %ZEN.Datatype.string;
Aggregate function.
• property aggFunctionParm
as %ZEN.Datatype.string;
Parameter for aggregate function (if any)
• property caption
as %ZEN.Datatype.caption;
Optional caption for this level.
This is used to hold the level caption when this level is used a filter.
• property childLevels
as list of pivotLevel(XMLELEMENTREF=1,XMLPROJECTION="ELEMENT",ZENSETTING=0);
Children of this level.
• property drillLevel
as %ZEN.Datatype.integer [ InitialExpression = 0 ];
Drill-level at which this level was defined.
• property filterEnabled
as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, apply the FILTER function to this level.
• property filterExpression
as %ZEN.Datatype.string;
Filter expression for FILTER function.
• property headCount
as %ZEN.Datatype.integer;
Count argument for HEAD function.
• property headEnabled
as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, apply the HEAD function to this level.
• property key
as %ZEN.Datatype.string;
Key value of the current dimension level.
This can be a comma-delimited list of keys:
"14,25"
If there are multiple keys, they may be encoded as an MDX set. "{A,B}"
• property levelCaption
as %ZEN.Datatype.string;
Optional caption to apply to this element.
• property levelFormat
as %ZEN.Datatype.string;
Optional format to apply to this element.
• property levelHeaderStyle
as %ZEN.Datatype.style;
Optional CSS style to apply to header's for this element.
• property levelStyle
as %ZEN.Datatype.style;
Optional CSS style to apply to this element.
• property levelSummary
as %ZEN.Datatype.string;
Optional pivot table summary to use for this element.
If the pivotTable displays rowTotals or columnTotals, then this will override the
summary aggregate used.
The value can be sum,min,max,count,avg,pct.
• property levelType
as %ZEN.Datatype.string(VALUELIST=",value,space,mdx");
For row/column options, indicates the type of member defined.
• property orderDirection
as %ZEN.Datatype.string [ InitialExpression = "BDESC" ];
Direction argument for ORDER function.
• property orderEnabled
as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, apply the ORDER function to this level.
• property orderExpression
as %ZEN.Datatype.string;
Sort expression for ORDER function.
• property spec
as %ZEN.Datatype.string;
This specifies the dimension level displayed for this level
of the pivot table.
For example, "[Product]" or "[Time].[Year]"
• property suppress8020
as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, apply the 80/20 suppression to this level.
• property text
as %ZEN.Datatype.caption;
Optional display name for this level. This is the text displayed by the pivot table
when a level is used a filter.
• property transient
as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, then is a filter that was passed in from a widget and should
not be saved as part of the pivot state.
• property value
as %ZEN.Datatype.string;
Name value of the current dimension level.
This can be a comma-delimited list of delimited values:
"[2005],[2006]"
