How to update decision tables automatically?

594 views Asked by At

Is it possible to update registrys of a table decision without manually chagining them? For example if I have a condition column with a date value, I want to delete those lines or transfer them to another table when that date occurs. This in order to keep the amount of rules in a decision table low and make the deployment faster when the business users need to update the table.

If its not possible to change the values in execution mode automatically, perhaps mark such rules as invalid due to the effective date or make them not to be considered when a deployment of the decision table is performed.

1

There are 1 answers

1
sdfx On

Is your main concern execution performance or getting rid of unwanted rules so you don't confuse your business users? If it's performance, I'd advice you to do some performance testing before you spend a lot of time optimizing your rules. ODM/JRules is amazingly efficient, so your otimizations might not be even necessary.

If you want to remove whole rules during deployment, your best chance is the ruleset extractor, which decides which rules to add to a deployment. Take a look here for more information about ruleset extractors: https://www-01.ibm.com/support/knowledgecenter/#!/SSQP76_8.7.0/com.ibm.odm.dserver.rules.samples/designer_smp_topics/smp_rd_brmrulesetextr_det.html

But in most cases I'd wager, that adding another column with an "effective until" condition column would suffice, since ODM will just ignore these entries without too much of a performance impact.