Northcraft Analytics provides business intelligence applications for IT. ServiceNow, SolarWinds, BMC Remedy ITSM, IBM Netcool and more.

E-Mail: Phone: (800) 565-1375

Analyzing Change Approval Bottlenecks in BMC Remedy/Helix

Last modified: November 21, 2019
You are here:
Estimated reading time: 2 min


Change Approval Bottleneck Analysis

In this article you will use PowerBI to create a dashboard to analyze bottlenecks using Change Approval. This dashboard will have drill-down capabilities and provide you with important metrics that will increase the understanding of the specific strengths and weaknesses in each area of business.

To learn more about Northcraft, take a look at our Resources page.

This video provides step-by-step instruction, or you can follow the steps listed here.

Step 1: Begin by opening up PowerBI and type in your on-premises server (xxxxx@domain) or SaaS server name (ex: to the Server field and select ‘OK’

Step 2: In the ‘Navigator’ section, select the ‘ITIL Metric for ITSM 4075 – RemDash’ multidimensional database (MDB)

Step 3: Select the ‘CHG – Change Signature’ cube

Step 4: Select ‘Ok’

Step 5: Move over to the ‘Visualizations’ section and select the ellipsis symbol.

Step 6: Select the first selection ‘Import from file’

Step 7: Select ‘Import’ at the pop-up

Step 8: To get the visualization we need, use the file that holds Super Bubbles

Step 9: Select ‘Ok’ in the pop-up.

Super Bubble

Step 10: Open up a new ‘Super Bubble’ visualization.

Step 11: Open the ‘Change Signature (Measures)’ folder

Step 12: Select the ‘Change Signature Count’ field

Step 13: Next open the ‘Change Signature’ folder

Step 14: Next select the ‘Full Name’ option


Step 15: Next, open up a ‘Slicer’ visualization

Step 16: Next select the ‘Approval Status’ option

Step 17: In the ‘Approval Status’ Slicer select ‘Pending’ to change the Super Bubble


Step 18: Next open up a ‘Table’ visualization

Step 19: Next open up the ‘CHG – Change Management’ folder

Step 20: Select the ‘Hierarchy – Product’ option

Step 21: Under the ‘Visualizations’ section close out the fourth selection under ‘Values’, ‘CHG – Change Management’ [Hierarchy – Product]’

Step 22: Also close out the value immediately above it.

Step 23: Finally, select ‘Change Signature Count’


Support Information

Support by website

You can obtain technical support from Northcraft Analytics 24 hours a day, 7 days a week at From this website, you can:

  • Find the most current information regarding Northcraft Analytics products.
  • Manage your account information
  • Upload documents for content sharing exchange.
  • View shared documents from other users.
  • Order or download product documentation.
  • Download products and maintenance releases.
  • Report an issue or ask a question.

Support by telephone or email If you need technical support either by phone or email:

Call (+1) 800 565 1375

or by email using:


Every effort has been made to make this as complete and as accurate as possible, but no warranty or fitness is implied.

The information is provided on an “as is” basis. The author and Northcraft Analytics, LLC, shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this manual or from the use of the discs or programs that may accompany it.

Copyright © 2010 Northcraft Analytics LLC. All Rights Reserved.

Trademark Legal Notice. All product names, trademarks and registered trademarks are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

Was this article helpful?
Dislike 0
Views: 63