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.).
- 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
- 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.
- 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?