WYSIWYG question

Manuel Hobisch on November 3, 2011

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

Bookmark

Notify Moderator

8 Replies

Bruno MARIA on November 5, 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.

or register to reply.

Notify Moderator

Manuel Hobisch Author on November 7, 2011 - 09:12 as Reply to Misha Akopov

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

or register to reply.

Notify Moderator

Bruno MARIA on November 7, 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.

or register to reply.

Notify Moderator

Manuel Hobisch Author on November 8, 2011 - 08:56 as Reply to Sebastian Stein

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

or register to reply.

Notify Moderator

Bruno MARIA on November 8, 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.

or register to reply.

Notify Moderator

Manuel Hobisch Author on November 8, 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

or register to reply.

Notify Moderator

Manuel Hobisch Author on November 8, 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

or register to reply.

Notify Moderator

Bruno MARIA on November 8, 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.

or register to reply.

Notify Moderator