Author Topic: Project Status Tracking  (Read 1257 times)

39steps

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Project Status Tracking
« on: June 29, 2004, 03:59:32 am »
We are using the following states to tack our use case:

Proposed - Item has been proposed

Accepted - The entity has been accepted as being within the project scope and needs to be elaborated and can be traced to a requirement.

In Design - Approved for design to start but they are getting updated as the design progresses. The design can be traced to all use cases it implements.

In Development - The design is being coded.

Frozen - The entity has been checked and approved by the project team and the design is frozen. <<At this point we would like to lock them and ensure that all changes are logged as maintenance object defects, changes and issues, and also that no one will be able to delete the item.>>

As Built - In line with the final implementation.

Out of Scope - Not in the scope of the project.

All members of our project team are using spreadsheets with imbedded queries that use an ODBC connection to the sql server database (so they can update dynamically) and auto filters.

For example, we have a spreadsheet report showing the use cases statuses described above for target versions and builds.

In addition we have a spreadsheet report for problems, issues and changes associated with frozen use cases.  The problem being that using EA you don’t know that there is a problem if you don’t select the element but you don’t know to select the element if you don’t know if there is a problem etc cetera :)

We have other reports for example to track the maturing of the whole project tracing from requirements to business processes and use cases and then to designs, test cases and user document topics.

Are there any plans to build in a reports or/and to provide a report building tool into EA.

Is any one else doing something else to do this sort of thing an another way?


angel-o-sphere

  • EA User
  • **
  • Posts: 112
  • Karma: +0/-0
    • View Profile
Re: Project Status Tracking
« Reply #1 on: June 30, 2004, 06:42:09 am »
Hi,

would it be possible to get such a spread sheet or to see a screen shot?

I'm fighting heavy at my current customer side (they have 5 licenses of EA bought) to prevent them to switch to Together/J.

And a Excell based reporting would be excellent for them ... I personally lack knowledge to access EA databases with excel.

Hm, sidenote: is it needed to have the DB in Oracle etc. or can this be done with simple *.EAP files?

angel'o'sphere

Barry_Pearce

  • EA User
  • **
  • Posts: 70
  • Karma: +0/-0
    • View Profile
Re: Project Status Tracking
« Reply #2 on: June 30, 2004, 07:18:50 am »
I assume the DB in ORACLE reference is due to cost? just guessing here....

If so use a MySQL database (free) for sharing. We use it and it works a treat.
EAP files themselves are not very suitable for sharing across teams on a network.

I believe this is documented in the user guide - somehwere about team development.

39steps

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Project Status Tracking
« Reply #3 on: June 30, 2004, 08:26:14 am »
Hi angel-o-sphere,

This is standard excel suff.

In excel go to Data -> Get External Data -> New Database Query

Then select a database source e.g. oracle, access (i.e. a .eap file) or sql server.  We are using sql server.  The best thing to do is to create an obdc connection to your database on your pc that can be used be lots of different spreadsheets.

As you run the query wizard select ‘view data or edit query in Microsoft query’.  Onece in Microsoft query it is all drag and drop to product basic queries.

Or you can do it the hard way and type in the sql

e.g.

SELECT t_package.Name AS 'packageName', t_object.Name, t_object.Version, t_object.Phase AS 'Build', t_object.Status, t_object.Note, t_object.Author, t_object.NType, t_object.Complexity, t_object.Effort, t_object.CreatedDate, t_object.ModifiedDate, t_object.PDATA5, t_object.Concurrency
FROM ea_pike.dbo.t_object t_object, ea_pike.dbo.t_package t_package
WHERE t_package.Package_ID = t_object.Package_ID AND ((t_object.Object_Type='UseCase') AND (t_object.Status<>'Proposed' And t_object.Status<>'Out of Scope'))
ORDER BY t_object.Phase, packageName


If you want to see the database schema just change a .eap extension to .mdb and open it in access and look at the relationships view.

AdamHearn

  • EA User
  • **
  • Posts: 58
  • Karma: +0/-0
    • View Profile
Re: Project Status Tracking
« Reply #4 on: June 30, 2004, 08:31:04 am »
Another option to use is MSDE which is essentially a limited version of SQLServer. If Sparx registered for redistribution, they could actually provide this DB engine with the application...

It's suitable for up to 25 users, has an artifical performance guvenor which slows the engine down when there are more than 5 active commands (I kid you not!) and has a DB storage size limit of 2GB. You can administer the DB with the standard SQLServer tools or VS.NET.

If your company has licenses for VS.NET, SQLServer or MSDN (not library) then you can use it. For full details, check out Microsoft's page

We (as you may guess) use MSDE and actually found it performed better than mySQL (which was at the time, the latest V3 release).

Barry_Pearce

  • EA User
  • **
  • Posts: 70
  • Karma: +0/-0
    • View Profile
Re: Project Status Tracking
« Reply #5 on: June 30, 2004, 09:23:46 am »
As a side note we are on MySQL 4.0.17 under SuSE 9.0 Linux.
« Last Edit: June 30, 2004, 09:24:03 am by Barry_Pearce »