Output Specific objects connected to models in a report.

Hi Anaya,

If you have done it in the wysiwyg editor, right click on the script and choose "Edit code". You can then see what the actual code looks like. You should then be able to figure it out. Remember the actual text values is stored in "String Table" section.

If you don't get it right shout again.

Rgs,

Francois

Dear Mr. Francois,

Thank you for the reply.

I tried reading and understanding the script,I found in many places something like:

'constants.{some name}'

for example

constants.OUTEXCEL

is used. I searched Aris Help topics, but I couldnot get anything like this. I would like to know,when and where is 'constants. ' used? Also why is it used?

Thanks in advance,

Anaya

Hi Anaya,

The easiest way is to use the WYSIWYG editor and "Object definition (filterable by type)". In order to get the object definitions of a model you probably have inserted a table or used a query in the editor. In case of the table the editor is showing a section like "for all: Selected models". If you add a table here you can select "data for table rows" as the second step of the user dialog. The box "available data:" starts with "Items of: selected models". Further down there should be an entry "Object definitions" and below "Object definitions (filterable by type)". Select latter and proceed with "Next". On the next page you can select under "Parameters" the "Object type" (e.g. functions, application system etc.).

You can as well check the code afterwards and you will find something like:

dtable(p_output, p_aModel[i].ObjDefListByTypes([Constants.OT_FUNC]))

"OT_FUNC" is the API name of the object type Function and "Constants.OT_FUNC" represents the attribute type number "22". You can find those numbers and API nams in the configuration for other object types.

You could as well work with an unfiltered list of object definitions and just use IF or SELECT CASE statements to specify if an object type should be reported or not. E.g. IF statement used with a list of object definitions

for(var i1=0; i1<p_aObjDef.length; i1++) {
       if(p_aObjDef[i1].TypeNum()==22)  { ...

Dear Mr.Martin,

Thank you so much for the clarification.

if(Context.getSelectedFormat()==Constants.OUTEXCEL)

Can you also please tell me,what is OUTEXCEL used for?

Thanks,

Anaya

Hi Anaya,

You are welcome!

Not 100% sure but this should be related to the output format you have selected for the report. In this case the code just confirms that the selected output format is an excel file...I guess.

Best regards,

Martin

 

Thanks for the help Martin..! :-)

One more question..

I have noticed that every report starts with the method " createOutputObject() ".

I read in the help topics for Aris Script that it is used to " Create a new output object" .

I am afraid I don't quite completely understand the meaning of creating output object. Why do we need it?

Thanks,

Anaya