Olap-Grid Design Settings

Right-Click Menu (Edit Mode)

In Edit Mode, right-clicking on a Control allows you to configure detailed settings of the Control.

AUD PLATFORM EN > Olap-Grid Design > image2025-5-28_16-43-40.png

Menu Type	Description
Design	Opens the Design window that enables setting Olap-Grid components displayed on the screen.
DataSource	DataSource setup. (DataSource settings using i-META and SQL)
Convert	Shows transformable Controls depending on the selected Control type.

In Execution Mode, right-clicking on a Control allows you to configure detailed settings of the Control.

AUD PLATFORM EN > Olap-Grid Design > image2025-5-28_16-43-59.png

Menu Type

Description

Expand All

Displays all data for meta items placed in the row area.

Collapse All

Hides all data for meta items placed in the row area.

Totals Visibility Settings

Toggle the display of subtotals for rows/columns.

Switch Row / Column

Switch the positions of items in the row and column areas.

Style

Apply font styles created in the Style Editor.

Create calculated field

Add custom calculated field in the table.

Cache Information

Refresh: Request new data to update the cache and display the latest cache time.

Multi Headers

Use the menu when a header area needs to be modified.

Available menu only when a DataSource is bound. Otherwise, it's hidden.

Layout Manager

Rearrange the fields palced in the Olap-Grid.

Detailed Description of Layout Manager

AUD PLATFORM EN > Olap-Grid Design > image2025-5-28_16-44-21.png

Type	Detail Type	Description
Section	Hidden	Fields not visible on the analysis screen, but used to display data based on criteria applied in Hidden area. (The Hidden area allows you to organize data fields in your preferred layout when viewing analysis results) You can configure the Hidden area from the Layout Manager or the Field tab in the Design window.
	Filter	Filter condition area for partial analysis of the target data.
	Column	Items displayed in the column area of the analysis screen.
	Row	Items displayed in the row area fo the analysis screen.
	Data	Items used as data values in the analysis screen.
Icon		Text data
		Numeric data. (Refers to data where the field itself is in a numeric format within the editor(Source) when data is imported using SQL(Query) or i-META)
		Date data.

Design

Configure detailed properties for the various features available in the Control.