This topic describes how to edit dimensions, such as date and time dimensions, geographic dimensions, and image dimensions.

Prerequisites

A dataset is created. For information about how to create a dataset, see Create a dataset.

Go to the dimension editing page

  1. In the top navigation bar, click Workspace. On the page that appears, click Datasets in the left-side navigation pane.
  2. On the Datasets page, click the name of the dataset that you want to manage.
    You can also click the modify icon in the Actions column. Edit
  3. In the left-side navigation pane, find the dimension that you want to manage in the Dimensions list and click the Settings icon next to the dimension name. Then, you can perform the following operations on the dimension. The icon marked with ① in the following figure is the Settings icon.
    In this example, the order_level dimension is edited. Settings icon
    Operation Description
    Edit Modify the name and description of the dimension.
    Duplicate Dimension Clone the dimension. The name of a duplicate dimension contains _Duplicate.
    Hide When Analyze Hide the dimension based on your business requirements.
    Show All Show all the dimensions in the list, including the hidden dimensions.
    Delete Delete the dimension.
    Create Calculated Field (Dimensions) Create a dimension and customize a calculation expression for the dimension.
    Move To Move the dimension to an existing hierarchy. Before you configure the data drilling feature for a chart, you must move the required dimensions to the same hierarchy.
    Create Hierarchy Create a hierarchy and move the dimension to the created hierarchy.
    Move Up/Move Down Move the dimension up or down. You can also drag the dimension to move it.
    Convert to Measure Convert the dimension to a measure.
    Change Dimension Type Change the dimension type to Date/Time (Source Format), Geo, String, Number, or image.
    Sort Select a sorting method to sort the dimensions in the list.
    Note You can also clone, hide, and delete dimensions in a hierarchy.

Edit date and time dimensions

  • Configure the First Day of Week parameter for the report_date(week) dimension to specify the first day of the week. week
  • Click Synchronize date granularity to add the report_date(ymdhms) dimension.
    The report_date(ymdhms) dimension is added to the dimension list. If your dataset does not have the report_date(ymdhms) dimension, you can click the Settings icon next to report_date and select Synchronize Date Granularity to add the report_date(ymdhms) dimension. If your dataset is created in Quick BI V3.7.3 or later, report_date(ymdhms) is displayed by default. Synchronize date granularity
  • Configure the Date display format parameter for the report_date(ymdhms) dimension. Edit report_date
    Note The following three formats are supported:
    • yyyyMMdd HH:mm:ss
    • yyyy-MM-dd HH:mm:ss: By default, this format is used.
    • yyyy/MM/dd HH:mm:ss

    The value of the Date display format parameter does not affect the date and time format of the source data. The setting takes effect only on the date and time format that is used in search condition fields. For example, you set Date display format to yyyy/MM/dd HH:mm:ss. In this case, the date and time values specified in a search condition field are in the yyyy/MM/dd HH:mm:ss format, as shown in the red box in the following figure.

    In this example, the profit of each province in the specified time range is queried. yyyy/MM/dd HH:mm:ss

Edit geographic dimensions

When you create a geo map chart, such as a bubble map or a colored map, dimensions that specify geographical information such as area, province, and city are required. The data type of these dimensions must be Geo.

Note If a dimension is marked with the Geo type icon, the data type of the dimension is Geo.
  1. In the left-side navigation pane of the dataset editing page, find the geographic dimension that you want to manage in the Dimensions list and click the set icon next to the dimension name.
    • For an area dimension, choose Change Dimension Type > Geo > Region. area
    • For a province dimension, choose Change Dimension Type > Geo > State/Province/Municipality. province
    • For a city dimension, choose Change Dimension Type > Geo > City. city
  2. Optional:Create a hierarchy.
    If you use a hierarchical structure for the dataset, you can perform the following steps to create a hierarchy:
    1. In the Dimensions list, find the geographic dimension that you want to manage, click the set icon next to the dimension name, and then click Create Hierarchy.
      Create Hierarchy
    2. In the Create Hierarchy dialog box, enter a hierarchy name and click OK. In this example, the name is set to area_Hierarchy.
    3. Find a dimension that you want to move to the new hierarchy, click the set icon next to the dimension name, and then choose Move To > area_Hierarchy. Repeat this procedure to move other dimensions to this hierarchy.
      Move a dimension
      The following figure shows the hierarchy and the dimensions in the hierarchy. area_Hierarchy
  3. After you edit all the items that you want to edit, click Save in the upper-right corner of the page.
    save
  4. Click Refresh Preview.
    The data in the dataset is automatically updated. Refresh Preview button

Edit an image dimension

An image dimension in a dataset stores the URLs of the images. If you want to use images, you must upload the images to an image storage service and obtain the URLs of the images.

When you configure a dataset for a cross table or a leaderboard that contains images such as product images, you can create a dimension to store the URLs of the images and set the dimension type to image.

Note If a dimension is marked with the 2 icon, the data type of the dimension is image.

If images cannot be displayed in a cross table, check whether the cross-origin resource sharing (CORS) feature for the image storage service is enabled. If the CORS feature is not enabled, enable it. For example, enable the CORS feature for the Object Storage Service (OSS) bucket that stores the images.

  1. In the left-side navigation pane of the dataset editing page, find the dimension that you want to manage in the Dimensions list and click the set icon next to the dimension name.
  2. Choose Change Dimension Type > image.
    In this example, the dimension name is product_image. 3
  3. After you edit all the items that you want to edit, click Save in the upper-right corner of the page.
    save
  4. Click Refresh Preview.
    The data in the dataset is automatically updated. 5