Profile picture for user Volker Eckardt

Hello Everyone,

You are looking for a simple report to list BPMN models and used lanes in a matrix?

I have created such a matrix for you, the output will be displayed in MS Excel.

 

And here are the steps to install.

1. Open your database

2. Navigate to Administration

3. Evaluation > Reports

4. Create, if not already done, a separate group for custom reports, here called "Custom Reports"

5. Import the report file "Models and Lanes (Matrix).arx" (here attached)

You should get it then listed like displayed here:

 

How to run:

Usually I run it on a group level I am interested in. This can be the highest or another group in the hierarchy.

1. Right Click

2. Evaluate > Start Report



 

3. Choose your Category (here "Custom Reports")

4. Choose the new report  "Models and Lanes (Matrix)"

5. Press OK

The output should list all models in your group, and should indicate by a "x" where a certain lane is used.

Let me know if the output is useful for you!

Best Regards,

Volker

Download

Please download the report file from here

by Sebastian Stein
Posted on Mon, 04/19/2010 - 11:32

Hi Volker,

I just want to say thank you for sharing it!!! It is really great that you share that, because I'm convinced that such examples will help other ARIS users a lot.

@all: Check this post if you are looking for other free ARIS reports & macros. If you want to discuss ARIS scripting problems, make sure to join the group Reports & Macros in ARIS. And please, also share your ARIS reports as Volker did!

0
by France Nkoe
Posted on Mon, 07/30/2018 - 15:18

In reply to by sstein

Hi Sebastian, I am trying to read from a excel file with this code but getting an error. Are you able to assist where I am going wrong:

var file = Dialogs.getFilePath("","xlsx",null,"Select file",0)[0];

var ImportFile = file.getData();



    if(ImportFile!=null)

    {

        var sheets = ImportFile.getSheets();  //This is the line that gives me errors

        var currentSheet = sheets[0];

        //var sheetname = currentSheet.getName();

        var dataRows = currentSheet.getRows ( );

0
by Kalimuthu Aruchamy
Posted on Tue, 04/20/2010 - 09:11

Hi Volker,
Is there any specific model types that this script will work. I tried running this report on a group which has EPCs,VACDs. But I got blank excel as output

0
by Volker Eckardt Author
Posted on Tue, 04/20/2010 - 11:44

Hello Kalimuthu,

thanks for your question. This report has been designed to work with BPMN models, this is the model type where you usually have lanes. We may be able to change this column object type to another, in fact it is used twice in the code, please look for the code fragment "Constants.ST_BPMN_LANE". Not complete sure if there are more code sections to change.

If you let me know what kind of objects you like to get as column names, I can support you to review and change the code accordingly.

Best Regards

Volker

0
by France Nkoe
Posted on Mon, 07/30/2018 - 15:18

In reply to by Volker Eckardt

Hi Volker, I am trying to read from a excel file with this code but getting an error. Are you able to assist where I am going wrong:

var file = Dialogs.getFilePath("","xlsx",null,"Select file",0)[0];

var ImportFile = file.getData();



    if(ImportFile!=null)

    {

        var sheets = ImportFile.getSheets();  //This is the line that gives me errors

        var currentSheet = sheets[0];

        //var sheetname = currentSheet.getName();

        var dataRows = currentSheet.getRows ( );

0
by Kay Fischbach
Posted on Mon, 07/30/2018 - 16:51

In reply to by francen

file.getData() returns a byte-array (basically a very long sequence of zeroes and ones, grouped into groups of eight (eight bits are one byte)). The computer has to be told first that it's an Excel workbook. Do it like this:

var file = Dialogs.getFilePath("","xlsx",null,"Select file",0)[0];
var ImportFile = file.getData();
var xlsWorkbook = Context.getExcelReader(ImportFile); //This line is very important, this is the interpretation. From here on use the xlsWorkbook object

if(xlsWorkbook!=null){ //here use the xlsWorkbook object
    var sheets = xlsWorkbook.getSheets();  //here use the xlsWorkbook object
    var currentSheet = sheets[0];
    //var sheetname = currentSheet.getName();
    var dataRows = currentSheet.getRows ( );
}

Note: the method above (Context.getExcelReader) grants you ONLY READ ACCESS. Should you want to "modify" content of the excel file (create a new file based on the content of the old file), a different approach is needed:

var file = Dialogs.getFilePath("","xlsx",null,"Select file",0)[0];
var ImportFile = file.getData();
var xlsWorkbook = Context.createExcelWorkbook("result.xlsx", ImportFile); //This line is very important, here you create a new workbook based on the byte-array data you obtained. From here on use the xlsWorkbook object

if(xlsWorkbook!=null){
    var sheets = xlsWorkbook.getSheets();  //here use the xlsWorkbook object
    var currentSheet = sheets[0];
    //var sheetname = currentSheet.getName();
    var dataRows = currentSheet.getRows ( );
   
   
    //... do your modification here.
}

xlsWorkbook.write(); //Also very important, translate all the changes made to the objects back into a file.

 

0
by Abdel-Rahman Makssoud
Posted on Tue, 04/20/2010 - 14:01

Hello Volker,

This is v.good, I downloaded the file, it's in name of "Models and Lanes (Matrix)" ,but when i import it to the OBPA,  I see report name " Untitled " and I got blank excel as output .

Abdel

0
by Volker Eckardt Author
Posted on Tue, 04/20/2010 - 23:02

In reply to by sstein

Hi Abdel,

Regarding report name " Untitled ": you are perhaps not working with the base language English. In this case you may login with english and maintain the language you use accordingly. Then you should see the right name in your language.

Regarding I got blank excel as output: You have to have at least one BPMN model in your selected group structure and at least one lane used in such a BPMN model. If this is not the case, this report can not give you any return.

Hope this answers your questions.

Regards, Volker

 

0
by Darlene Hinkle
Posted on Mon, 05/10/2010 - 23:18

Could you forward the link to this report?  I'm not able to find it. 

0
by Volker Eckardt Author
Posted on Tue, 05/11/2010 - 09:43

Hi Darlene,

Thanks for pointing this out! You are right, the download link appears only in case you are logged in. Please see also the next version  with more flexibility here.

Best regards

Volker

0
by Umut Oezleyen
Posted on Tue, 08/31/2010 - 11:23

Hi Volker;

I have also a related question about Matrix report and Matrix diagrams. Is this somehow possible to make this procedure backwards?

Could we also export an Excel sheet due to your report and modify it, & after that import it back into ARIS with modificated relations?

I just wanna explain my question with screenshots, I am sure than you will understand me better.

For example I have this matrix diagram in ARIS...

Then I can call your report or another one, which convert my matrix into the Excel Sheet.

Then I call for example the report "Export the relation matrix" (I am not sure about the english name but in german that's "Beziehungsmatrix exportieren"

Now I have exactly my matrix on Excel. Perfect.

 

What I wanna do is; just change the relationships on Excel manually, and import it in ARIS back, so that I have my modificated matrix diagram in ARIS. (Just like the macro Process Generator)

  

Is there any Report to realise this?

If not; could you please give some code examples to solve this problem.?

I am sure , this would be extremely useful for all ARIS Users (Especially for the ARIS Report beginners like me).

Thank you in advance for your attention.

Greetings

Umut Oezleyen

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