Package Metrics

[ps22571]

We would like to use the Package Metrics Documentation supplied with EA, but unfortunately the metrics are based on Use Cases whilst we base our metrics on the number and complexity of classes. I use the complexity drop down on the class specification but I can't seem to find anything that reports on this value - am I missing something?  

what I'm looking for is:

Man Hours = (number of classes * hours per class * complexity factor)

thanks

[thomaskilian]

Try this SQL:

Code: [Select]

SELECT t_package.Name, t_object.Name, t_object.Complexity, t_object.Object_Type
FROM t_object t_object, t_package t_package
WHERE t_package.Package_ID = t_object.Package_ID AND ((t_package.Name=<pck>) AND (t_object.Object_Type='Class'))
and replace <pck> with the name of your according package. The rest should be obvious.

[ps22571]

I'm assuming I execute the sql within Enterprise Manager - not EA?

thanks

[thomaskilian]

Sure The advantage of having a database driven tool is that you can deploy the database with other tools. Hope it helps.

[fhritz]

An EAP file is an MS-Access 97 file.

Open a new Access DB and Open the dialogs:

File --> Get External Data --> Link Tables
then choose the directory where your EAP file resides and enter the filename (will not be displayed because of the extension .EAP).

Then select all tables. Thats all to do.

Frank

[ps22571]

Sorry, I think this message is going a bit off track - what I would have liked to have done is do my metrics within EA, basing my calculations on classes rather than use cases, not building my own Metrics routine using the values direct from the database tables.


Thanks

[thomaskilian]

EA does not have such functionality and will likely not have it in the near future. Inspecting the underlying database is not too far off. So I suggest to give it a try. Create an ODBC connection and use MSQRY32 for the EAP files (Access driver) or use your SQL tools for other databases.