Book a Demo

Author Topic: Documenting Decision Tables, how?  (Read 3372 times)

ndg2

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Documenting Decision Tables, how?
« on: February 09, 2019, 05:19:02 am »
I'm at a loss when it Comes to simple decision tables. I have to create a Report for Actions and (among other Things like Scenarios, associated use cases etc.) those Actions have decision tables.

Any idea how to document them? Where are those decision Matrices stored? It would be OK for me to just know the SQL tables where those simple DMN table Information is stored and I could use the Automation Interface.

Or is the solution simpler and those tables are something like relationship Matrices?
Any tips?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Documenting Decision Tables, how?
« Reply #1 on: February 09, 2019, 06:28:29 pm »
Without having looked into it, there a reasonable chance this information is stored as some kind of xml format somewhere in the database.
If I need to find out something like this I fire up the profiler on my SQL server and see what SQL update/insert statements are being executed by EA.

Geert

ndg2

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: Documenting Decision Tables, how?
« Reply #2 on: February 12, 2019, 05:08:49 am »
Hello Geert,

thanks for the answer! My first Impression was, decision tables must be somewhere stored in "t_objecttests" or "t_objectscenarios". And while These table are very important in evaluating Scenarios for Actions and other stuff, the decision tables are not stored there.

Now I found something, however. t_document has Elements of type "DecisionTree". There is a field "BinContent", which Looks like a ZIPped binary field. I'll try to extract the Content there and see what I can do with it.


Regards
Frank

Without having looked into it, there a reasonable chance this information is stored as some kind of xml format somewhere in the database.
If I need to find out something like this I fire up the profiler on my SQL server and see what SQL update/insert statements are being executed by EA.

Geert