ARIS Community - We Love BPM

How to analyze data with queries and spreadsheet functionality

Eva Klein's picture
by Eva Klein in ARIS BPM Blog posted on 2015-11-12

Today I want to say a few words about how to use the "Query" functionality. It is not a new feature, but it is a great functionality to analyze the data in ARIS, and I would like to share it with you.

By running queries you can easily illustrate the complex relationships between database items in a graphic. In other words, queries enable you to visualize all relationships that exist in a database with just a few mouse clicks.

Query in ARIS

To create a new query, you have to follow these steps:

  1. Click  New > Query. The Query Wizard opens.
  2. Select the database for which you want to define the query.
  3. Log in, if required.
  4. The Query 1 tab opens.
  5. Click Query in the bar panel if the bar is not activated yet.
  6. In the Start box enter the name of the item you want to start a query for. This can be for example, a group, model or object.
  7. Click on a successor or bullet in the list.
  8. Add any number of steps or already existing queries to this query. All items are represented graphically on the Definition tab.
  9. Click  Start query on the Query tab bar.
  10. Enter for example, the name of the model or click an entry in the list of suggestions. The query is started. Objects are represented as ARIS default objects.
  11. Select the layout for displaying the result. This layout will be used as standard to display the result for all queries you run in the future.
  12. Save the query, and if you wish that other people can use it as well, publish it to everybody.

You can start public queries for every database of a tenant.

Besides showing them in a graphic, query results can also be displayed as a table and saved as spreadsheet models:

query results can also be displayed as a table

Furthermore, if you want to enable automatic calculations in your table output, you can define a table output template based on the query. Once such a template is created and saved, queries can be started that deliver full table overviews, for instance with ready calculation of values.

I will publish some query examples for Customer Experience Management shortly. In these posts I will explain in more detail how you can define and use queries, and what additional use cases you can serve with queries.

There are no attachments
Etienne Venter posted on 2016-11-14

Is the Query functionality also available in ARIS Designer, or only in ARIS Architect?

Ana Sequeira posted on 2016-12-02

Hello Eva,

Do you know if its possible to make a query that only shows objects (in this case process interfaces) that do not have an incomming connection or only have incomming connections?

I am talking about the scenario where the process interface is the first or last element of the EPC.

Weerakhan Tantiphaiboontana posted on 2017-06-22

Dear Eva,

Could please suggest on how to properly create the TABLE VIEW? I tried to create a custom query (in Local Server). However, the Table only shows blank cells.

I understand that if it is properly configured, i should obtain the table view like in the following post

Best Regards