Business capability hiearchy

[Louis R Ronzitt]

Anyone who uses Enterprise Architecture Workspace and specifically the Business Portfolio know of a way in which we can export the 'Business capabilities hierarchy' to excel while preserving the tiered structure?

Use case is to send a spreadsheet to Business Owners and IT Application Owners so they can see the list of the business applications they own and their capabilities, plus the parent's capability and its parent capability.

Essentially, looking for an expandable list view like the hierarchy visualization does without having to export to Excel and then Use Excel’s Data > Grouping & Outline feature to indent child capabilities under parents.

Imagine a tree_picker=true but in a ServiceNow table with the ability to drill down three levels or perhaps a database view with the three tables (cmdb_ci_business_app, business_capability and cmdb_rel_ci). 

Someone out there must have already thought of a way this can be done? 

[Johannes]

Maybe I do not understand exactly what you are looking for, but what is the reason you are looking for creating an export to Excel which soon will have outdated data, instead of sending your users into the ServiceNow platform providing them with live data?

[Louis R Ronzitt]

While the Business Portfolio is fully built out with the hierarchy in place, the 'Business capabilities hierarchy' UI is not quite as user friendly as lets say the native UI is re: being able to manipulate the data.

Plus, the 'Attestation' UI is the same thing where users cannot as easily manipulate the data the way they are use to in excel.

As for the data being outdated, yes, I agree.  The moment the information is exported, it has the potential to become outdated.  But until the workspace UX is improved, we still need the ability to (in some cases such as this one) export.  

[Innovate-LH]

Have you thought about using PowerBI and the table API to create a report that could be real-time. Users could export the data from PowerBI if needed.

[SureshRamajayam]

Louis,

Greetings!

The other way around is do the spreadsheet exercise with the business first then import to ServiceNow.

This way the business can confirm and sign off on their capabilities and application before it is live in ServiceNow tables.

This is the approach we are doing.

Hope this helps.

Suresh