The following video (3:48) illustrates the process of creating a SQL-based custom data mart that can be used to build a custom view in the TrueSight console.
Access the Data marts page. For more details, see Managing data marts for custom views, reports, and report templates.
On the Data marts list page, select Add > Data mart based on SQL.
The Data marts wizard is displayed.
On the Welcome page, under the Purpose of data mart, select Build Capacity View in TrueSight Console.
Under the Content of data mart, select one of the following options:
On the Configuration page, set values for the following properties.
By default, the Basic properties are displayed on the Configuration page. For viewing the Advanced properties, select the Advanced tab of this table.
Basic properties
Field | Description |
---|---|
Name | Type the required name for the data mart. Only alpha numeric values are allowed. |
Description | Type the required description for the data mart. |
Primary entities | Select any one of the following options:
|
SQL Query | Type SQL query to retrieve the required data by selecting the required columns of a table. Tip To display filter for the columns in the view in the TrueSight Console, you can use a query that contains a filter macro. For more details about filter macro, see Using filter macros with SQL queries. |
To view or configure the Advanced properties, click Advanced. You do not need to set or modify this property unless you want to modify the list of data marts on which this data mart is dependent. This property is for advanced users and scenarios only.
Advanced properties
Field | Description |
---|---|
Dependencies |
Select the required dependencies from the Data marts table, and add them to the Selected dependencies table using the >> button. In the Selected dependencies table, select the required dependencies, and add them to the Data marts table by using the << button. |
Click Next.
On the Columns page, you can perform the any one of the following steps to modify the properties of output column or proceed to Step 8:
In the Output Columns section, click the name of the required column to modify the meaning and associated properties of the columns.
The Editor of column with name: columnName page is displayed.
If the Meaning is set to any option other than None, set values for the following properties and click Apply.
By default, the Basic properties are displayed on the Columns page. These are the most common properties and it is acceptable to leave the default selections for each as is. For viewing the Advanced properties, select the Advanced tab of this table.
Basic properties
Field | Description |
---|---|
Label | Type the required label for the column. |
Description | Type the required description for the column. |
To view or configure the Advanced properties, click Advanced. You do not need to set or modify these properties unless you want to change the meaning of the column. These properties are for advanced users and scenarios only.
Advanced properties
Meaning option | Description |
---|---|
Output column | |
Value | Select this option if the output column contains a value that is a statistic derived from a metric. Following options are displayed when you select Value as the Meaning:
|
Identifier | |
System Identifier | Select this option to set the meaning as system identifier of the systems that are being evaluated. Following options are displayed when you select System Identifier as the Meaning:
|
Workload Identifier | Select this option to set the meaning as workload identifier of the systems or clusters that are being evaluated. Following options are displayed when you select Workload Identifier as the Meaning:
|
Domain Identifier | Select this option to set the meaning as Domain identifier of the systems or clusters that are being evaluated. Following options are displayed when you select Domain Identifier as the Meaning:
|
Name | |
System Name | Select this option to set the meaning as system name of the systems or clusters that are being evaluated. When you select System Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Workload Name | Select this option to set the meaning as workload name of the systems that are being evaluated. When you select Workload Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Domain Name | Select this option to set the meaning as domain name of the systems that are being evaluated. When you select Domain Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Type Identifier | |
System Type Identifier | Select this option to set the meaning as system type identifier of the systems or clusters that are being evaluated. When you select System Type Identifier as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Workload Type Identifier | Select this option to set the meaning as workload name of the systems that are being evaluated. When you select Workload Type Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Domain Type Identifier | Select this option to set the meaning as domain type identifier of the systems that are being evaluated. When you select Domain Type Identifier as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Type Name | |
System Type Name |
Select this option to set the meaning as system type name of the systems or clusters that are being evaluated. When you select System Type Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Workload Type Name | Select this option to set the meaning as workload type name of the systems that are being evaluated. When you select Workload Type Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Domain Type Name | Select this option to set the meaning as domain type name of the systems that are being evaluated. When you select Domain Type Name as the Meaning, the Filter behavior field is displayed with the value set as Distinct Values. |
Other | |
Timestamp | Select this option if the value in the column indicates a timestamp for any activity. No additional options are displayed when you select Timestamp as the Meaning. |
Threshold Good | Select this option if the value in the column indicates good threshold value for any metric. No additional options are displayed when you select Threshold Good as the Meaning. |
Threshold Warning | Select this option if the value in the column indicates good threshold value for any metric. No additional options are displayed when you select Threshold Warning as the Meaning. |
If the Meaning is set to None, set values for the following properties and click Apply.
By default, the Basic properties are displayed on the Columns page. These are the most common properties and it is acceptable to leave the default selections for each as is. For viewing the Advanced properties, select the Advanced tab of this table.
Basic properties
Field | Description |
---|---|
Meaning | Select the required option to be set as the meaning. For more details about the available options, see Advanced tab in the previous table. |
Label | Type the required label for the column. |
Description | Type the required description for the column. |
Unit of measure | Select the required unit of measure from the Frequently used drop-down list or select Other and type the required unit of measure in the box for the value in the output column. This field is displayed only when the column contains numeric value. |
To view or configure the Advanced properties, click Advanced. You do not need to set or modify this property unless you want to change the filter behavior. This property is for advanced users and scenarios only.
Advanced properties
Field | Description |
---|---|
Filer behavior | The value is set to Distinct Values. |
In the Sorting Options section, select the required columns from the Source table, and add them to the Selection table using the >>DESC or >>ASC button to sort the data in the descending order or ascending order respectively. In the Selection table, select the required column, and add them to the Source table by using the << button. You can also change the order of display of columns added to the Selection table by using the Up or Down arrow buttons.
In the Time period label box, type the required label for data mart that are not sensible to time filter. This field is displayed only when there are no time filter macros defined for the data mart or there no columns that have the meaning set as Timestamp. When the data mart is not sensible to time filter, the the time filter for the selected custom view built using this data mart is disabled and this label is displayed in the selected view.
In the Detected filters section, perform the following steps:
Click Apply.
On the Materializer page, specify the following details:
Materialization option | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Always see fresh data | Select this option to load fresh data every time you access the associated view in the TrueSight console. Note: Every time the SQL query runs, it fetches data directly from the database. Hence, a complex query might require more time to run and the performance might be impacted. | ||||||||
Create materialized table | Select this option to load materialized data in the associated view in the TrueSight console.
This option is useful when you have a complex SQL query and you want to see or use the fetched data quickly. The data mart is materialized and the data is stored in a new table, which is shown whenever you choose to Preview or view the data. Specify the following settings: From the Materializer task list, select the task to be used for materializing the data mart. You can select from the available out-of-the-box tasks or create a new one. For more information about creating a materializer task, see Configuring the Data Mart Materializer task.
|
(Advanced only): To specify access permissions to DB users and DB roles to the materialized table in the database, configure the following advanced settings:
Field | Description |
---|---|
Grant to DB users | Select the database users from the Source table, and add them to the Selection table using the | button.
Grant to DB roles | Select the required database roles from the Source table, and add them to the Selection table using the | button.
Grant to user specified roles | Type the required user specified (defined) roles separated by semi-colon to give them permissions to use this data mart. |
Click Finish.
The new data mart is added in the Data marts list page and can be used to build a view in the TrueSight console.
2 Comments
Kevin Joyce
Bipin Inamdar