on 06-16-2010 1:40 PM
In my testcase I have set up a decision table with multiple columns. As long as the number of rows is low it is easy to maintain. But we are looking at the possibility to use this kind of business rules in our current project, and then it would end up in at least 1000 or more rows.
Is there an easy, user friendly way to let the business users maintain such a decision table ?
Do you need to activate this decision table every time something is changed ?Is it possible to make this decision table local and the rest of the parts (application, data objects, function) transportable ? How can you deal with such a situation in the best way ?
Is there a query / filter functionality to query a decision table ?
Best regards,
Elly van de Wouw
IT - IFF
Just to back up what Carsten has said, I wrote a Decision Table upload/download program in NW 701 and uploaded a simple 3-column table with 1,000 rows. Searching this took about 1 minute. Given that we require lots of tables, some of which will be even larger than this example, and some require multiple searches (by different customers), this is totally unworkable. We are now having to redesign our approach.
Even 100 secs for a single Decision Table lookup is way too long for an online transaction.
Carsten, can you advise how many rows your NW 702 test table contained ?
Regards,
Grogan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You cannot use such big decision tables in NW 701 but only in NW 702. The reason is a change in the internal data model.
In NW 701 you will run into timeouts.
I did some internal testing in our development systems.
1. programmatically create a decision table with many rows (10 columns)
2. activate and save
3. execute it (includes code generation)
In NW 701 I did achieve around 800 rows and then I had a timeout. I hav to admit the system is also quite poor.
In NW 702 it took about 100 seconds. In NW 702 you also can maintain the decision table entries in MS Excel and upload into the table.
You need to activate the changes so that they are used for rules execution. As of NW 702 you further have possibilities to combine local and transported content.
BR,
Carsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.