/AWS1/CL_QSTPIVOTTABLEOPTIONS¶
The table options for a pivot table visual.
CONSTRUCTOR¶
IMPORTING¶
Optional arguments:¶
IV_METRICPLACEMENT TYPE /AWS1/QSTPIVOTTABLEMETRICPLCMT /AWS1/QSTPIVOTTABLEMETRICPLCMT¶
The metric placement (row, column) options.
IV_SINGLEMETRICVISIBILITY TYPE /AWS1/QSTVISIBILITY /AWS1/QSTVISIBILITY¶
The visibility of the single metric options.
IV_COLUMNNAMESVISIBILITY TYPE /AWS1/QSTVISIBILITY /AWS1/QSTVISIBILITY¶
The visibility of the column names.
IV_TOGGLEBUTTONSVISIBILITY TYPE /AWS1/QSTVISIBILITY /AWS1/QSTVISIBILITY¶
Determines the visibility of the pivot table.
IO_COLUMNHEADERSTYLE TYPE REF TO /AWS1/CL_QSTTABLECELLSTYLE /AWS1/CL_QSTTABLECELLSTYLE¶
The table cell style of the column header.
IO_ROWHEADERSTYLE TYPE REF TO /AWS1/CL_QSTTABLECELLSTYLE /AWS1/CL_QSTTABLECELLSTYLE¶
The table cell style of the row headers.
IO_CELLSTYLE TYPE REF TO /AWS1/CL_QSTTABLECELLSTYLE /AWS1/CL_QSTTABLECELLSTYLE¶
The table cell style of cells.
IO_ROWFIELDNAMESSTYLE TYPE REF TO /AWS1/CL_QSTTABLECELLSTYLE /AWS1/CL_QSTTABLECELLSTYLE¶
The table cell style of row field names.
IO_ROWALTERNATECOLOROPTIONS TYPE REF TO /AWS1/CL_QSTROWALTERNATECOLO00 /AWS1/CL_QSTROWALTERNATECOLO00¶
The row alternate color options (widget status, row alternate colors).
IV_COLLAPSEDROWDIMVISIBILITY TYPE /AWS1/QSTVISIBILITY /AWS1/QSTVISIBILITY¶
The visibility setting of a pivot table's collapsed row dimension fields. If the value of this structure is
HIDDEN, all collapsed columns in a pivot table are automatically hidden. The default value isVISIBLE.
IV_ROWSLAYOUT TYPE /AWS1/QSTPIVOTTABLEROWSLAYOUT /AWS1/QSTPIVOTTABLEROWSLAYOUT¶
The layout for the row dimension headers of a pivot table. Choose one of the following options.
TABULAR: (Default) Each row field is displayed in a separate column.
HIERARCHY: All row fields are displayed in a single column. Indentation is used to differentiate row headers of different fields.
IO_ROWSLABELOPTIONS TYPE REF TO /AWS1/CL_QSTPIVOTTBLROWSLABE00 /AWS1/CL_QSTPIVOTTBLROWSLABE00¶
The options for the label that is located above the row headers. This option is only applicable when
RowsLayoutis set toHIERARCHY.
IV_DEFAULTCELLWIDTH TYPE /AWS1/QSTPIXELLENGTH /AWS1/QSTPIXELLENGTH¶
The default cell width of the pivot table.
Queryable Attributes¶
MetricPlacement¶
The metric placement (row, column) options.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_METRICPLACEMENT() |
Getter for METRICPLACEMENT, with configurable default |
ASK_METRICPLACEMENT() |
Getter for METRICPLACEMENT w/ exceptions if field has no val |
HAS_METRICPLACEMENT() |
Determine if METRICPLACEMENT has a value |
SingleMetricVisibility¶
The visibility of the single metric options.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_SINGLEMETRICVISIBILITY() |
Getter for SINGLEMETRICVISIBILITY, with configurable default |
ASK_SINGLEMETRICVISIBILITY() |
Getter for SINGLEMETRICVISIBILITY w/ exceptions if field has |
HAS_SINGLEMETRICVISIBILITY() |
Determine if SINGLEMETRICVISIBILITY has a value |
ColumnNamesVisibility¶
The visibility of the column names.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_COLUMNNAMESVISIBILITY() |
Getter for COLUMNNAMESVISIBILITY, with configurable default |
ASK_COLUMNNAMESVISIBILITY() |
Getter for COLUMNNAMESVISIBILITY w/ exceptions if field has |
HAS_COLUMNNAMESVISIBILITY() |
Determine if COLUMNNAMESVISIBILITY has a value |
ToggleButtonsVisibility¶
Determines the visibility of the pivot table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_TOGGLEBUTTONSVISIBILITY() |
Getter for TOGGLEBUTTONSVISIBILITY, with configurable defaul |
ASK_TOGGLEBUTTONSVISIBILITY() |
Getter for TOGGLEBUTTONSVISIBILITY w/ exceptions if field ha |
HAS_TOGGLEBUTTONSVISIBILITY() |
Determine if TOGGLEBUTTONSVISIBILITY has a value |
ColumnHeaderStyle¶
The table cell style of the column header.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_COLUMNHEADERSTYLE() |
Getter for COLUMNHEADERSTYLE |
RowHeaderStyle¶
The table cell style of the row headers.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ROWHEADERSTYLE() |
Getter for ROWHEADERSTYLE |
CellStyle¶
The table cell style of cells.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_CELLSTYLE() |
Getter for CELLSTYLE |
RowFieldNamesStyle¶
The table cell style of row field names.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ROWFIELDNAMESSTYLE() |
Getter for ROWFIELDNAMESSTYLE |
RowAlternateColorOptions¶
The row alternate color options (widget status, row alternate colors).
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ROWALTERNATECOLOROPTIONS() |
Getter for ROWALTERNATECOLOROPTIONS |
CollapsedRowDimensionsVisibility¶
The visibility setting of a pivot table's collapsed row dimension fields. If the value of this structure is
HIDDEN, all collapsed columns in a pivot table are automatically hidden. The default value isVISIBLE.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_COLLAPSEDROWDIMVISIBIL00() |
Getter for COLLAPSEDROWDIMVISIBILITY, with configurable defa |
ASK_COLLAPSEDROWDIMVISIBIL00() |
Getter for COLLAPSEDROWDIMVISIBILITY w/ exceptions if field |
HAS_COLLAPSEDROWDIMVISIBIL00() |
Determine if COLLAPSEDROWDIMVISIBILITY has a value |
RowsLayout¶
The layout for the row dimension headers of a pivot table. Choose one of the following options.
TABULAR: (Default) Each row field is displayed in a separate column.
HIERARCHY: All row fields are displayed in a single column. Indentation is used to differentiate row headers of different fields.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ROWSLAYOUT() |
Getter for ROWSLAYOUT, with configurable default |
ASK_ROWSLAYOUT() |
Getter for ROWSLAYOUT w/ exceptions if field has no value |
HAS_ROWSLAYOUT() |
Determine if ROWSLAYOUT has a value |
RowsLabelOptions¶
The options for the label that is located above the row headers. This option is only applicable when
RowsLayoutis set toHIERARCHY.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ROWSLABELOPTIONS() |
Getter for ROWSLABELOPTIONS |
DefaultCellWidth¶
The default cell width of the pivot table.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_DEFAULTCELLWIDTH() |
Getter for DEFAULTCELLWIDTH, with configurable default |
ASK_DEFAULTCELLWIDTH() |
Getter for DEFAULTCELLWIDTH w/ exceptions if field has no va |
HAS_DEFAULTCELLWIDTH() |
Determine if DEFAULTCELLWIDTH has a value |