AUD PLATFORM EN
페이지 트리

버전 비교

이전 버전 3

changes.mady.by.user 영문 가이드 작성자

에 저장

비교대상

새 버전 4

changes.mady.by.user 영문 가이드 작성자

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.
댓글: 이미지 영문으로 변경

...

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

Image RemovedImage Added


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

CategorySubcategoryDescription
Popup Menu


패널
borderStylesolid
titleDetailed Information for Popup Menu


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Popup Menu

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

Image RemovedImage Added




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

패널
borderStylesolid
titleDetailed Information for Hiding


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed 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

패널
borderStylesolid
titleDetailed Information for Use Hybrid Query


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed 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

Image RemovedImage Added

  • 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

패널
borderStylesolid
titleDetailed Information for Cache Expiry/Update Period


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed 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

Image RemovedImage Added

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

Image RemovedImage Added

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

Image RemovedImage Added

※ 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

패널
borderStylesolid
titleDetailed Information for Activate Paging


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed 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

Image RemovedImage Added




Auto Sort

Whether to use auto-sort functionality

패널
borderStylesolid
titleDetailed Information for Auto Sort


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed 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

Image RemovedImage Added




Cache Mode

Sets the data cache management unit

- Private : Cache managed per report and data source

- Public : Cache managed per SQL query

패널
borderStylesolid
titleDetailed Information for Cache Mode


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Cache Mode

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

Image RemovedImage Added

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

Image RemovedImage Added

정보
titleCache 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)

패널
borderStylesolid
titleDetailed Information for Max rows per sheet


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Max rows per sheet

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

Image RemovedImage Added




Disable Merge

Disables all merging when exporting

패널
borderStylesolid
titleDetailed Information for Disable Merge


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Disable Merge

  • Exports merged cell data from the screen as individual cells

Image RemovedImage Added




Use server retrieval when exporting

Sets whether to use a server query when exporting

패널
borderStylesolid
titleDetailed Information for Use server retrieval when exporting


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed 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

Image RemovedImage Added