I've created a query to present Roles in Process models within a Group/folder subtree, focusing on which Functions they interact with, and realized it was fairly easy to extract RASCI columns in the spreadsheet view to show exactly what they do, using the QUERY_IS_CONNECTED() function (with some digging to identify the API names of the connection types we've actually used in our filter). The query works fine as long as I stick to a single Group/folder. When I allow Groups/folders to recurse through a hierarchy, however, I get the Roles and Functions just fine, but the RASCI columns are missing from all but the top Group/folder models.
Is this a known error? We're still on version 10.0.21 of ARIS Enterprise.
Query definition (attached as EQI file):
Spreadsheet template:
Result for top folder models (as expected):
Result for nested folder (there should be a bunch of R's in the indicated column):
Best Reply
Hi,
For me it is a bit difficult to understand what is not working and what your settings are. I would raise a ticket with the support. I'm sure they can help you :)
Best,
Veronika
5 Replies
-
Hi Pontus,
Try using the "Set Target" option for the "group" object in your query.
You find it in the start menu. Hope this does the trick for you.
Best,
Veronika
-
Nope, no difference, whichever objects I target, singularly or in combination (except, of course, for getting null results in the ARSCI columns when targeting Roles or Functions only).
Where should I report the bug? -
Hi,
sorry for the confusion. If you set the role and the activity as target, it works.
-
Unfortunately, no, it doesn't work. The query shows blank RASCI results when the models are in a subgroup, but everything's great when they are in the starting group.
However, though I haven't tested it extensively, it seems to work when I have two starting points: not just the root group, but also (any one of?) its subgroups. Seems like bug territory to me. -
Best reply
Hi,
For me it is a bit difficult to understand what is not working and what your settings are. I would raise a ticket with the support. I'm sure they can help you :)
Best,
Veronika