This topic describes how to edit dimensions and measures.

Edit a dimension

  1. You have logged on to the Quick BI console.

  2. On the Quick BI homepage, click Workspace in the top navigation bar to go to the Workspace page.
  3. In the left-side navigation pane of the Workspace page, click Datasets to go to the Datasets page.
  4. Select a dataset, click the dataset name or click the modify icon to go to the dataset edit page.
  5. Select a dimension, for example, order_level.
  6. In the Dimensions list of the Dataset pane, right-click a field or click the set icon corresponding to the field to open the field edit menu, as shown in the following figure.

    set
    Action Description
    Edit Edits the measure name and description.
    Duplicate Dimension Duplicates a dimension. The name of the duplicate dimension ends with Duplicate.
    Hide When Analyze Hides dimensions as needed.
    Show All Shows all dimensions.
    Delete Deletes a field.
    Create Calculated Field (Dimensions) Creates a dimension field and customizes its calculation method.
    Move To Moves a dimension to a hierarchy for drilling.
    Create Hierarchy Adds a dimension field to a new hierarchy.
    Move Up/Move Down Moves a dimension field. You can drag or right-click a field to move it.
    Convert to Measure Converts a dimension field to a measure field.
    Change Dimension Type You can switch the dimension type for a field between Date/Time (Source Format),Geo,String and Number.
    Note
    • If Geo is set to State/Province/Municipality, the province level and city level are both State/Province/Municipality, and the district level is District. For example, the value of the province field is Chongqing, the value of the city field is Chongqing, and the value of the district field is a district, such as Jiangbei district.
    • For example, you need to change the dimension type to Geo when you create a bubble map or a colored map. Otherwise, the map chart is not displayed properly.
    Note
    • You can duplicate, hide, and delete dimensions at different hierarchy levels.
    • You can set the start time for any day of a week in the week field.week

Edit a measure

  1. You have logged on to the Quick BI console.

  2. On the Quick BI homepage, click Workspace in the top navigation bar to go to the Workspace page.
  3. In the left-side navigation pane of the Workspace page, click Datasets to go to the Datasets page.
  4. Select a dataset, click the dataset name, or click the modify icon to go to the dataset edit page.
  5. Select a measure, for example, order_number.
  6. Right-click a dimension field or click the set icon corresponding to the field to open the field edit menu, as shown in the following figure.

    Edit menu
    Action Description
    Edit Edits the measure name and description.
    Duplicate Measure Duplicates a measure. The name of the duplicate measure ends with Duplicate.
    Hide When Analyze Hides measures as needed.
    Show All Shows all measures.
    Delete Deletes a field.
    Create Calculated Field (Measures) Creates a measure field and customizes its calculation method.
    Move To Moves a measure to an existing folder.
    Move Down Moves a measure field. You can drag or right-click a field to move it.
    Convert to Dimension Converts a measure field to a dimension field.
    Format Sets the display format for numbers.
    Default Aggregates Specifies the aggregate function. Aggregate functions include Sum, Maximum, and Minimum.
    Change Measure Type You can switch the measure type for a field between String and Number.