Ability to export Ampla Equipment Heirarchy and Relationship Matrix Merged

https://schneiderampla.atlassian.net/browse/CE-1913

[Raised by]
Customer Company: Rio Tinto Iron Ore
Customer Contact: Ben Jones (ben.jones@riotinto.com)

[Problem Summary]
Rio Tinto would like the ability to export Ampla's Equipment Hierarchy and Relationship Matrix using web services, as outlined below:

"
The RTIO Business (Ampla End Users) require the ability to export the Hierarchy & Relationship Matrix to Excel.
This allowed for a single pane of glass (birds eye view) of the Cause/ Classification / Effect for each Equipment Type in ONE VIEW.
They use these Excel files to understand the Ampla configuration before making “Requests for Change” to:
• Add new Equipment to Hierarchy
• Edit / Add new items to the Relationship Matrix

Current State
• Ampla code object is written referencing internal Ampla DLLs (unsupported by AVEVA) to extract the following to Excel (see attached):
o Equipment Hierarchy
o Relationship Matrix for each Equipment Type

Future State (ie Enhancement request)
• Web Service (CLR stored procedure) access to Ampla Configuration
Could then publish via PowerBI, with export to Excel via PowerBI
• Web Client version of Ampla Studio with read only access to view Ampla Configuration

This is an enhancement to allow NON Ampla Admins to view Ampla Configuration, without the need for Ampla Studio access or Ampla Server admin access.
"