[]
        
(Showing Draft Content)

Add a SubDate Column

You can generate a SubDate column from a database date column and a specified date function.

If the column is a date type, then subdate functions that include hours and minutes cannot be selected. The calculated new column will be text type. The second parameter of the WeekNum function is 0.

Add a SubDate Column

Follow the below steps to add a SubDate column to the entity.

  1. From the Entities panel on the left, select the 'DimDate' entity.

  2. Click the More button and then select the Add SubDate Column option from the list.


    Select the Add SubDate Column option


    Add SubDate Column dialog box is displayed.

    Add Aggregation Column Dialog Box

  3. Enter the Name of the new subdate column.

  4. Select the columns of the current table from the Field dropdown list. It has only date or date-time type fields. When the field type is a date, time-related sub-dates are not displayed in the Sub Date dropdown list.

  5. Select the option from the Sub Date dropdown list.


    The WAX expression will be generated automatically.


    WAX Expression for SubDate Autogenerated

  6. Click the Add button. The added subdate column will be displayed under the chosen entity in the Entities panel along with its other attributes.


    Newly added aggregation column

    Note: You cannot edit the autogenerated WAX expression here, but you can copy it.

Edit a SubDate Column

Follow the below steps to edit a subdate column in an entity.

  1. From the Entities panel, select the entity which contains the subdate column you want to modify.

  2. Click the Edit button next to the chosen subdate column.

    Edit subdate column


    Edit SubDate Column dialog box is displayed.


    Edit subdate column dialog box

  3. Update the existing details as per the requirement, and press the Save button.

Delete a SubDate Column

Follow the below steps to delete a subdate column from an entity.

  1. From the Entities panel, select the entity which contains the subdate column you want to delete.

  2. Click the Delete button next to the chosen subdate column.

    Delete subdate column button


    Delete SubDate Column dialog box is displayed.


    Delete subdate column dialogbox

  3. In the Delete Calculated Column dialog box, click the Yes button to confirm.