This menu provides options for configuring the visible aspects of the Olap-Grid screen.

< Olap-Grid Design (Option) - Detailed Description >

CategorySubcategoryDescription
Totals




  • Olap-Grid totals consist of subtotals and grand totals, with aggregation settings for each Row / Column

Filter Area

The area for analysis items that require specific query conditions

Column Area

The area where analysis items are horizontally arranged

Grand Total

The grand total of measures across all analysis dimensions

Data Area

The area where measure items are displayed

Layout Manager

Manages the arrangement settings for analysis items

Header

The area where dimension items are visible

Row Area

The area where dimension items are viertically arranged

Subtotal

Subtotal of measures for each analysis dimension

Body

The area where data is visible






Hide Subtotal for Single ItemSets whether to display subtotals when there is only one item to subtotal
Show Total for ColumnsSets whether to configure subtotals/totals for column area
Position of Subtotal for ColumnsThe position of the subtotal in the column area
Position of Column Grand TotalThe position of the grand total in the column area
Grand Total for Columns TextsThe text displayed for the grand total in the column area
Texts for the Subtotal for ColumnsThe text displayed for the subtotal in the column area
Show Total for Row

Sets whether to configure subtotals/totals for row area

Position of Subtotal for RowsThe position of the subtotal in the row area
Position of Grand Total for RowsThe position of the grand total in the row area
Texts for the Grand Total for RowsThe text displayed for the grand total in the row area
Texts for the Subtotal for RowsThe text displayed for the subtotal in the row area
Action




Auto-Expansion

Sets whether to expand fields automatically on initial loading

Set to True : Expands all, Disbale True : Collapses all



  • Configures the Olap-Grid structure to be displayed as a tree view or to expand all items for viewing.




Chart Source

Sets whether to display subtotals and grand totals in charts linke to the Olap-Grid



  • Controls whether subtotal or grand total data are displayed on the chart




Draggable for Cell Width

Sets to allow adjusting spacing by dragging cell boundaries

Sets whether to activage cell width adjustment functionality



  • Sets to allow adjusting spacing by dragging cell boundaries




Viewer Type

Sets the display method for meta item placed in the horizontal area (Default, TreeView)



  • Selects the display method for hierarchical items
  • Default Type



  • TreeView Type




Max Depths for Chart Label Field

The number of field hierarchy levels to be displayed in the chart label

- Analysis items are displayed starting from the highest dimension (Located at the front)

- Displays all levels of the hierarchy when its value is ‘-1’



  • Defines the number of analysis dimensions that can be displayed in the chart




Enable Column's SortSets whether to activate the display of the sort button on the header cells of fields placed in the Column area.
Auto Selection AreaEnable

Sets whether to activate Auto Seletion Area feature

  • A feature that automatically selects a specific area for a particular purpose when the Olap-Grid loads

  • The selected area is linked to the chart's output range and used accordingly



Range

Sets the selection range for the Auto Selection Area



  • How to set the Auto Selection Area range


Ex 1.

Ex 2.


  • Chart is generated with the selected area on initial load




Design






  • Sets Olap-Grid screen area names, area display, value display method, etc.
  • Vertical alignment is applied only to cells that merge multiple rows




Show Expand Button

Show / Hide data expansion button



  • Sets whether to create data expansion buttons in the header area




Scroll Bar StyleSets the style of the Olap-Grid's scrollbar
Position of Values Header

Sets the placement area of value fields

  • This feature allows you to specify the initial position (Row or Column) for the value(Measure) header
    when more than one field is added to the Dtat area in the Olap-Grid's Design Field menu, after it was initially set with only on field.
    (This option is only available when the Olap-Grid is first created with a single field in the Data area)


Distinguishing Name for Row AreaSets the text for the row area
Distinguishing Name for Column Area
Sets the text for the column area
Distinguishing Name for Values Area
Sets the text for the data area
Distinguishing Name for Filter Area
Sets the text for the filter area
Row HeightSets the item height of row area (Header : header area / Body : data area)
Visibility of AreaSelects the areas to be displayed in the Olap Grid
Texts for Null CellsSets the text to substitute when data values are null
Texts for Invalid CellsSets the text to dispaly in invalid cells
Texts for Division by Zero ErrorSets the text to display in cells that result from a divide-by-zero error
Texts for Error CellsSets the text to display in cells with data errors
Align Vertically (Row Headers)Sets the header position for the row area
Align Vertically(Column Headers)Sets the header position for the column area