AUD PLATFORM EN
페이지 트리

버전 비교

이전 버전 7

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

에 저장

비교대상

새 버전 현재

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

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.
댓글: 더 자세한 내용은 링크로 대체

...

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.

  • 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

    패널note
    borderStylesolid
    titleDetailed Information for Primary Calc.
    펼치기
    titleClick to View Detailed Information
    참고사항
    titleDetailed Information for Primary Calculation
    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

    Image Removed

    For more information, please refer to Olap Primary Calculation page.


    Summary (Total)

    Specifies a separate calculation method for totals or subtotals

    Detailed Information for

    For more information, please refer to Olap 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

    패널note
    borderStylesolid
    titleDetailed Information for Summary(Total)
    펼치기
    titleClick to View Detailed Information
    참고사항
    title
    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

    Image Removed

    Aggregation

    page.


    Aggregation Type (Query)

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

    Detailed Information for

    For more information, please refer to Olap 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.

    Image Removed

    page.

    패널note
    borderStylesolid
    titleDetailed Information for Aggregation Type(Query)
    펼치기
    titleClick to View Detailed Information
    참고사항
    title


    Secondary Calc.

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

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

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

    • Secondary Calculation Function

    패널note
    borderStylesolid
    titleDetailed Information for Secondary Calculation
    펼치기
    titleClick to View Detailed Information
    참고사항
    titleDetailed Information for Secondary Calculation
    Secondary Calc. FunctionDescriptionBase Field Needed

    None

    No calculation based on aggregation

    N/A

    Absolute

    Returns the absolute value

    N/A

    Percent

    Returns the 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 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 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

    Image Removed

    For more information, please refer to Olap Secondary Calculation page.


    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

    패널note
    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

    Image Removed

    • How to run the Formula Editor

    Image Removed

    For more information, please refer to Olap Formula page.


    Header Visibility Formula

    Defines formulas to perform item hiding

    패널note
    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

    Image Removed

    For more information, please refer to Olap Formula page.


    Ref's FormulaWrite a formula to referenceSortDefines the data sort order for the field (descending, ascending)Sort fieldDefines which field to use for sorting logic (ex: Select Analysis Item 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 [Dimension 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 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 consistency (Number, String, etc.)

    Save Mode

    When using CRUD operations, sets the data 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 fieldUse Chart SourceSets whether the field's data is linked to a chartText 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 subtotalsHeader Cell Style (Total Cell)Specifies the style of subtotals within the row/column header areaData Cell Style (Cell)Specifies the style for regular cells of the corresponding field within the data areaData Cell Style (Total Cell)Specifies the style for subtotal cells of the corresponding field within the data areaData Cell Style (Grand Total)Specifies the style for grand total cells of the corresponding field within the data areaTooltip Field NameSets the tooltip text for the field nameTooltip TextSets the text to be displayed as a tooltipLanguage CodeSets the filed name for the corresponding foreign language code when using foreign languagesFormat Language CodeSets the foreign language format code

    ...