Profile picture for user andrea.zarembova

In my previous blog post, I showed  you how you can build your first dashboard. Before you start building dashboards, you have to prepare data that will be used to display required information. One of the options is to use a query as a data source. In this post, I will show you how to do that.

In ARIS Architect, go to “Analyses” and then to ”Queries”. On the top left, select the “New” icon and choose „Query“.

New Querie

We are interested in processes, functions, and roles (this will be explained in another post, but for the moment, my goal is to build a dashboard which shows how many roles are involved in activities etc.). This means that as the starting point choose „EPC“. For that EPC, we want to have all the functions and roles.

EPC

Before you choose „Role“, click on „Function“ in your model, so that the role is displayed following the function. After you click on „Function“, the function will be displayed as start position. In case you don´t click the function, the role will be displayed under the function, following the EPC.

As dashboarding input the table view is necessary. Click the „Create table view“ icon on the toolbar.

In the first row, write activity and role as this is what we are interested in. Then drag and drop the definition item there. Also activity_Guid and role_Guid is needed. In the second row, choose “=queary_item_guid(A2)” for activity_Guid and “=queary_item_guid(B2)” for role_guid.

Create table view

Save this query (ctrl+S) and name it ProcessActivityRole.

That is all that is needed to use it as a data source for a dashboard. What you can also do is select the template that you need and create a dashboard link.

Select the “Data” tab on the toolbar and then click „Generate dashboard link”. Select “Use the first row as a header” and click “Copy to clipboard”.

Generate dashboard link

Now we are getting closer to use this query as a data source for our dashboard.

Go to ARIS Connect > Repository> Dashboards and Feeds> Data feeds and select the plus icon to create a new data feed. Creating a data feed makes it possible to combine various data sources or to use a data source for several widgets without creating the same definition again and again.

New data feed

On the left side we can select various types of data sources. Choose ARIS table. As we haven´t created an ALIAS (I will show you how to do that in one of my next posts), you paste the URL you have copied to the clipboard before. In section “Manage” (on the right), choose “Save as”.

Data feed properties

I named it “test Query”. You can also add some descriptions that might be useful for your better orientation later when you have more queries. When you have saved the data feed, it can be used as a data source for our dashboard (as shown in my previous post).

Data source for Dashboard

For more information about dashboards check also my other posts:

 

by Snehal Kharche
Posted on Wed, 03/13/2019 - 13:52

Hi Andrea,

Thanks for the detailed explanation on how to create a query as a data source for dashboard. I have now created a query 'ProcessActivityRole' as per instructions, however stuck at a point where I am using it as a data feed to create a dashboard as shown in image. Can you please help me know how this query can be used as a data feed for a dashboard?

Thanks,

Snehal

1
by Daily Tasks Administrator
Posted on Fri, 03/22/2019 - 14:30

In reply to by sneh24

Hi Snehal,

which error message do you get?

Andrea

1
by kuldeep desai
Posted on Thu, 03/25/2021 - 13:52

Hi,

I have noticed that if you use hierarchy in ARIS query then you can not use it as a dashboard link. Is that correct and is there any way around?

 

Kuldeep

1
by Harm Verschuren
Posted on Mon, 08/02/2021 - 08:18

In reply to by kuldeep_metro

Hi Kuldeep, I think you are correct. I'm having the same issue, i.e. it's repeatable. Unfortunately, I didn't found a solution yet. Perhaps someone from Software AG can comment how to solve or work around this issue?

KR,

Harm

1
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Mon, 08/02/2021 - 21:43

In reply to by harmv

Often it's better for you to create a new post about your issue and just link to another one which you'd like to refer to.

A new post is shown to everyone while your reply on an old discussion is seen by less people.

Cheers
Rune

1
by Marcelo Celebroni
Posted on Wed, 10/05/2022 - 21:02

Hello Andrea!
I followed all the steps you recommended and it still didn't work. After using the generated link in the query, the result does not return any data in the data feed. Screen print follows.
Can you help me?

1
by Marcelo Celebroni
Posted on Wed, 10/05/2022 - 21:03

Hello Andrea!
I followed all the steps you recommended and it still didn't work. After using the generated link in the query, the result does not return any data in the data feed. Screen print follows.
Can you help me?

1
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Thu, 10/06/2022 - 16:38

In reply to by Marcelo Celebroni

Did you check the text of the error message? You can do so when you hover thew mouse cursor over the red cross icon.

Sometimes the link isn't the issue but a missing/insufficient authentication.

Cheers
Runè

1
by Runé Becker
Badge for 'Mastermind' achievement
Posted on Fri, 10/07/2022 - 12:49

In reply to by Marcelo Celebroni

You could check that URL on a new browser tab.

I could imagine that you are accessing your ARIS server not via a plain IP address but a server name with a valid domain name. I so, replace the IP address with that URL containing server + domain name.

Cheers
Runè

1

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