Profile picture for user MHobisch

Hi there,

 

one more question from my side:

I'm now working with the WYSIWYG Report creator. But I'm not able, as I came to a point where I don't know how it would be possible to define this in the creator.

Following situation:

I have an EPC where I connect Risks to Functions. To this Risk an assignment to a BCD (Business Controls Diagram) has been created where I mapped the BCD (Risk, Control, Test definition, etc...). This BCD lies in a different position then the EPC. Also the Risk has been taken from a own risk diagram (which is also not at the location of the EPC) and put as occurance into the EPC (and also BCD).

I tried now to create a report which I can start either on a group or on an EPC. This model should find risk in the EPCs, go to the assigned BCD and give out the following attributes: Risk Name, Risk ID, Control Name and Control ID.

It should be shown like this:

This means that there is the risk and besides there is the refering control to the risk.

 

Is this possible with the WYSIWYG report creator or not?

 

Thanks for all your help in advance.

 

Best regards,

Manuel

by Bruno MARIA
Posted on Sat, 11/05/2011 - 11:12

Hi Manuel,

I had to face this question (see my post here http://www.ariscommunity.com/users/brunomaria/2011-10-09-create-report-export-excel-table-generic-roles) and i found a solution with the WYSIWYG report creator.

To do what your are talking, you have to create a first query to collect risks from the selected EPC. In this query, you have to create a new query to collect the objects of the assigned BDC.

Then you have to create a table and define the different data of each column : you can here collect data from the first query or data from the second one.

I will complete later my initial post by a sreenshot to give you a better idea.

Best regards, Bruno.

0
by Manuel Hobisch Author
Posted on Mon, 11/07/2011 - 09:12

In reply to by misha19888

Hi Bruno,

thank you for your reply.

I have a few more questions:

I already did 2 queries. But my problem is, that I cannot collect the objects from the BCD as I am not able to go to the assigned model from the risk (which is only an occurence copy). For occurances there is no option to drill into the assigned model. Therefore I was asking. But maybe I did not recognize this option.

Just for short understanding:

I will put my issue down in a simple example:

I have a main group which is called "Main Group". In this group I have one group which is called "Business Processes" and annother which is called "Object Library". Beneath those two group I have a complex group structure. Somewhere in the "Business Processes" group there is the EPC with the occurance of the risk (where the BCD is assigned to).

In the "Object Library" group lies the definition of this risk. But the BCD again is somewhere in the "Business Processes" group where again a occurance of the risk has been made as also the definition of the control.

And now I need the report to find certain attributes from the risk as also from the associated control (as shown in the graphic above).

Best regards,

Manuel

0
by Bruno MARIA
Posted on Mon, 11/07/2011 - 20:02

Hi Manuel,

I made a test to reproduce your case and created a report based on the occurences of the objects : 

 

This report is set for a model context (EPC) (It is possible to have the same approach for a group context).

With the first query, the occurences of Risk symbols located in the selected EPC are selected.

With the second query, the occurences of symbols control, linked to the Risk symbols are selected (it is not necessary to select the BCD models).

In the formatting table, i inserted data fields as described above.

The result fits to the excel sheet you want.



Best regards, Bruno.

 
0
by Manuel Hobisch Author
Posted on Tue, 11/08/2011 - 08:56

In reply to by sstein

Hi again,

thank you for your help. It seems to work.

Maybe one more question from my side: Do you know how you can include subgroups into the query? I know that you can drill down each subgroup but is there also a generalization possible (meaning that the report automatically searches all subgroups)?

Best regards,

Manuel

0
by Bruno MARIA
Posted on Tue, 11/08/2011 - 12:46

Hi Manuel,

Here is a new report with a group context. With it, you can launch the report on the main group, the entire hierarchy will be checked to find first the EPCs (with a new query, the first one in my example) ; After that it is identical to my first report :

Best regards,  Bruno.

 

0
by Manuel Hobisch Author
Posted on Tue, 11/08/2011 - 12:56

Hi Bruno,

it's not working. It just searches within the selected group but not also in the subgroups. I did it like this:

The second query should be fine and works as wished. But the only problem now is, that the report doesn't search in subgroups but only in the selected group.

Best regards,

Manuel

0
by Manuel Hobisch Author
Posted on Tue, 11/08/2011 - 13:48

Hi there again,

I now solved the problem. I did not check the "Recursive" checkbox. Therefore it was not searching through the subgroups. Now it works. Everything solved.

Thank you for your help, Bruno.

Best regards,

Manuel

0
by Bruno MARIA
Posted on Tue, 11/08/2011 - 14:05

Hi Manuel,

Can you verify the properties of your first query, in the parameters screen : the option "Recursive" must be activated. If i desactivate it, the EPC is only found in the selected group.

Let me know,

 

Regards, Bruno.

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • 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