A lot of the applications I have are merely a collection of services. Each service contains a number of service operations. In the application tree diagram, I can draw the relationships linking services to applications, but also creating the operations as service entities themselves and linking them to the containing service. This serves my purposes well, as in the System process diagrams, I can use the IT Service call to pinpoint down to the individual operations, which helps impact analysis when schemas change, etc.
When I look at the properties of the service, the linked "operation" services also appear as "sub-services".
All well and good, but I would also like to report or export the list of applications, linked services, and linked service operations into an excel spreadsheet. I have no clue how to explore the relationship between services and sub-services in the meta-model.
Has anyone modeled services and operations this way? How do I specify a report or extract to list these in excel as "application, service, service operation" columns?