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? 

[Roberto Corradi]

Hi Louis,

I would take a look at the use of CMDB Query Builder, interestingly there appear to be some pre-canned queries under the EA module (on the instance I'm looking at) which may even give you what you need or at least a good starting point.

[RichieP]

You can do similar via Database Views too, I've used this to support some custom filtering in dashboards, from my rough notes and probably some typos in here it was along the lines of.
assumptions below is that your Business Apps are linked to either a L1 or L2 Business Capability, the logic effectively creates 2 paths to find the L0 Business Capability.
If you wanted to go deeper to L3, L4 Business Capabilities it would get a little more complex, but in theory doable.

Table	Prefix	Order	Left Join?	Where Clause	View Fields
Business Application [cmdb_ci_business_app]	ba	100	No	ba_sys_id = relbatocap_child	name, sys_id
CI Relationship [cmdb_rel_ci]	relbatocap	200	No	relbatocap_type = '4afd799338a02000c18673032c71b817'	parent, type, child
Business Capability [cmdb_ci_business_capability]	bacap	400	No	bacap_sys_id = relbatocap_parent	hierarchy_level, name, parent
Business Capability [cmdb_ci_business_capability]	bacaptopa	500	Yes	(bacap_hierarchy_level = 1 && bacaptopa_sys_id = bacap_sys_id)	name, parent, sys_id
Business Capability [cmdb_ci_business_capability]	bacapmid	600	Yes	(bacap_hierarchy_level = 2 && bacapmid_sys_id = bacap_parent)	name, parent, sys_id
Business Capability [cmdb_ci_business_capability]	buscaptop	700	Yes	(buscaptop_sys_id = bacapmid_parent || buscaptop_sys_id = bacaptopa_parent)	name, sys_id

[Louis R Ronzitt · Accepted solution]

This was exactly what was needed to solve this issue.  Way to go.  Nice technical approach and documentation. 

[Bobby Campbell]

I'm confused. Is the "checked" post signifying the accepted solution?  Should it be perhaps the post above by RichieP?  Otherwise, I don't know how to solve the problem that was asked in the OP.