AS

Hi Community

In ARIS 7.1 I've defined a set of Capability and Task objects which are connected using the Refers To connection type. The modelling rules are that each Capability and Task can only be connected once, but that a single Capability can connect to several (or all) Tasks and vice-versa.

Each Refers To connection contains an attribute with a numerical value. My stakeholder asked me to report on that raw value (i.e. output it), and I was able to create a report using Design View. 

Now, my stakeholder has asked me to report on the arithmetic mean of that value as it relates to Capabilities, i.e. what is the mean of the attribute values for Capability X? This does not seem possible to implement in Design View. For example, if I create a Data Table, and set the repetition Query on the Capability object (so that each unique object has a unique row in the Table), then define a Data Field in a table column to return the attribute value for all connections, the script returns in each such cell a list of all the individual values for the related connections. This seems to preclude me from creating a report for any summary statistics, but I noticed that Marcus Sandberg created just this for attributes (but not attribute values) in a post in this same forum called "Attribute statistics - Example of customized ARIS report".

My experience in ARIS scripting is limited to Design View, and I have no experience in coding. It would be simple enough to use the first script to dump the raw values to Excel where I can transform them using a pivot table, but I would like to know if there is a solution using ARIS reports or macros in either Design or Code Views.

Thanks

Andre

 

by Martin Miskovic
Posted on Tue, 03/17/2015 - 09:48

Hi Andre,

I am not aware of that you can do this in WYSIWYG (does not mean it is impossible).

I would suggest you to learn to code :)

It is really not that hard, just look at some basic tutorials and I believe you will be able to modify your script or create a one.

If you can provide the script you made, I may be able to look at it and modify the script to show you what you need to do.

Good luck.

Martin

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock