Hello community,
I'm learning how to use the Spreadsheet model type. One thing I notice is, when creating rows and columns it seems that you must pick or select a model or object for each header row and column. I wonder if it's possible to select a dynamic list of objects and models. What I'd like to achieve is the following.
I'd like to create a spreadsheet that shows attributes (as columns) of all processes (as rows). The attributes are a fixed set, however the processes are not. In time, processes can be added or removed, so whenever this happens, I'd like the. spreadsheet to automagically show an up-to-date list of processes. However, when it's only possible to manually pick processes, keeping this list up-to-date becomes really cumbersome. ;-(
My question is, is it possible, and how is it done?
Thanks in advance.
Best regards,
Harm
M. Zschuckelt on
Hello Harm,
Have you taken a look at Queries? In ARIS Architect you define them once and you can execute them many times. A query drills through your database from one or more objects you pick using any selection method - even the entire database or a group, if you want. You define the Query path from the start object to the targets via connections, assignments, object definitons, occurrence in models - whatever you need. The output of the query is a tree. You can use the definition elements of the query path and place them on a result table. That looks just like your spreadsheet models. You can also place attribute types as column headers and output attribute values of the tree nodes. It's even possible to edit attributes directly in the query result!
Finally you can save your query result as a Spreadsheet model, but you don't need to. You can just execute your query again on the same or different start objects.