Comments

Hi,

If I understood your question correctly you can achieve this by following in report script.

1. Select the model ArisData.getSelectedModels()[0]

2. Get all the person type occurrence model.ObjOccListBySymbol(<person symbol> or Constants. AT_PERSON_1);

3. For all person object occurrence get  Person Type- Role .getConnectedObjOccs(Constants.ST_EMPL_TYPE);

4. Similarly for IT Roles

5. Similarly what Permissions the person is having

Thanks

Abhijit Das

abhijit.das@cba.com.au
       

Hi,
Thank you for this response. Does some template exist for that kind of report ? As Business modeler I'm not really aware of scripting so somethink that easely could be adapted should be helpful.

Thanks in advance,
François Dumont
francois.b.dumont@bnpparibasfortis.com

Hi Francois,

You should be able to produce this report using the report designer, which gives you the opportunity to build your report in a visual way. Since this is a pretty straight forward report, the report designer can produce this report without any doubt.

Best regards,

Edwin

Hi,
In ARIS 7.1 the standard report "Output object Information (table)" provides an Excell sheet where a new tab is created for each object Type selected.
How can I obtain the same output but with a new tab created for each Object Symbol instead of Object Type.

Thanks in advance for advices.
Kind regards

François

Hi Francois,

If you can access the source code, you should look for the BeginTable and EndTable of the outputfile created. These methods relate to a new tab in excel output (if using the output object). In the excel object there's the XlsWorkbook.CreateSheet method.

For this purpose, if you can access the source code, you should adapt the code to create a new tab (EndTable for the current followed by BeginTable for the new tab) after shange of the symbol. This will be a quite a job, since the Output object information script (called by the Output object information (table) script) is based on the object definitions rather than the object occurences. So the basic handling of the script needs to be changed as well.

If you build a report using the report designer, basically every section will result in a new tab in excel.

Hope this helps a bit,

Best regards,

Edwin

Hi Edwin,

Thanks for your support.
I tried indeed to build ad-hoc reports with the Wizard, after some trials it becomes effectively not to difficult to use.
The biggest problem I have is that I can create outputs to PDF or Word but my outputs to MS-Excell are empty. Only the "tabs" are created unless the same report runned with PDF or RTF outputs works.

Some ideas ?

Best regards
François

Hi Francois,

When you use the report designer, you need to put all datafields you want to output to excel in a table format. Otherwise no output is realized.

Best regards,

Edwin

Hi again,

Working with the report wiard, how can I create a dialog box at startup of a report that should allow to select a object symbol to report on, knowing that I need objects in different groups and subgroups.

Thanks in advance,
François

Hi Francois,

With the report wizard on it's own it's not possible to do so. Basically the approach here is to create a query to find all the necessary objects, or to write a custom macro or script to handle the selection part, and trigger the report from the custom script.

Sorry that i can't offer you any other means.

Best regards,

Edwin

Hi,

In order to maintain my models I should be able to use updated data from external sources.
I'm trying to understand how I could best import data from DB2 and Oracle DB's.
Is it mandatory to import XML files into Aris ?
Or can we connect directly those DB's and than - create - update, objects and connections and their respectives attributes ?

At this point in time SQL queries that extract the needed data are already existing, could we reuse them ?

Thank a lot for suggestions - tips, one of my concern of course is the effort that should be needed to achieve that kind of synchronisation (budgets are more than tiny).

François Dumont