Workflow

Core Analysis: Query Analysis Workflow

Core Analysis processes leverage APM data to identify opportunities for business improvement. When the process identifies such an opportunity, a Performance Recommendation is raised to communicate the need and track the required work. You can use the Query Analysis Workflow process to identify opportunities or needs for improvement based on generated queries that identify bad actors or high-impact failures.

In the following workflow diagram, the blue text in a shape indicates that the corresponding description has been provided in the sections that follow the diagram. For more information, refer to the Interpreting the Workflow Diagrams topic in the APM Product Workflows documentation.
Note: For information on the personas associated with a APM module, refer to the APM Product Workflows documentation.
StartDesign a QueryRun the QueryReview Query ResultsOpportunity Exists?Manage Performance Recommendations

Start

Persona: Analyst

To satisfy a specific business problem, a APM User initiates a core analysis that applies standard data analysis techniques.

Design a Query

Persona: Analyst

To satisfy a specific business need, design a query to select specific data from APM entities. Multiple entities can be included in the query design to extract related records.

Run the Query

Persona: Analyst

Execute the query to produce results. The user modifies the query design to achieve the desired result.

Review Query Results

Persona: Analyst

Analyze the query results. The query can identify bad actors or high impact failures for further analysis. In the analysis of query records, consult other forms of APM data.

Opportunity Exists?

Persona: Analyst

If a APM User identifies an opportunity or need for improvement, then a Performance Recommendation is raised to communicate the need and track the required work. Otherwise, the workflow ends.

Manage Performance Recommendations

Persona: Analyst

If a APM User identifies an opportunity or need for improvement, then a Performance Recommendation is raised to communicate the need and track the required work.

For more information, please consult the Manage Performance Recommendations documentation.

Queries Workflow

This workflow provides the basic, high-level steps for using this module. The steps in this workflow do not reference every possible procedure.

Procedure

  1. Access the Design workspace.
    Note: Interaction with diagramming and design canvases is not available on touch-screen devices.
  2. Add at least one query source.
  3. Add at least one field from that query source.
  4. Run the query to make sure it returns the expected results.
  5. Save the query.

The process of creating a more complicated query might include the following additional steps:

  1. Add criteria using expressions.
  2. Add prompts.
  3. Add hyperlinks.
  4. Define the results.

What To Do Next

After you have initiated the process of creating a Select query using either of these options, when the Design workspace appears, you can modify the query type to create any of the following types of queries based on that Select query:

  • Crosstab query
  • Delete query
  • Update query
  • Append query