WYSIWYG question

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.

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

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.

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

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.

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

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

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.