Data Sources

About Advanced Visualization Data Sources

Advanced Visualization provides out of the box capabilities that enable you to visualize data for the following APM features and modules:

Baseline entities and queries
General recommendations

Each of these features is associated with a set of data sources in Advanced Visualization. The data sources contain a set of logically related fields that allow you to create and customize the visualizations based on the access privileges that you have for the specific feature.

Note: Although you have access to all the data sources, you must also have access to the required capabilities to create visualizations using these data sources. . You can visualize the data for the assets based on the security groups and roles assigned to your APM user account.

The following table provides high-level information about the data sources available for the supported modules or features:


Module/Feature	Data Source Description
General Recommendations	You can visualize data based on the general recommendations data available within APM.
APM Baseline Queries	You can visualize data using the baseline query views available in APM. Note: The baseline query view displays the result of a query. As needed, you can create a curated view for the query result within your tenant.

Create a Data Source using a APM Query

Before You Begin

Make sure that the baseline query or the custom query that you want to use to create a data source exists in the Catalog.

About This Task

This topic describes how to create a data source using a baseline query or a custom query, and configure the data source to enable the Advanced Visualization users to create charts or dashboards using the data source.

Procedure

Access the Advanced Visualization page.
Select , and then select Prepare and Manage Data.
The SERVER page appears.
Select Get Data.
The Get Data window appears.
In the CONNECT TO DATA section, select REST, and then select Select.
The Configure Connections window appears.
Select APM_QUERY, and then select Select.
The Create Synonym for REST window appears.
In the Create Synonym options section, specify the following parameters:

Note: We recommend that you use the Query Helper to validate the query parameters and copy the field values to the corresponding fields in the Create Synonym options section. For more information on how to use the Query Helper to validate the query parameters, refer to the Retrieve Query Details of a APM Query using Query Helper topic.
1. In the Select REST Operation box, select Post.
2. In the Service URL Extension box, enter: v2/catalog/query/path/execute
  
  Note: If you use a APM version older than V4.5.0.0.0, enter: v1/catalog/query/path/execute
3. In the Provide document sample box, enter the request body parameters for the Insert (POST) request.
  - The following example provides a template for the request body:
```
{
"QueryPath":"query path",
"Page":0,
"PageSize":100,
"InputSingleParams":
{
    "parameter1":"value",
    "parameter2":"value2"
} 
,
"InputMultiParams":
{
    "parameter1":["value1","value2"],
    "parameter2":["value1","value2"]
}
}
```
  - The following example provides a sample request body for a query:
```
{
  "QueryPath": "Public\\Meridium\\Modules\\Generation Management\\Queries\\NERC Queries\\NERC Event Report 07",
  "InputSingleParams": {
    "unitKey": "-1",
    "endDate": "2021-03-04T04:15:20.795",
    "startDate": "2021-03-04T04:15:20.795"
  },
  "InputMultiParams": null
}
```
In the Synonym Field Name Processing Options section, select the following check boxes:
- Validate
- Make Unique
In the Miscellaneous settings section, specify the following details:
1. In the Application box, navigate to the application directory that will contain the data source that you want to create.
2. In the Synonym Name box, enter a name for the data source that you want to create.
Select Add.
The data source is created in the Application Directory.
Select Prepare and Manage Data and access the Application Directory that contains the data source that you created, right-click the data source, and then select Open
Alternatively, select Visualize Data to view the Chart Creation workflow
A page appears, displaying the Table/Column panel that contains a hierarchy of the query parameters.

Configure the following query parameters:

Important: We recommend that you use the Query Helper to validate the query parameters, and copy the parameter values from the XDEFAULT section of the APM Query Helper window to the XDEFAULT box of the Properties window for the corresponding parameters. For more information on the Query Helper, refer to the Retrieve Query Details of a APM Query using Query Helper topic.


Query Parameter	Actions to be Performed
INPUTSINGLEPARAMS	Expand the object to view the parameters. Right-click a parameter, and then select Properties. The Properties window appears. In the Miscellaneous section, in the XDEFAULT box, enter the parameter value, and then select Apply.
INPUTMULTIPARAMS

In the SERVER page, select the Save button to save the parameters.
The data source is configured.

What To Do Next

Create Charts using a Baseline or Custom Query

Retrieve Query Details of a APM Query using Query Helper

About This Task

When creating a data source using a baseline or custom query, you must have the following query details:

Sample request body for the Insert (POST) operation
Service URL extension
Valid query path
Valid query parameters and parameter values

Using Query Helper, you can retrieve the parameters of a query and validate the parameter details to ensure that correct data is available for creating the data source.

This task describes how to retrieve and validate the parameter details of a query to create a data source.

Procedure

Access the Advanced Visualization page.
Select Query Helper.
The APM Query Helper window appears.

In the Enter Query Catalog Path box, enter the query for which you want to fetch the parameter details, and then select Get Details.

The following boxes are populated:

Service URL Extension
Sample Request Body
Query Path
<Parameter Name>

Note: To copy the data contained in each box, select

The following table describes the fields available in the APM Query Helper window:

Field	Description	Behaviour
Service URL Extension	Displays the following service URL extension by default: v2/catalog/query/path/execute Note: If you use a APM version older than V4.5.0.0.0, the following service URL extension is displayed: v1/catalog/query/path/execute.	You cannot modify data in this field.
Sample Request Body	Displays the parameter details returned by the query. The following example provides a sample request body returned by a query: `{ "QueryPath": "Public\\Meridium\\Modules\\Generation Management\\Queries\\NERC Queries\\NERC Event Report 07", "InputSingleParams": { "unitKey": "-1", "endDate": "2021-03-04T04:15:20.795", "startDate": "2021-03-04T04:15:20.795" }, "InputMultiParams": null }` Note: For APM versions older than V4.5.0.0.0, both the parameter and parameter value appear as parameter values for `Id` and `Value` parameters, respectively. The following example provides a sample request body returned by a query: `{ "QueryPath": "Baseline\\Meridium\\Modules\\AHI\\Queries\\Health Overview - Tiles", "InputSingleParams": [ { "Id": "unitKey", "Value": "-1" } ] }`	If the request body contains valid parameters and the parameter values, you cannot modify data in the field. If the request body does not contain valid parameter or parameter values, a message appears, asking you to update the parameter values. You must update the parameter values in the XDefault Values section to make the request body valid.
Query Path	Displays the catalog path for the query.	You cannot modify data in this field.
<Parameter Name> Note: The field is displayed only if the query contains at least one parameter.	Displays the parameter name and the parameter value contained in the sample request body. Note: If a parameter contains multiple values, only the first value is displayed in the <Parameter Name> box.	If there is no valid parameter value for a given parameter, you can add the parameter value to make the request body valid. Note: When configuring data source with a APM version older than V4.5.0.0.0, you must manually update the default values for the parameters `Id` and `Value` in the corresponding XDEFAULT box of the Properties window.