AUD PLATFORM EN
페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동


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


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

CategorySubcategoryDescription
Popup Menu
Detailed Information for Popup Menu
 Click to View Detailed Information

Detailed Information for 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

Detailed Information for Hiding
 Click to View Detailed Information

Detailed Information for 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

Detailed Information for Use Hybrid Query
 Click to View Detailed Information

Detailed Information for 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

Detailed Information for Cache Expiry/Update Period
 Click to View Detailed Information

Detailed Information for Cache Expiry/Update Period

  • 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

Detailed Information for Activate Paging
 Click to View Detailed Information

Detailed Information for Activate Paging

  • 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

Detailed Information for Auto Sort
 Click to View Detailed Information

Detailed Information for Auto Sort

  • 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

Detailed Information for Cache Mode
 Click to View Detailed Information

Detailed Information for Cache Mode

  • 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.

Cache Mode Exceptions Notice

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)

Detailed Information for Max rows per sheet
 Click to View Detailed Information

Detailed Information for Max rows per sheet

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

Disable Merge

Disables all merging when exporting

Detailed Information for Disable Merge
 Click to View Detailed Information

Detailed Information for Disable Merge

  • Exports merged cell data from the screen as individual cells

Use server retrieval when exporting

Sets whether to use a server query when exporting

Detailed Information for Use server retrieval when exporting
 Click to View Detailed Information

Detailed Information for Use server retrieval when exporting

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

  • 레이블 없음