Page Comparison

Max Rows

The maximumnumber of rows to be displayed on the crosstab.

Max Columns

The maximumnumber of columns to be displayed on the crosstab. 

Repeat Member Values

Selecting this checkbox repeats the member values on the crosstab. Otherwise, the member values are displayed once. 

Response Chunk Size

Data in crosstab is fetched and rendered in chunks for best visualization. This property lets you specify the number of rows fetched in each chunk for crosstab. 

• Automatic: The number of rows in each chunk is intelligently calculated based on dimensions and measures on visualization and properties set at the semantic model level.

• Manual: Provide a value ranging from 1 to 10,000 to specify the number of rows in each chunk of the crosstab. 

NOTE: The chunk size you specify is applied only to this sheet. To specify the chunk size at the application level, you must use the kyvos.crosstab.response.chunksize property in the olapengine.properties file. 

Row Drill Options

Column Drill Options

Specifies whether the drilled-down view should display levelsor member expansions.

• Member Expansion

• Level Expansion 

NOTE: When Row or Column Expansion is set to Classic, you can set the drill options to memberor level. When they are set to Hierarchical, these options are not available. 

Row Expansion

Column Expansion

In the drop-down list, select either Classic or Hierarchical expansion for rows and columns. 

• Row: When you select Classic and expand members in a row, the expanded member data is shown as a new separate column. When Hierarchical is selected, the expanded member data is shown as new indented rows.

• Column: When you select Classic and expand members in a column, the expanded member data is shown as a separate new row. When Hierarchical is selected, the expanded member data is shown as new indented columns. 

Show Expand Collapse Button

Allows you to view plus and minus icons for expanding and collapsing rows and levels and persist expansion. 

Persist Expansion

Allows you to persist the expansions when you reopen a saved worksheet. This specifies whether detailed data is displayed in separate rows or columns from the parent data. 

Show Totals

Use this checkbox to add totals to the crosstab and specify whether the totals should be displayed at the top or bottom of the crosstab. The totals shown reflect any filters applied to the data. Select whether to show the Grand total only, or Grand total and subtotal,or both.Use the icons to select rows, columns, or both.

• You can view totals on Row, Column, or both for crosstabs in a chart. Use the icons to specify the axis/row/column for which you want to see the totals.

• You can also specify where the totals display, at the top or bottom of the crosstab. 

Show Alternate Row Highlight

Allows alternate row highlighting for crosstabs. You must select any one of the following to specify which dimensions you want to highlight: 

• Innermost Dimension: Select this option if you want to highlight alternate rows in the crosstab. 

• Outermost Dimension: Select this option if you want to highlight the outermost value of the outermost dimension and its subsequent children using the same color.

Heatmap Properties

Click the link if the heatmap feature is enabled in your installation. See Heatmap properties to configure a heatmap.