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

이 페이지의 이전 버전을 보고 있습니다. 현재 버전 보기.

현재와 비교 페이지 이력 보기

« 이전 버전 2 다음 »


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)
    기본 경로 : reports\[OLAP_CACHE_DATA]
    경로 변경은 “WEB-INF\classes\matrix\ application.conf” 파일의  속성으로 변경 가능 (eg. cache.folder=d:\temp)
  • 캐시 정보의 확인 및 업데이트
    현재 Olap-Grid의 결과 화면에 대한 캐시 정보는 [캐시 정보]에서 확인 가능
    [새로 고침] 항목 선택 시 기존 캐시를 삭제하고, 새로 계산 수행한 결과 확인 가능

Cache Mode 예외 사항 안내

OlapGrid의 데이터소스가 메타이며, 기타 설정 > Use Hybrid Query 가 활성화 되어 있는 경우에 한하여 제품 내부에서 Cache Mode가 Private인 모드로 동작합니다.

Export OptionsMax rows per sheet

내보내기 시, 시트별 최대 행 수 설정

0: 최대 행 수 설정과 상관없이 모든 행이 다 내보내집니다.

(default) (설정 시 최소값: 1 ~ 최대값: 백만(1,000,000))

시트별 최대 행수 상세 정보
 클릭하여 상세 설명 보기

시트별 최대 행수 상세 정보

  • 엑셀 내보내기 시 한 시트에 표현할 수 있는 최대 레코드 행수 정의

Disable Merge

내보내기 시, 병합 사용 안함

Disable(셀 병합) 상세 정보
 클릭하여 상세 설명 보기

Disable(셀 병합) 상세 정보

  • 화면 상의 병합된 셀 데이터를 각각의 셀 단위로 분할하여 내보내기

Use server retrieval when exporting

내보내기 시, 서버 쿼리 사용 여부 설정

서버 쿼리 사용 상세 정보
 클릭하여 상세 설명 보기

서버 쿼리 사용 상세 정보

  • 화면 상의 데이터 내보내기가 아닌 전체 데이터 내보내기 수행 시 선택

  • 레이블 없음