This section allows you to set additional feature options for the Olap-Gird.


< Olap-Grid Design (Others) - Detailed Information >

CategorySubcategoryDescription
Popup Menu




  • Menu settings available when right-clicking in the Olap-Grid screen during execution




Export to ExcelSets whether to allow exporting data to Excel when right-clicking in execute mode
Export to CSVSets whether to allow exporting data to CSV when right-clicking in execute mode
Export to TextSets whether to allow exporting data to Text when right-clicking in execute mode
Expand AllSets whether to expand all items palced in the row area when right-clicking in execute mode
Collapse AllSets whether to collapse all items palced in the row area when right-clicking in execute mode
FormattingSets whether to use data format settings window for fields placed in the Olap-Grid when right-clicking in execute mode
Totals Visibility SettingsSets whether to display totals in the Olap-Grid when right-clicking in execute mode
SortSets whether to enable sorting for fields placed in the Olap-Grid
Clear FilterClears all applied filters in the Olap-Grid
DesignSets whether to apply design changes
Analysis Items SettingsSets whether to enable the use of analysis items when right-clicking in execute mode
Formula EditorSets whether to enable adding calculated fields (Formula Editor) when right-clicking in execute mode
Switch Row / ColumnSwitches the positions of items in the row and column areas when right-clicking in execute mode
Layout ManagerRearrange fields placed in the Olap-Grid when right-clicking in execute mode
Custom ItemsAdds analysis items using filter formulas
Hiding

Sets field hiding



  • Hides certain conditional Measures when multiple Measure fields exist




StyleSets whether to apply styles when right-clicking in execute mode
Multi HeadersSets whether to apply multi headers when right-clicking in execute mode
Cache InformationRefreshes and checks cache information when right-clicking in execute mode
GroupSets whether to use group functionality
Filter ManagerSets whether to use filter management functionality
Other SettingsUse Hybrid Query

Whether to use Hybrid query



  • Provides faster performance by extracting and calculating only the minimum required data for calculation, compared to the traditinoal method (calculating based on all data)

  • Hybrid Query Execution Method

  • Extracts only the necessary columns for actual calculation based on Olap-Grid field arrangement
  • Utilizes DB aggregate function based on Olap-Grid field's aggregate functions
  • Automatically re-requests queries to the server when the Olap-Grid's arrangement changes
  • Utilizes caching functionality in conjunction with i-BIG depending on the original SQL query performance




Cache Expiry (minutes)Sets the cache expiry period
Cache Update (minutes)

Sets the cache refresh time



  • By configuring cache expiry and cache update times, users can adjust data updates according to their preferred schedule

  • Cache Expriy Time

Setting Value

Description

0

Does not use cache functionality
  - Always performs real-time data queries
  - Can be slow in data retrieval if quries are slow or data volume is large, as it accesses the DB for every request

-1

No cache expiry
  - If the cache update is not set, the initial data cache will be used continuously.
  - If the cache update cycle is set, the latest data will be automatically maintained according to that cycle.

Positive Integer (greater than 0)

Data cache is treated as valid only within a specific time (in minutes) from when it was created/refreshed
 - 1 hour : 60
 - 1   day : (24 * 60) = 1440

  • Cache Update Time

Setting Value

Description

-1

Does not perform cache update operations

0

Perform cache update operations every time a request occurs
  - Can maintain the latest data as much as possible.
  - Can lead to server overload if there are many requests.

Positive Integer (greater than 0)

Performs data cache update if the input value (minutes) is exceeded from the last cache update time.

  • Cache File Storage Location

  • Cache File Type

File Name(Extension)

Description

config.dat

Stores system information for the cache, including expiry cycle, creation date, access count, query information, etc.

.slice.zip

Stores the final data to be displayed on the screen; multiple files can be created depending on the OlapGrid state

.dat, .dat.bin

Stores query results, consisting of an index file and a data file for fast access.
These are the base data for all cached data and are used to identify if data is current during data integrity checks.

.hwp

Stores results output as a Hangul Word Processor file when data export is performed

.xlsx

Store results output as an Excel file when data export is performed

.jsonx

Stores data that can be used to generate Word, HTML, and i-AUD multi-control Excel files when data export is performed

  • Cache Refresh Procedure

※ Even if a cache cycle is set, it is not automatically refreshed by the system; it is performed manually by user request.




Activate Paging

Whether to use paging functionality



  • Defines the number of row records displayed per page to load data in pages

  • Provides fast querying by reducing initial loading time




Auto Sort

Whether to use auto-sort functionality



  • Activates the DB's sorting function (ORDER BY) to improve i-OLAP server calculation performance

  • Only available when Hybrid Query is enabled




Cache Mode

Sets the data cache management unit

- Private : Cache managed per report and data source

- Public : Cache managed per SQL query



  • Sets the cache management unit (per unit / global)

  • Cache File Types
    The i-OLAP server manages cache files based on options for faster result output, and there three types of caches

Data Cache

Manages SQL Execution results as files (binary files, extensions: index.dat, data.bin)

SLICE Cache

Manages OLAP calculation results (Slice format, XML, JSON data format) as files (compressed zip)

Export File Cache

Manages the Export file (xlsx, hwp, csv, text, etc) when the user invokes the Export function

  • Cache File Storage Location (Latest version includes embedded WAS)
    Default path : reports\[OLAP_CACHE_DATA]
    Path can be changed to “WEB-INF\classes\matrix\ application.conf” file's property (eg. cache.folder=d:\temp)
  • Checking and Updating Cache Information
    Cache information for the current Olap-Grid result screen can be checked in [Cache Information].
    Selecting [Refresh] deletes the existing cache and displays new calculated result.

Only when the OlapGrid's data source is metadata and 'Use Hybrid Query' in 'Other Settings' is enabled, the product internally operates Cache Mode in Private.





Export OptionsMax rows per sheet

Sets the maximum number of rows per sheet when exporting

0: Exports all rows regardless of the maximum number of row setting.

(default) (When configured; Minimum value: 1 ~ Maximum value: 1,000,000)



  • Defines the maximum number of rows that can be displayed on one sheet during Excel export




Disable Merge

Disables all merging when exporting



  • Exports merged cell data from the screen as individual cells




Use server retrieval when exporting

Sets whether to use a server query when exporting



  • Selects this option when performing a full data export, not just exporting the data displayed on the screen