RW

Can anyone make any recommendations on the best way to read data from the ARIS database?

We are using the Sybase ASA database.

by Markus Werner
Posted on Tue, 10/13/2009 - 11:25

Hi Russell,

why don't you just use the reporting functions that ARIS offers?

Regards,

Markus

0
by Pedro Jauregui
Posted on Tue, 10/13/2009 - 21:33

Hi Russell,

I agree with Markus, probably the best way to access data form the Aris DB is with the reporting functions that Aris offers.

It doen´t have the best API, but is easy to get started.

See ya.

0
by Markus Werner
Posted on Tue, 10/13/2009 - 21:48

Hi Pedro,

we also offer the WYSIWYG editor now. Using it makes it very easy to output some information, and you don't have to use the API.

Regards,

Markus

0
by Rick Bosworth
Posted on Wed, 10/14/2009 - 02:55

Using third party reporting tools won't work very well. The actual database structure that ARIS uses is very generic, as it is with most modeling tools. Also, reporting directly against the database is a bad idea as IDS Scheer (or Software AG now) is free to change the structure from release to release. The API is the way you need to access the data is you wish to do it outside of ARIS.

There is a thrid party option Cogniscape by Cogniviz. They provide dynamic access to the content of the ARIS DB.

 

0
by Markus Werner
Posted on Wed, 10/14/2009 - 09:44

Hi Russell,

what exactly do you want to report?

Perhaps I can offer you some help to solve the problem using the WYSIWYG editor.

Cheers,

Markus

 

0
by Russell Wion Author
Posted on Thu, 10/15/2009 - 16:16

Thanks everyone for your advice.

I'll check out the WYSIWYG Report editor.

0
by Markus Werner
Posted on Thu, 10/15/2009 - 16:27

Hi Russel,

it is part of the ARIS Business Architect.

Go to the module Administration and connect to the server.

Now you can select evaluation, then reports and a category(or create a new one) where you want to create your report.



In the now appearing wizard you can specify the context to start the report. Important is on page "Output" to select "Use report template (design view)" and also define a template.



I hope this makes it easier to start with the WYSIWYG editor.

You will find a small tutorial in the ARIS Help (create scripts - use cases - How to work with report script templates)

If you have further questions, don't hesitate to ask.

Regards,

Markus



 

0
by Donald Dillon
Posted on Fri, 10/16/2009 - 15:51

I use the find functionality and queries frequently and then copy the results to excel for analysis. 

Yesterday I wanted to identify and count how many models with duplicate names I had in my db.  I did a query found all models plus level attribute

copy to excel, import to ms-access, query on name, model type, level- count the duplicates.

export query results back to excel as a unique list of duplicate models and the number of duplicates per model name, type, level...

Results-time to enforce some conventions about model names.

 

 

0
by Markus Werner
Posted on Fri, 10/16/2009 - 16:08

Hi Donald,

you may use the WYSIWYG-report designer to create an excel output.

You create a report with an database as context, and choose excel as output.

Now you can create a datatable for all models, and sort them by name, type and group hierarchy.

Then choose the datafields you want to be part of the output.

See the attached screenshot.

I hope this would make your work easier.

Regards,

Markus

0
by Donald Dillon
Posted on Fri, 10/16/2009 - 16:10

We are using 7.0.2 currently in production

the copy and paste is quicker than creating the report in most cases.

thanks

donald

 

0
by Markus Werner
Posted on Fri, 10/16/2009 - 16:14

Ok,

the WYSIWYG designer is part of ARIS 7.1. I am sorry, but you won't be able to do it that way.

Using it (with 7.1), it took me about 2 minutes to create the report, so it will be faster when resuing it frequently.

Bye,

Markus

0
by Rodrigo Fuentes A.
Posted on Mon, 01/11/2010 - 15:47

Hey thats very useful help to knowing where to find the proper scripts to start to work...

 

Anyway i'm new here and recently i starting to work with BPA, BPM the ARIS tools of course.. so i got a question, recently i finished the documentation (modeling) of a few proccess and i print some test reports and the people who evaluate the information ask for a little modifications to the format (basically hide or dont show some data).. he send me back a simplified report with highlight yellow fields wihch are the ones he wants to don't be visible on the final reports... so here is the report:

Screenshot of the modified report, the yellow highlighted areas are supposed to be deleted

Can you please help me about recognize the fields of the scripts wich are corresponding to those fields?? (i was reading the scripts and i think there is one specific script which has the lines that can be modified to solve this).. any help would be very useful to me.. Thanks for reading me and thanks for all the knowledge expressed in this community!

0
by Markus Werner
Posted on Mon, 01/11/2010 - 15:59

Hi,

are you using the design view (wysiwyg-editor)?

Cheers,

Markus

0
by Rodrigo Fuentes A.
Posted on Tue, 01/12/2010 - 15:30

Hi!.. thanks for ask (i forget to detail that). Not really, actually i was looking the code and searching in the files located at Evaluation/Reports folder (maybe those aren't the right ones?)

Anyway i'm working with Aris IT Enterprise Architect 7.1, i should look for the desing view this time??

Thanks for your attention, i will be looking for your help.

0
by Rodrigo Fuentes A.
Posted on Wed, 01/13/2010 - 13:16

Finally i change the focus and i begin to use the design view.. so changing options and trying to figure out how it works i was ablle to do a report:

 

But i have problems with the filtering options, i have a full EPC model with many events, functions and this functions has some inputs and outpus plus responsable people in charge... basically i want to print some repor in this format:

 

HEADER

1. Diagram name

(Screenshot of the diagram)

2. Diagram details

Table of contents:

__________________

Name of function 1

----------------------------   

Description of function 1

----------------------------

Input 1 of function 1

----------------------------

Input n of function 1

----------------------------

Output 1 of function 1

----------------------------

Output n of function 1

----------------------------

People on charge of function 1

----------------------------

People on support of function 1

----------------------------

Name of function n

----------------------------

...

----------------------------

People on support of function n

FOOTER

 

And so on with all the functions involved on the diagram... as you can see on the above image i was able to show all the functions with the respective description... Thanks!

0
by Rodrigo Fuentes A.
Posted on Thu, 01/14/2010 - 17:52

Well to add more information, i made manually a report with the format which i need:

 

ths is what i looking for

 

Thanks for your attention.

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
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • Profile picture for user kbiront
  • PacMan

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