AUD PLATFORM EN
페이지 트리

버전 비교

이전 버전 6

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

에 저장

비교대상

새 버전 7

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

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.
댓글: 오타 수정

...

TypeDescription

New

Add a new field

Delete

Delete the selected field

Refresh

Refresh the fields information (Availabe Available when using SQL.)



< Olap-Grid Design (Field) - Detailed Description >

TypeDescription
CaptionData field name to be displayed on the screen
Field NameThe unique name of the field. Must be unique within the screen.
Primary Calc.

Specifies the aggregate function applied to grouped data in the Pivot Screen.

패널
borderStylesolid
titleDetailed Information for Primary Calc.


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Primary Calculation
  • Defines group aggregate functions (Sum, Max, Min, etc.) based on dimension items.
  • Primary Calculations are performed on the Olap server, not by the query.

  • Primary Calculation functions

    AggregationDescription

    None

    No calculation based on aggregation

    Sum

    Total value

    Min

    The minimum value

    Max

    The maximum value

    Average

    The average value

    Count

    Number of data records

    Calculate

    Automatically changes to Calculate when a formula is written for the property. Do not arbitrarily set this value.

    DistinctCount

    Number of data records after removing duplicate values

    Text

    Returns the field value of the first record in text





Summary (Total)

Specifies a separate calculation method for totals or subtotals

패널
borderStylesolid
titleDetailed Information for Summary(Total)


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Summary(Total)

  • Defines Subtotal Calculation using a separate function, distinct from the primary calculation aggregation.

  • Subtotal Calculations are performed on the Olap server, not by the query.

  • Subtotal Calculation functions

    Subtotal MethodDescription

    None

    No specific calculation applied(Use Primary Calc. Aggregation)

    SumOfChild

    Sum of child dimension items

    MinOfChild

    The minimum value of child dimension items

    MaxOfChild

    The maximum value of child dimension items

    AverageOfChild

    The Average value of child dimension items

    CountOfChild

    Number of data records for child dimension items





Aggregation Type (Query)

Specifies a Group function to be used in SQL (Applied in Hybrid Query)

패널
borderStylesolid
titleDetailed Information for Aggregation Type(Query)


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Aggregation Type(Query)

  • Aggregation on the screen is processed first by the aggregation function defined in the metadata's analysis item, then by the Hybrid aggregate function.





Secondary Calc.

Configures advanced analysis functions (SubTotalPercentOfRow, RunningSum, ...)

Used for additional operations based on the results of the Primary Calculation.

패널
borderStylesolid
titleDetailed Information for Secondary Calculation


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Secondary Calculation

  • Secondary Calculation functions are applied when the Olap server recalculates data that has already undergone Primary Calc. aggregation by SQL

  • Secondary Calculation Function

    Secondary Calc. FunctionDescriptionBase Field Needed

    None

    No calculation based on aggregation

    N/A

    Absolute

    Returns the absolute value

    N/A

    Percent

    Returns the percentageof percentage of the Grand Total value

    N/A

    PercentOfColum

    Returns the percentage of the Colum Total value

    N/A

    PercentOfRow

    Returns the percentage of the Row Total value

    N/A

    SubTotalPercentOfColumn

    Returns the percentage of the Group Column Total value

    N/A

    SubTotalPercentOfRow

    Returns the percentage of the Group Row Total value

    N/A

    RunningAverage

    Returns the moving average based on cumulative values within the group

    Needed

    RunningCount

    Returns the number of data records based on cumulative values within the group

    Needed

    RunningMax

    Returns the maximum value based on cumulative valuse values within the group

    Needed

    RunningMin

    Returns the minimum value based on cumulative value within the group

    Needed

    RunningProduct

    Returns the product of values based on cumulative values within the group

    Needed

    RunningSum

    Returns the sum values based on cumulative values within the group

    Needed

    FirstPeriod

    Returns the measure value of the first member within the group (period dimension)

    Needed

    LastPeriod

    Returns the measure value of the last member within the group (period dimension)

    Needed

    PeriodIncrease

    Returns the increase/decrease value compared to the previoous previous member's measure value within the group (period dimension)

    Needed

    PeriodIncreaseRate

    Returns the increase/decrease rate compared to the previous member's measure value within the group (period dimension)

    Needed





Format

Configures the data format to be applied to the field (Number, Currency, Percent, Percent, Exponential, DateTime)

패널
borderStylesolid
titleDetailed Information for Format


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Format

  • Allows users to change data values into desired format, such as Number, Currency, Percent, Exponential, or DateTime formats, including decimal place notation

  • Format Editor Description

    TypeDescription

    Category

    - Number: General number format (decimal places configurable)

    - Currency: Currency (\) (decimal places configurable)

    - Percent: Percentage (%) (decimal places configurable)

    - Exponential: Exponential (e.g., 1.2E+005) (decimal places configurable)

    - Date Time: Time (decimal places not configurable)

    Preview

    Preview of currently selected number display format

    Quick format

    One of the pre-defined formats selected by users

    Format

    User-defined format

    The precision of decimal

    Number of decimal places





Field Type

The type of field to be displayed in the Olap-Grid

Specify from [Dimension : Analysis, Measure : Value, Attribute : Property, Period : Time]

Formula

Defines formulas for calculated fields

패널
borderStylesolid
titleDetailed Information for Formula


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Formula

  • Used when creating new Analysis Item / Data Item in the Olap-Grid and defining data values

  • How to run the Formula Editor




Header Visibility Formula

Defines formulas to perform item hiding

패널
borderStylesolid
titleDetailed Information for Header Visibility Formula


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Header Visibility Formula

  • Used to hide certain conditional measures when multiple measure fields exist




Ref's FormulaWrite a formula to reference
SortDefines the data sort order for the field (descending, ascending)
Sort fieldDefines which field to use for sorting logc logic (ex: Select Analysis Item Name→Analysis Name → Analysis Item Code)
UnitSpecifies the unit if the field type is ‘Measure’ (1,10,100,1000, etc.)
Movable Range

Specifies the areas where the field can be positioned in the execution screen (Filter, Column, Row, Data)

패널
borderStylesolid
titleDetailed Information for Movable Range


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Movable Range

  • Sets the movable range for dimension/measure items, when using multidimensional analysis.

※ Once an area is checked, the item can be moved to the checked area. (Unless the function property is also checked)
※ Select all the positions where the item should be appeared on the report




Functions

Selects functions available for analysis item on the screen (Sortable, Filterable, Movable)

패널
borderStylesolid
titleDetailed Information for Functions


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Functions

  • Configures available functions (Sortable, Filterable, Movable) for the selected item in the analysis screen and popup menu

  • Sortable : Function to apply descending/ascending order to items within a dimension
  • Filterable : Function to select the query range for items within a dimension
  • Movable :  Function to move dimension/measure areas

  • How to set and clear filters
    Click the filtering icon in the [Dimension Header] - Apply using [DimensionFilterDimension Filter]
    Clear Filter in the popup menu is only shown when filter settings exist




In Dimensions

Separately calculates data based on specific conditions among data retrieved through relationships among tables

(Applicable if field type is Measure)

패널
borderStylesolid
titleDetailed Information for In Dimension


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for In Dimension

  • Used to compensate for unintened unintended aggregation errors during Olap-Grid data aggregation




Width

Specifies the width within the Olap-Grid after filed placement

Width can be set for a single item or multiple items simultaneously

When setting simultaneously, configured items should be in the same area.

Mininize

Configures field hiding

Key Type

Set the Key type of the field

Required when using Olap-Grid as CRUD Base

Data Type

Set the data type of the field

When using CRUD operations, defines criteria for input value consitency consistency (Number, String, etc.)

Save Mode

When using CRUD operations, sets the data svae save mode (All, InsertOnly, UpdateOnly)

패널
borderStylesolid
titleDetailed Information for Save Mode


펼치기
titleClick to View Detailed Information


참고사항
titleDetailed Information for Save Mode

  • Configures saving method when inputting/modifying data for the selected field

TypeDescription
AllSaves both new and modified data
InsertOnlySaves only newly added data
UpdateOnlySaves only data that has been modified





Show SubtotalSets whether to display subtotals for data included in the field
Use Chart SourceSets whether the filedfield's data is linked to a chart
Text AlignmentSpecifies data value alignment (Center, Left, Right)
Align HeadersSets header text alignment (Center, Left, Right)
Header Cell Style (Cell)Specifies the style of the row/column header area, Applies to regular cells, not subtotals
Header Cell Style (Total Cell)Specifies the style of subtotals within the row/column header area
Data Cell Style (Cell)Specifies the style for regular cells of the corresponding field within the data area
Data Cell Style (Total Cell)Specifies the style for subtotal cells of the corresponding field within the data area
Data Cell Style (Grand Total)Specifies the style for grand total cells of the corresponding field within the data area
Tooltip Field NameSets the tooltip text for the field name
Tooltip TextSets the text to be displayed as a tooltip
Language CodeSets the filed namef name for the corresponding foreign language code when using foreign languages
Format Language CodeSets the foreign language format code

...