Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Mr.Scott

Pages: [1]
1
General Board / Reference Tag Values on Element During Simulation?
« on: October 01, 2014, 05:11:06 am »
Hi, How do you access an elements tag value during a simulation (using Javascript)?  For example, if an activity diagram has an action "AAA" and a tag set to throughput = 55.  How would you write Javascript to print "55"?

2
General Board / Reference a Script in an Action's Effect?
« on: October 01, 2014, 05:02:17 am »
How do you reference a script and one of its functions in an Action's Effect?
For example, how would you add the !INC EAScriptLib.JScript-Logging script and use the LOGInfo() function?

3
General Board / Re: Parametric Model - How to Build Complex Model?
« on: September 26, 2014, 05:29:49 am »
A little more detail.  I am trying to create a simulation of a series of batch jobs that will run nightly.  some jobs will be scheduled for a specific time; others will be dependency driven (1 or more dependencies).  The goal is for the simulation to (a) identify the critical path of the jobs, (b) the duration for each job and (c) the duration for all jobs.

Here is what I have done thus far:
(1) Created a <<constraintBlock>> JobConstraint (in the Library/ConstraintBlocks' package with the following properties:
    (a) startTime
    (b) volume
    (c) throughputPerSec
    (d) duration
    (e) endTime
(2) Added a formula to compute 'duration' and 'endTime'
      duration=volume/throughput
      endTime = startTime + duration;
(3) Created a 'BlockDefinition' diagram
      Created a constraintBlock job1
      Created a parametric diagram for jobs 1 with a property of JobConstraint
      Created a properties to define input and output values.
      Run a simulation outputting the simulation :)

I have created a <<Block>> with a property for volume and throughput and set default values to these properties.  I tried dropping the block onto the parametric diagram and connecting the block's property to the job1.property (ex. BlockA.volume --> job1.volume).  If I run simuation, the default value of BlockA.volume is not passed into the contraint block.  I have the option to set a value for BlockA.volume in the simulation window and it still doesn't work.  Has anyone got this to work?


4
General Board / Parametric Model - How to Build Complex Model?
« on: September 25, 2014, 07:01:35 am »
Hi - I am working on building a simulation to understand what the total processing time will be for N processes that run, some of which will be parallel and some dependency driven.  I would like to have a parametric model for each process and one that chains all of the processes together.  I know how to create individual parametric models.  But, how do you link constraint blocks to one another or the outputs of one to another's input?

I tried creating a property (of a constraint block) per a process in 1 diagram but that would not be manageable given the # of processes and different inputs.  Is there a good resource (cookbook, tutorial) that explains how to setup complex parametric models?

5
Bugs and Issues / Re: Lost 'File' Drop Down on Main Menu Bar
« on: December 10, 2015, 08:41:53 am »
Tools | Customize fixed it.  Many thanks!

6
Bugs and Issues / Re: Lost 'File' Drop Down on Main Menu Bar
« on: December 10, 2015, 07:49:38 am »
That didn't work (Good idea though).

7
Bugs and Issues / Lost 'File' Drop Down on Main Menu Bar
« on: December 10, 2015, 06:02:46 am »
I have lost the 'File' Dropdown on the Main Menu Toolbar and I can't figure out how to get it back.  Help describes how to hide options in the drop downs but I didn't see anything on hiding the top level element like 'File'.  Any ideas?

My toolbar starts with ::  EDIT VIEW PROJECT ... HELP

[Running Sparx EA Version 12 Build 1213 Ultimate Edition]

8
Uml Process / Re: Visualize message type/protocol in diagram
« on: September 25, 2014, 07:07:15 am »
We are setting the stereotype = <protocol> and giving the communication line a descriptive name on what is being sent.  This made it easy to visualize

9
Your approach makes sense and looks good.  A friend suggested I look at the 't_connectortag' table and I was able to do it on a SQL join using the join below.  I may try swapping to the operation approach.

...
FROM t_connector AS c
LEFT JOIN t_connectortag ct on (ct.elementID = c.Connector_ID)
LEFT JOIN t_operation o on (o.ea_guid = ct.value)
...

10
Hi, I am generating a document with a sequence diagram and I am trying to understand how to write a query to get the description off of the operation on the component object.  Does anyone know how to link the operation on the sequence line to the component's operation?

Here are the steps I am taking:
On Sequence Diagram add components as an 'instance'
On sequence lines, select an operation defined on the component.

The query below returns the description on the sequence line on the diagram.
SELECT c.SeqNo, c.Name as FUNCTION_NAME, c.Notes as DESCRIPTION, c.SourceConstraint AS IMPACT
FROM t_connector AS c
WHERE (c.Connector_Type = 'Sequence')
AND (c.DiagramID = #INSERT DIAGRAM ID#)
ORDER BY c.SeqNo

From the object model and the queries I have tried it's not clear how to map the operation on the sequence back to the component's operation.  Do you know what tables I need to look at to do a join on?

11
q - thank you for the tip.  that got me pass the Sparxs data model, next step is parsing a sql string.

Here's what I have now -
Code: [Select]
SELECT tx.description
FROM t_xref tx
WHERE tx.Name = 'MOFProps'
AND tx.client IN (##Connectors EA_GUID##)
-- {you can replace ##Connectors EA_GUID##' with the guid of an association}

To generate a meaninful name, the query above needs to be placed in the where clause of something like
Code: [Select]
select cIF.name as 'InfoFlowsRealized'
FROM t_connector cIF
WHERE cIF.ea_guid IN [QUERY_ABOVE]

As the first query returns a comma separated string '{GUID1},{GUID2},{GUID3}' the values need to be split so the second query can match properly.  it looks like a function is needed as outlined here - http://sqlperformance.com/2012/07/t-sql-queries/split-strings

12
I am creating a custom report and need help identifying the 'association' that realizes (i.e. 'summarizes') the 'information flow'.  Does anyone know what table to look in?

Here is what we are doing:
  • Create diagram with information flows (ex. CompA:port1 has 'information flow' 1..n to CompB:port2)
  • Create diagram using associations (ex. CompA:port1 has an 'association' to CompB:port2; The association realizes 1..N 'information flows'.
  • Then creating a custom report to present details out.

Here is the custom query I have thus far:
SELECT c.connector_id
, c.name as informationFlowName
--, (select name from t_object where object_id = c.start_object_id) as source
, (select CONCAT((select name from t_object where Object_ID = o.ParentID),'::',o.name) as FullName from t_object o where o.object_id = c.start_object_id and o.ParentID >0 UNION select o.name as FullName from t_object o where o.object_id = c.start_object_id and o.ParentID = 0 ) as source
, (select CONCAT((select name from t_object where Object_ID = o.ParentID),'::',o.name) as FullName from t_object o where o.object_id = c.end_object_id and o.ParentID >0 UNION select o.name as FullName from t_object o where o.object_id = c.end_object_id and o.ParentID = 0 ) as target
, c.StereoType
, '???' as 'RealizedByAssoc'
FROM t_connector c
WHERE c.connector_id IN (
select connectorId
from t_diagramlinks
where diagramid in (select diagram_id from t_diagram where name = '<Search Term>'))
and len(name) > 0
and connector_type = 'InformationFlow'
order by informationFlowName, source, target

13
Hi - I am looking to simulate roughly 150 batch jobs and would like to get some guidance on how to best set this up based on the criteria below.

I recently started using Sparx and am running Ultimate Edition v10.0.1006.  I have been reading the docs and can run a simulation on a basic activity diagram (i.e. events in an Action) and I am starting to follow the SysML and Paramater/Constraint settings (though it is not 100% clear).

From the simulation, I would like to capture:
- estimated total batch duration for peak load for yr 1, 2, .. 10 for each Division (1..5)
- estimated total batch duration for avg load for yr 1, 2, .. 10 for each Division (1..5)
- estimated individual job start time / end time based on avg and peak load for yr 1..10 for each division (based on chained predecessor or defined start time)
- graph ideally showing the batch duration for avg/peak load (plot to graph)
- identify if SLAs are not met

Data inputs - I have a spreadsheet with daily average and peak volumes for a 10yr period for 5 divisions, predecessor(s), throughput estimates, SLAs (i.e. must complete by) and a lot more other details not listed here.  Some jobs include a defined start time and occurs when there is no predecessor.

Is there anyone that can provide guidance on how to best simulate this in Sparxs?

Pages: [1]