Profile picture for user Eva Klein

After the last article lined out how you define a query, I would like to show you today how you insert an attribute list as a data table.

The sample report will output a list of the functions contained in the individual models. It also includes the specified time and cost values.

To obtain this output, you must insert a data table into the repetition area of the selected model query. The data table queries all functions of the model and outputs the name, time and costs of the functions using data fields.

How it works

First, you must insert a data table.

Right-click in the repetition area of the subsection of the selected model query (how you insert a query will be explained in this article), and select Insert/Data table.

Under Settings, enter the number of required columns, in our example 4. Then enable the Has header and Repeat table header on each page options as well. Click on the Next button.

Select the Object definitions (filterable by type) item under Items of: Selected groups.Model list (filterable by type) and click on the Next button.

Now select Function under Object type in the Parameters group box. To get a sorted output you can select Name in the Sort by selection box. Click on the Finish button.

A new subsection is inserted with a data table that queries the functions of every model.

Now you can format the header of the table. To do so, select the first row of the data table and right-click on the selected cells, and then select Properties. Here you can set the background color of the table header, for example.

In the headers of the individual columns, insert the following titles: Model name + Model type, Function, Average processing time, and Average total costs.

Your first row of the data table then looks like this:

To be able to output the data you need to have data fields. Therefore, right-click on the second row underneath the title Model name + Model type, and select Insert/Data field.

Select the data element Name from Data superior to ‘Query’ folder and click on the Next button. Finally, click on Finish.

A data field listing the model name is inserted. To specify the model type you can insert a data field in the same way behind the name of the model. Select Model type as the data element. Separate the two data fields with a "-".

In the second row of the Function column, insert a data field with the data element Name that you select under Items of: Selected models.Group.Model list (…). Click on Next and on Finish.

A data field that lists the function names of every model is inserted.

In the third row of the Average processing time column, insert a data field with the Attribute (filterable by type) data element and the Average processing time attribute type.

The last column Average total costs is filled with information in the same way.

The queries are inserted into the second row of the data table. The report should look as follows:

The output of the report may look like this:

In combination with the previous tutorial, you can now first query a list of models and second output specific data for each model like a list of certain objects with selected attributes.

Make sure to head over to the table of contents of this tutorial to not miss the other parts!

by Ismael Shameem Etowar
Posted on Tue, 02/15/2011 - 07:38

Dear Ms. Klein,

Many thanks for this post.

I was working on a similar report and was stuck at a point in time:)

Your article came at the right time.

 

Thanks a lot.

 

Cheers

 

Shameem

0
by AlpenBank AlpenBank
Posted on Fri, 07/08/2011 - 23:20

Hi to everyone.

I'm an "Aris beginner" who's facing the problem of getting a report "procedure" with a good layout so to enable my collegues and me to read, review, approve and building gradually our "company procedure manual". What I expect is a cover page, title of the procedure, date of approval, all the sequence of activity, who carries out, ecc. And, of course, I do not want to use MS Word. Standard reports seems quite "unreadable" so I was delighted to read all posts by Eva about the WYSIWYG procedure. But I still can't manage to output good documents. I must be wrong in some way, maybe either in the process mapping iteself or in the mentioned WYSIWYG procedure.

I mapped several EPCs in which all the events, functions, responsabilities, technical terms have accurate description both in the name of the objects, in the description field and in free attributes. I think that using the "data table" can help for my goal; but when I try to insert "data fields" I really get lost. I would espect to find my models (the various EPCs I modelled) and then fields like "description", "type of connection", ecc. Instead I can't understand what's underneath all the screenshot attached above with all those sort of options to be selected. Maybe my dubts can sounds stupid and I need more training but as I told you I need infos form the scratch.

Can anyone help me? In terms either of getting the reports or suggesting other strategies to model and insert data so that I can use available standard reports?

Thanks for your kind attention

Rino

0
by Eva Klein
Badge for 'Community Team' achievement
Author
Posted on Mon, 07/11/2011 - 08:35

Hi Rino,

nice to hear that you read all my tutorials:-).

We have a standard report called "Create process manual", which outputs all data of a selected process. Please try this report. I think it will meet your requirements.

Regards

Eva

0
by AlpenBank AlpenBank
Posted on Tue, 07/19/2011 - 16:23

Thanks really, for the quick answer and help; and even for all the answers and knowledge one can find on these issues thanks to your contribute.

I´m quite new with Aris and before asking you again, I wanted to spent a little bit of time:

  1. working with "create process manual" or other similar report for my objectives (like "print ... with organizational units/elements, functions, data,...ecc").
  2. taking practice with wizard procedure (I do not know javascript).

Standard report like the ones mentioned have useful ideas inside (example: the process overview in "create process manual" standard report) but still I find them unreadable for normal human being not accustomed with "Aris language". In particular, I´m building a wizard in which I need to select data, both on model attributes and in object attributes within that model (to put it normally speaking: I have several EPCs, which are the model within which different kind of object are used - functions, organizational units, position, technical terms, risks, controls and IT system in use).

I´m at a good point; but I´m struggling to complete it. In particular when I try to setup the wizard I must be wrong in some way because I always find myself in a situation in which either there is the possibilty to spot data form the model but not from the object or there is the possibility to spot data from di objects but not form the model. Do I have to re-setup the context? Which is the right way?

What I need to create is a simple document in which in the first one or two pages inserting general data concering the EPC (name of the process, process owner, version, data,...picked up form the model attributes) and then a table for the same EPC with 4 or 5 columns like: function name, definition/description of that function, postion/organizational unit that is responsible/carries out that funtion, which IT system is used,...etc....

I would appreciate any of you for any kind of help. In particular: is a matter for javascript programmers or is possible to manage with the wizard?

Thank and have nice time

Rino

0
by Eva Klein
Badge for 'Community Team' achievement
Author
Posted on Wed, 07/20/2011 - 09:31

Hi Rino,

thanks, I always wonder if I can support anybody with my reporting tips:-)!

To me your requirement looks more or less like this: 

ARIS WYSIWYG editor

I describe the above picture a little bit in the "Layouting report" post.

I hope this will help you. If you have further questions please feel free to ask me.

Regards

Eva

0
by mayank gulati
Posted on Fri, 03/30/2012 - 08:58

In reply to by louise

Hi Eva,

I tried all these settings , but couldnt really get the output, as on following these steps the table itself didnt appear in the report.

I need to know how we can insetr various objects that are connected to to a particular function in an EPC, it may be application system or position, how can we get it in a table using report designer.

Please help me out in this.

Regards 

Mayank

0
by Anette Villarreal
Posted on Fri, 01/16/2015 - 18:59

In reply to by mayank10

Hi Mayank, I was wondering if the doubt you had could be resolve and if it was, how did you do it because I have the same doubt.    Thanks  Anette  
0
by AlpenBank AlpenBank
Posted on Mon, 09/12/2011 - 09:40

Hi and thanks for your suggestions. I could use it and I am now able to get almost 90% of the report I need. Just  a couple of questions, if possible:

  1. in my report one of the output is the model graphic. The result is always on a single page. This can be a problem if the model is quite large o long. Is it possible to insert with WYSIWYG a sort of “zoom percentage” in order to allow the graphic to be represented in more than one page if necessary? In several standard report during the execution I could see that is possible to manage this percentage and get a more friendly layout.
  2. I use now your input like the picture you attached above in my WYSIWYG report, but if the activity has more than one organizational element connected, the result is the repetition of the activity as many times as the number of organizational elements. I would like to get only one raw for activity and all the actors in the cell of the "executed by" column.

 Do you think is possible to manage this requirements or is necessary to script?

 Thanks a lot for help

 Rino

0
by Eva Klein
Badge for 'Community Team' achievement
Author
Posted on Mon, 09/12/2011 - 10:50

Hi Rino,

1. can not be realized with WYSIWYG editor

2. the output is always 1 to 1.

The requirements can only be implemented by scripting. 

Regards

Eva

0
by Louise Curran
Posted on Fri, 09/30/2011 - 11:34

I am attempting to include the "carries out" by the "position" in this report.  I have described my problem via your "Layouting report" post but I would like some detail on how to construct via WYSIWYG a report to show: function, description and position (i.e. who the function is carried out by).  can you pls provide step by step for the position column.  much appreciated.

0
by Louise Curran
Posted on Fri, 09/30/2011 - 11:39

the standard aris report "hierarchy" gives the required information but i require the information in a tabular format similar to the reports described above. 

the "hierarchy" reports cannot be used in WYSIWYG so I am unable to tailor is for my requirements. 

it seems that a number of users in this forum are asking similar questions so a more detailed explanation on how to create such a report (tutorial style) would be appreciated. 

thanks again.

0
by Manuel Hobisch
Posted on Tue, 11/08/2011 - 16:49

Hi,

short question:

Is it possible, for data tables, to insert also a second row (as there is the FIRST row, I would expect, that there could also be a second and third row?).

My problem is as follows:

I now created a report which lists me all the risks of a BCD. Now I want, that after each risk the attributes of the conected control will be listed.

And after this block the next risk and control. Here a short example:

Is this possible? If yes, how?

I would be grateful for all your help.

Thanks in advance.

Kind regards,

Manuel

0
by Joost Simkens
Posted on Wed, 01/18/2012 - 10:00

I've made a report just as described above. My databale shows attribute list (filterable by type) for the attributes I want to show in the report. It does exactly as what it should do, but I have 2 additional questions:

1 - Can I change the order of the listed attributes?  -->  answered: this is of course a property of the filter... problem solved...

2 - The report skips attributes with no value and leaves them out of the report. If an attribute is empty, I want it listed as such in the report. How can I achieve this? (display only the empty field) 

Any suggestions?

 

 

 

0
by Anosh Mehdi
Posted on Mon, 03/26/2012 - 13:45

Hey Eva,

I am trying to create a report to showcase Job Roles. I would like to select the Position and the report should provide some basic information about the selected Position such as its Hierarchy and association with Organizational Unit.

Then, it should represent the Job Roles (Person Types) attached with the selected Position and also the names of Process Models where these Job Roles (Person Types) have been used.

So far I have managed to produce the attached report with the attached script. I would be glad if you could guide on how to get the names of Process Models against each Person Type.

Regards,

Anosh Mehdi

ARIS Job Role Analysis

Job Role Analysis - Output

0
by Anosh Mehdi
Posted on Tue, 04/10/2012 - 12:56

Hey,

I have improved on the report. For a selected Job Position, I have managed to extract Job Roles, their occurrence in Process Models and the Functions performed within these Process Models.

However, all the information is being populated in a sequential order as the queries are being executed one after another. I want to present the information in a tabular form. Kindly explain 'How to use different queries for each column of the table?'

Thanks and Regards,

Anosh Mehdi

0
by Romeo Paone
Posted on Sun, 10/13/2013 - 20:38

Dear Eva and dear All,

i hope this is the right page where i can post my question regarding the following issue.

I am trying to find the correct format to export the time attributes (static, orientation and processing time) from an excel file into my model in Aris.

The upload of the excel file worked for updating the values of  COST and FREQUENCY attributes.

For example,  a value of the time attirbute has the following format (0000:01:15:00) Constant, but adding the same format with different values on excel, it did not upload the change.

I have tried different format, but nothing seemed to work.

If anyone has a solution on this issue, it would be highly appreciated.

Thank you

Best Regards

Romeo 

0
by Anette Villarreal
Posted on Mon, 11/17/2014 - 23:20
Hi, that such! I read your articles much, but I doubt arises regarding creating process manuals made with my own needs. I'm working from the designer view and I wonder if from there you can create a data table with the following fields: Function, Description, As for who executed the function, inputs and outputs.   I wish I knew how to do this, expect a lot of your help.   Thank you so much.
0
by Pankaj Patel
Posted on Sun, 12/20/2015 - 15:14

Hello,

I need to prepare a report exportable to excel using design view.I want the report to be run from a VACD model and the report should contain all levels of assignments (max 4).The report should contain all the functions from the selected VACD, VACD assigned to L1 function and their attributes , BPMN Collaboration diagram and BPMN Process diagrams assigned to each function and their attributes.

Please find the attached excel for required spec.

Thanks in Advance.

File attachments
0
by Natalie Scarlet
Posted on Wed, 03/23/2016 - 21:11

Hi! How to you insert a role in a table. I have attached what I have so far and can get role and superior object, but not function attached to the role.

File attachments
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