Help with ARIS Report Design

Ismael Shameem Etowar on December 3, 2009

Dear Community, I need help and advise regarding the following:

I have a database whose structure is as follows

An example of an EPC Model in the Db is

I need to create a report using the ARIS 7.1 ‘WYSIWYG’ functionalities to display the following information extracted from the EPCs:

Process Name	Sub-process Name	Person Type	Application System Type	Screen
Process 1	EPC_1	Person Type A
		Person Type B
		Person Type C	X	S 1
		Person Type D	Y	S 2
	EPC_2	Person Type E	Z	S 3
		Person Type A Person Type F	M	S 4
Process 2	EPC_6	Person Type G Person Type C	N	S 5

I tried a few combinations but unfortunately I could not get the expected result. I shall be most grateful if anybody can help me out. Thanks beforehand. Best regards Shameem

Bookmark

Notify Moderator

9 Replies

Jerry John on December 5, 2009 - 07:55

You can develop the report base on the group and find the models ，then process the Occs in Models

or register to reply.

Notify Moderator

Ismael Shameem Etowar Author on December 6, 2009 - 09:40

Dear Mr John,

Thank you for your help.

I shall review my report accordingly.

Cheers

Shameem

or register to reply.

Notify Moderator

Ismael Shameem Etowar Author on December 6, 2009 - 17:08

Hi Again, I tried the above and the end result is still not as expected. I exported the extraction into MS Excel, unfortunately the information is being displayed on several Excel sheets and the displayed information is not coherent at all. Below are the results and my report for the appended EPC model:

I have the following in my report design: · A query of all the EPC models in the selected group · A query for all Application System Types in the selected EPC model · A query for all Person Types in the selected EPC model. Thank you beforehand for any advise or help. Best regards Shameem

or register to reply.

Notify Moderator

Jerry John on December 7, 2009 - 14:35

hi Shameem,I have designed a sample report according to your description.The code is as follows:

//var

var gi_LocaleId    = Context.getSelectedLanguage();                        //语言

var gs_OutFileName = Context.getScriptInfo(Constants.SCRIPT_NAME)+ ".xls"; //输出报表的文件名

var gs_HeadList    = new Array("Process Name","Sub-process Name","Person Tpye","Application System Type","Screen");//表头

var gi_WidthList   = new Array(18,30,18,30,24);//列宽

var go_OutFile     = null;

//主函数

function main()

{

    var go_SelectedGroupList = ArisData.getSelectedGroups(); //选定运行的组

    var go_SelectedSubgroupList = go_SelectedGroupList[0].Childs(false);

    go_SelectedSubgroupList = go_SelectedSubgroupList.sort(sortName);

    //Dialogs.MsgBox(go_SelectedSubgroupList.length);

    go_OutFile = uf_InitOutFile(go_OutFile,gs_OutFileName,gi_LocaleId);

    go_OutFile.BeginTable(100, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0);

    go_OutFile.TableRow();

    for(var i=0; i<gs_HeadList.length; i++)

      go_OutFile.TableCellF(gs_HeadList[i], gi_WidthList[i], "TABLE_HEAD");



    for(var j=0;j<go_SelectedSubgroupList.length;j++)

    {

        var ls_ProcessName = go_SelectedSubgroupList[j].Name(gi_LocaleId);

        var lm_ModelsEPC   = go_SelectedSubgroupList[j].ModelList ( );

        lm_ModelsEPC =lm_ModelsEPC.sort(sortName);

        for(var k=0;k<lm_ModelsEPC.length;k++)

        {

            var lo_FunctionOccs = lm_ModelsEPC[k].ObjOccListFilter ( -1, Constants.ST_FUNC );

            var ls_Sub_ProcessName = lm_ModelsEPC[k].Name(gi_LocaleId);

            if(lo_FunctionOccs.length==0)

            {

                go_OutFile.TableRow();

                go_OutFile.TableCellF(ls_ProcessName, 10, "TEXT");

                go_OutFile.TableCellF(ls_Sub_ProcessName, 10, "TEXT");

                go_OutFile.TableCellF("", 10, "TEXT");

                go_OutFile.TableCellF("", 10, "TEXT");

                go_OutFile.TableCellF("", 10, "TEXT");



            }

            //Dialogs.MsgBox(lo_FunctionOccs.length);

            for(var m=0;m<lo_FunctionOccs.length;m++)

            {

               var lo_PersonTypeOcc =lo_FunctionOccs[m].getConnectedObjOccs ( Constants.ST_EMPL_TYPE );

               var lo_SystemOcc     =lo_FunctionOccs[m].getConnectedObjOccs ( 65569 );

               var lo_ScreenOcc     =lo_FunctionOccs[m].getConnectedObjOccs ( 16 );



               go_OutFile.TableRow();

               go_OutFile.TableCellF(ls_ProcessName, 10, "TEXT");

               go_OutFile.TableCellF(ls_Sub_ProcessName, 10, "TEXT");

               if(lo_PersonTypeOcc.length>0)

               go_OutFile.TableCellF(lo_PersonTypeOcc[0].ObjDef ( ).Name(gi_LocaleId), 10, "TEXT");

               else

               go_OutFile.TableCellF("", 10, "TEXT")

               if(lo_SystemOcc.length>0)

               go_OutFile.TableCellF(lo_SystemOcc[0].ObjDef ( ).Name(gi_LocaleId), 10, "TEXT");

               else

               go_OutFile.TableCellF("", 10, "TEXT")

               if( lo_ScreenOcc.length>0)

               go_OutFile.TableCellF( lo_ScreenOcc[0].ObjDef ( ).Name(gi_LocaleId), 10, "TEXT");

               else

               go_OutFile.TableCellF("", 10, "TEXT")



            }



        }



    }



    go_OutFile.EndTable("DD", 100, "", 0, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT, 0);

    go_OutFile.WriteReport();

    Dialogs.MsgBox("The file has been output!");

}

main();

// 排序用到的函数，基于对象的“表示符”大小

function sortName(a, b)

{

return a.Name(gi_LocaleId)>b.Name(gi_LocaleId);

}

or register to reply.

Notify Moderator

Ismael Shameem Etowar Author on December 7, 2009 - 16:48

Dear Mr. John,

I am really thankful to you for your help and time dedicated to help me out.

I really appreciate.

I shall try the code tomorrow morning first thing and give you feedback:)

Thank you again for your precious and valuable help

Best regards

Shameem

or register to reply.

Notify Moderator

Ismael Shameem Etowar Author on December 8, 2009 - 08:45

Hi Mr John,

I copied the code into ARIS but unfortunately i'm having an error message:

As I am not a professional programmer , I asked for help around with colleagues who are more at ease with Java script, but we could not find our way out.

Thank you again for your valuable help

Cheers

Shameem

or register to reply.

Notify Moderator

Jerry John on December 8, 2009 - 13:17

oh,i forgot adding the definition of the"uf_InitOutFile".You can add the following code behind the report.

function uf_InitOutFile(ao_outfile,as_outfileName,ai_LocaleId)

{

    ao_outfile = Context.createOutputObject(Context.getSelectedFormat(), as_outfileName);

    ao_outfile.Init(ai_LocaleId);

  ao_outfile.DefineF("TABLE_HEAD","Arial", 15, Constants.C_BLACK,Constants.C_GREY_80_PERCENT, Constants.FMT_BOLD | Constants.FMT_CENTER | Constants.FMT_VCENTER, 0, 0, 0, 0, 0, 1);

  ao_outfile.DefineF("TEXT","Arial",10,Constants.C_BLACK,Constants.C_TRANSPARENT, Constants.FMT_LEFT | Constants.FMT_VCENTER, 10, 0, 0, 0, 0, 1);

    return ao_outfile;

}

PS: This report is designed according to your first description.Its funtion is limited. U shoud run it base on the group of "main group". My MSN is rnhmn@hotmail.com

or register to reply.

Notify Moderator

Ismael Shameem Etowar Author on December 8, 2009 - 16:40

Dear Mr John,

Really many many thanks for this:)

I owe you one:) I hope I have the opportunity to help you out some days too:)

I shall try the code tomorrow morning at office.

Many thanks again.

I will send you an email on MSN tomorrow:)

Cheers

Shameem

or register to reply.

Notify Moderator

Vladimir Abramov on January 14, 2010 - 13:29

Hi John,

I tried to use this script and specificaly created the same structure as used by Shameen, but I get an error. The program says that the file has been output and then tells me "Error while executing script: Script: line -1". I have tried to debugg and it seems that the code has an error with defining the ao_outfile.DefineF in the uf_InitOutFile function.

Please advise what the problem might be as I am also trying to create a similar report to the above.

Regards,

Vlad

or register to reply.

Notify Moderator

Help with ARIS Report Design

9 Replies

ARIS User Group DACH Meeting zum Thema Konsolidierung

ARIS Roadshow London 2026 - Let’s Get AI Working!

ARIS Usergroup AUSTRIA in Linz, OÖ

ARIS User Group Netherlands (AGNL) theme session: Solution Management