Workflow

Metrics and Scorecards: Manage SSAS Cubes Workflow

This workflow describes the process of connecting to an SSAS Cube.

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.

Start

Persona: Solution Administrator

This process will associate the predefined SSAS data cubes with a particular instance of APM, and initiate cube management.

Design Cube

Persona: Solution Administrator

Create OLAP cube in SQL Server Analysis Services. The cube stores data in an optimized way to provide a quick response to various types of complex queries by utilizing dimensions and measures.

Set up SSAS Server

Persona: Solution Administrator

Set up an SSAS Server to host solutions. For example, Analysis Services is an analytical database server that hosts multidimensional cubes that you can access from the APM Metrics and Scorecards module.

SSAS Cube

Persona: Solution Administrator

A list of registered cubes that the user has access to based on the cube privileges.

Associate SSAS Cube

Persona: Solution Administrator

Associate the predefined SSAS data cube with a particular instance of APM.

Metrics and Scorecards: Manage Metric Views Workflow

This workflow describes the process for designing and analyzing Metric Views.

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.

Start

Persona: Analyst

This process will create a Metric View by applying standard data analysis techniques to analyze a specific business problem, and initiate Metric Views.

Manage SSAS Cubes

Persona: Analyst

A cube record registered in the Manage SSAS Cubes workflow will be used as a data source to design a Metric View.

Go to the Manage SSAS Cubes workflow.

SSAS Cube

Persona: Analyst

A list of registered cubes that the user has access to based on the cube privileges.

Design Metric View

Persona: Analyst

Design a Metric View to display specific data from existing SSAS cubes to analyze a specific business need. The dimension and measure will display all the dimensions pertaining to the selected cube.

Analyze Metric View Result

Persona: Analyst

Analyze the Metric View results. The Metric View can identify bad actors or high impact failures for further analysis.

Opportunity Identified?

Persona: Analyst

Review the Metric View to determine if there is an opportunity or need for improvement. If such an opportunity is determined to exist, 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 an opportunity or need for improvement is identified in Metrics View, then raise a Performance Recommendation to communicate and track the required work.

Refer to the Manage Performance Recommendations workflow documentation for more information.

Metrics and Scorecards: Manage KPIs Workflow

This workflow describes the process of designing, analyzing, and updating Key Performance Indicators (KPIs).

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.

Start

Persona: Analyst

This process will create a KPI by applying standard data analysis techniques to evaluate the success of reaching targets, and initiate Key Performance Indicators (KPIs).

Query Analysis

Persona: Analyst

The APM query created for the analysis can be used as a data source for a KPI.

Refer to the Query Analysis workflow for more information.

Query

Persona: Analyst

The APM Query that will serve as a data source for the Key Performance Indicator (KPI).

Manage SSAS Cubes

Persona: Analyst

A cube record registered in the Manage SSAS Cube workflow can be used as a data source for a KPI.

Go to the Manage SSAS Cubes workflow.

SSAS Cube

Persona: Analyst

The SSAS Cube that will serve as a data source for the Key Performance Indicators (KPIs).

Design KPI

Persona: Analyst

Design a Key Performance Indicator (KPI) to display specific data from existing SSAS cubes or a APM Query that satisfies a specific business need. Measures are used to create KPIs.

Schedule KPI

Persona: Analyst

Schedule the Key Performance Indicator (KPI) to run at a particular date and time, either once or on a repeating basis, to update KPI measures. Add the recipients to whom the KPI updates will be sent.

Review KPI Results

Persona: Analyst

Analyze the Key Performance Indicator (KPI) measure. The KPI query can identify bad actors or high impact failures for further analysis. If needed, you can add the KPI as a dashboard widget. As a dashboard widget, the KPIs will be easily accessible and will provide users with a comprehensive view of data.

Opportunity Identified?

Persona: Analyst

Review a Key Performance Indicator (KPI) to determine if there is an opportunity or need for improvement. If such an opportunity is determined to exist, 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 an opportunity or need for improvement is identified from a KPI, then raise a Performance Recommendation to communicate and track the required work.

Refer to the Manage Performance Recommendations workflow documentation.

Metrics and Scorecards: Manage Scorecards Workflow

This workflow describes the process for designing and analyzing Scorecards.

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.

Start

Persona: Analyst

This process will measure the business Perspectives and Objectives that result from adding Key Performance Indicators (KPIs) to the Scorecard, and initiate Scorecard.

Manage KPIs

Persona: Analyst

The KPIs created in the Manage KPIs workflow will be used to create the Scorecard.

Go to the Metrics and Scorecards: Manage KPIs workflow.

KPI

Persona: Analyst

The KPI from the existing repository that will be added as an Objective to the Scorecard.

Design Scorecard

Persona: Analyst

Design a Scorecard to display specific KPIs from the existing KPI repository. The user can assign View privileges for a Scorecard.

View Scorecard

Persona: Analyst

Analyze the perspective and objectives of a Scorecard. The KPIs in a Scorecard can identify bad actors or high impact failures for further analysis. If needed, you can add the Scorecard as a homepage.

Opportunity Identified?

Persona: Analyst

Review a Scorecard to determine if there is an opportunity or need for improvement. If such an opportunity is determined to exist, 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 an opportunity or need for improvement is identified in Scorecard, then raise a Performance Recommendation to communicate and track the required work.

Refer to the Manage Performance Recommendations workflow documentation.