Using the advanced editor of the summary data mart wizard
The Advanced Editor of the summary data mart wizard is a JSON editor that includes the same values as of basic editor, but in the JSON format. You can view, add, and update the properties in this editor. While the Basic Editor includes all essential features to build a data mart, the Advanced Editor supports additional functionalities such as thresholds and tags.
To launch the Advanced Editor, click Advanced Editor toggle button in the summary page of the data mart wizard. All properties and values that were defined in other pages of the Summary Data Mart wizard are displayed in the Advanced Editor. Any changes that you make in the Advanced Editor are saved and reflected in other pages of the Summary Data Mart wizard.
The Advanced Editor consists of the following fields:
| 1 | Editor toggle | Use the toggle button to switch between the Basic and Advanced editors. | |
| 2 | Editor pane | Use this pane to add or update the properties and their values. | |
| 3 | Properties list | List of top level properties supported in the Advanced Editor. You can copy the code sample to the editor and make the required changes. |
|
| 4 | Search | Specify the property that you want to search for in the Advanced Editor. | |
| 5 | Home | Home button to navigate back to the list of properties | |
To use the advanced editor
- In the summary page of the Summary Data Mart wizard, click Advanced Editor.
In the Editor pane, all properties and values that were defined in the other pages of summary data mart wizard are displayed. - Review the properties and make the required changes:
- Update the values of existing properties.
- Add new properties:
- Search for the property in the help pane.
- Copy the code sample. You can either copy entire sample, or drag and drop the desired code to the editor.
- Make the necessary modifications to the sample code.
- Click Apply. If you receive any validation errors, correct the code and click Apply again.
The changes you made to the advanced editor are saved and reflected in the basic editor.
Properties
The following table lists the properties that can be used in the editor. While some properties can be configured in both basic and advanced editors, some properties are available in the advanced editor only.
| Property | Sub property Level 1 | Sub property Level 2 | Description | Requirement | Available/editable in the advanced editor only? |
|---|---|---|---|---|---|
| name | Name of the data mart. | Required | |||
| description | Description of the data mart. | Optional | |||
| structureid | Category of entity types to be included in the data mart. Specify SYS for System and WKLD for Business driver. | Required | |||
| entitytypenames | List of entity types for which to extract data. For details on all entity types, see Entity types. | Required | |||
| timefilter | Filter Used for specifying the time range of data extracted by the data mart. Four different types are supported. | Required | |||
| type | Type of the time filter to be used in the data mart. You can include one of the following values:
| Required | |||
| label | Label for the time filter. | Optional | |||
| resolution | Resolution used for summarization of data saved in the metric store. | Optional | |||
| globalfilterid | Unique identifier of the global time filter. You can check the list of available global filter IDs from Helix Capacity Optimization Console > Workspace > Filters. For details, see Managing time filters. Required when type = GLOBAL | Optional | |||
| since | Start date of the time range option (YYYY-MM-DD). Required when type = SINCE_TO | Optional | |||
| to | End date of the Time range option (YYYY-MM-DD). Required when type = SINCE_TO | Optional | |||
| lastex | Time filter definition based on the last 'x' hours, days, months, or years. Required when type = LASTEX | Optional | |||
| period | Type of last 'x' period. period: "H" for hours, "D" for days, "M" for months or "Y" for years | Required | |||
| quantity | Numeric value that specifies the last 'x' period to summarize. | Required | |||
| includeCurrent | Indicates if the time filter includes the current date. | Required | |||
| columns | Detailed information for each column (metric) included in the data mart. | Required | |||
| type | Type used to distinguish metrics. Valid values are: RESOURCE, GENERIC, THRESHOLD, GENERIC_DOMAIN, METADATA, FORECAST_RESULTS, SUPPORTED_GROWTH For a list of supported statistics for golden models, see Statistics for golden models. For a list of valid values for SUPPORTED GROWTH, see Metrics for SUPPORTED GROWTH. | Required | |||
| name | Unique name used to identify the column in this data mart. | Required | |||
| label | Label that can be used when displaying this column in the view or report. | Required | |||
| description | Detailed description of the column. | Required | |||
| statistics | Specify multiple statistics for the column. It takes an array of comma separated input values. The data mart result shows multiple values one each for the specified statistics. The following statistics are available for an ID, string, configuration, and performance metric:
Sample output:
| Optional | |||
| statistic | Statistic to use in the summarized output. Basic editor lists the statistics available for each metric | Optional | |||
| name | Name of the statistic. It represents a unique key with the statid field. Required when statid is null. | Required | |||
| statId | ID of the statistic. It represents a unique key with the name field. Required when name is null. | Optional | |||
| related_to | Used for identifying the name column corresponding to the unique id column of the data mart. | Optional | |||
| resname | Name of the resource (metric) in the catalog. | Optional | |||
| sub_resnames | Name of the subresource (metric) in the catalog. | Optional | |||
| tagtype | Name of the tag type in the catalog. | Optional | |||
| include_metadata | Name of the indicator metadata (metric) in the catalog. | Optional | Yes | ||
| include_statistic_ts | Used to include the timestamp associated to the statistic. The column displays the time when the value has reached it's peak for the first time in the given period. You can also verify the value by performing an analysis on the selected metric. This property is valid for MIN/MAX/PCTX statistics. The include_statistic_ts property cannot be used if the SLOPE statistic is selected. | Optional | Yes | ||
ref_resource_name | Name of the referenced subresource (bymetric) column. It is applicable to indicator resnames only. | Optional | Yes | ||
| parent_entity_type_name | Entity type of the parent or related entity to be extracted. To know the list of all entity types, see Entity types. | Optional | |||
| parent_relationship_id | Relationship of the parent or related entity to be extracted. | Optional | |||
| include_threshold_column | Indicates whether to include thresholds for this column. Applicable only if column type is RESOURCE. | Optional | Yes | ||
| sort_order | Precedence order for column sorting. | Optional | |||
| sort_direction | Direction to use for column sorting. You can include one of the following values:
| Optional | |||
| materializertask | Task used to materialize the content of the data mart. | Required | |||
| taskid | Identifier of the task used to materialize the content of the data mart. It is recommended to select a materializer task name using the Basic Editor. | Required | |||
| name | Name of the materialization task used to materialize the content of the data mart. It is recommend to select a task name using the Basic Editor. | Optional | |||
| class_name | Class name of the materialization task used to materialize the content of the data mart. | ||||
| entityfilterid | Unique identifier of the entity filter configured using the Capacity Optimization console. List of IDs are available from Workspace -> Filters section of the CO Console. It is recommended to set the Entityfilter using the Basic Editor. | Optional | |||
| domain | Columns with domain information | Optional | Yes | ||
| include_parent | Columns with Parent Domain information | Optional | Yes | ||
| parent_tags | List of parent tag type names | Optional | Yes | ||
| parent_tag.macro | The parent tag macro schema for data mart summary | Optional | Yes | ||
| root_parent_tag.macro | The root parent tag macro schema for data mart summary | Optional | Yes | ||
| root_application_tag.macro | The root application tag macro schema for data mart summary | Optional | Yes | ||
| root_business_service_tag.macro | The root business service tag macro schema for data mart summary | Optional | Yes | ||
| include_root_business_service | Columns with root business service information | Optional | Yes | ||
| root_business_service_tags | List of root business service tag type names | Optional | Yes | ||
| include_root_application | Columns with root application information | Optional | Yes | ||
| root_application_tags | List of root application tag type names | Optional | Yes | ||
| include_root_parent | Columns with root domain information | Optional | Yes | ||
| root_parent_tags | List of root parent tag type names | Optional | Yes | ||
| namespace | The virtual node namespace. Allowed values are opt:meas:vn and opt:meas | Optional | Yes | ||
| contextids | The scenario IDs for the golden model data mart columns. Only a single ID per data mart is supported. | Optional | Yes |
Statistics for golden models
| Statistic | Description |
|---|---|
| SUPPORTED_GROWTH | Residual capacity of a business driver related to correlated system utilization |
| DAYS_TO_SATURATION | Estimated days to saturation |
| DAYS_TO_SATURATION_UPPER_BOUND | Estimated days to saturation pessimistic. |
| CAPACITY | Estimated capacity (at different resolutions) |
| SATURATION_VALUE | Forecasted value at the saturation date |
| TREND | Estimated trend |
| PEAK_VALUE | Forecasted peak value |
| VALUE_30D | Forecasted value for 30 days from now |
| VALUE_60D | Forecasted value for 60 days from now |
| VALUE_90D | Forecasted value for 90 days from now |
| VALUE_120D | Forecasted value for 120 days from now |
| VALUE_180D | Forecasted value for 180 days from now |
| INPUT_SIZE | Input total size |
| INPUT_VALID_SIZE | Input size of valid samples |
| INPUT_SINCE_DAYS_AGO | Start date for input data as a difference from today |
| INPUT_TO_DAYS_AGO | End date for input data as a difference from today |
Metrics for SUPPORTED GROWTH
| Metric | Description |
|---|---|
| SG_ABS_VAL | The absolute value of supported growth that is expressed in units SG_ABS_VAL_UNIT. |
| SG_ABS_VAL_CONF_LOW | The absolute value of the lower bound of the confidence band that is calculated for the supported growth. |
| SG_ABS_VAL_CONF_HIGH | The absolute value of the upper bound of the confidence band that is calculated for the supported growth. |
| SG_ABS_VAL_UNIT | The units in which the absolute value of SG_METRIC is expressed. |
| SG_REL_VAL | The relative value of the supported growth. |
| SG_REL_VAL_CONF_LOW | The relative value of the lower bound of the confidence band calculated for the supported growth. |
| SG_REL_VAL_CONF_HIGH | The relative value of the upper bound of the confidence band calculated for the supported growth. |
| SG_REL_VAL_UNIT | The units in which the relative value of SG_METRIC is expressed. |
| SG_BOTTLENECK_RESOURCE | The most constraining resource for the predicted value of supported growth. |
| Capacity metrics | |
| SG_CAPACITY_VAL | Total capacity of the business driver metric that includes the supported growth. |
| SG_CAPACITY_UNIT | The units for the SG_CAPACITY_VAL metric. |
| SG_CAPACITY_OPERATOR | The value can be equal to or greater than indicating the meaning for the value specified in SG_CAPACITY_VAL. |
| Byentity metrics | |
| SG_BYENTITY_ID | The entity ID of the service pool or deployment that is associated with the business service. |
| SG_BYENTITY_BOTTLENECK_RESOURCE | The most constraining resource by service pool or deployment for the predicted value of supported growth. |
| SG_BYENTITY_ABS_VAL | The absolute value of supported growth of a service pool or deployment that is expressed in units SG_BYENTITY_ABS_VAL_UNIT. |
| SG_BYENTITY_ABS_VAL_CONF_LOW | The absolute value of the lower bound of the confidence band of a service pool or deployment that is calculated for the supported growth. |
| SG_BYENTITY_ABS_VAL_CONF_HIGH | The absolute value of the upper bound of the confidence band of a service pool or deployment that is calculated for the supported growth. |
| SG_BYENTITY_ABS_VAL_UNIT | The units in which the absolute value of SG_BYENTITY_METRIC is expressed. |
| SG_BYENTITY_REL_VAL | The relative value of the supported growth for a service pool or deployment. |
| SG_BYENTITY_REL_VAL_CONF_LOW | The relative value of the lower bound of the confidence band calculated for the supported growth. |
| SG_BYENTITY_REL_VAL_CONF_HIGH | The relative value of the upper bound of the confidence band calculated for the supported growth. |
| SG_BYENTITY_REL_VAL_UNIT | The units in which the relative value of SG_BYENTITY_METRIC is expressed. |
Comments
Log in or register to comment.