ARIS Query functions

Dear ARIS-Community 

I am currently working with ARIS Query Designer and have run into a problem regarding relationship evaluation.

I need to determine how many relationships exist between two object types.
Example:

• Object type A (e.g., a Capability)
• Object type B (e.g., a Task)
• A single object of type A may have multiple relationships to objects of type B

For instance:

Object A ("Customer & Market Analytics")  
→ has 3 relationships to  
Object B ("Perform Market Research", "Analyze Feedback", "Segment Customers")

In ARIS Query Designer, I am not able to get a result that simply shows:

A = 3 relationships to B

The query returns the linked objects, but I cannot get an aggregated count of the relationships per A-object (e.g., COUNT, COUNT DISTINCT, etc.).

1. Is it possible in ARIS Query Designer to count the number of connections (CxnDefs) between two object types?
   • For example: COUNT of relationships from A → B
   • Or: COUNT DISTINCT of B-objects connected to A
2. Is it possible to define a custom calculated field inside the query?
   • I would like to calculate an Impact Score based on the number of connections and the values of a relationship attribute (e.g. an “Influence” attribute stored on the connection).

   • Something like:

     Impact = round(1 + 8 * (S / (4 * n)))
     

     where S = sum of the influence values and n = number of relationships.

3. If Query Designer cannot do this, is the only option to use a custom ARIS report script to evaluate the connections and write back the Impact Score?