Tag: Intelligent Advisor

Execution Statistics : 20C New Feature

Whilst some have already upgraded, many are still (at least in their production site) using 20B. I wanted to look at a 20C New Feature in a little more detail in this post. For some of my clients these Execution Statistics features have been very high on their wishlist for a long time. So what are we talking about?

Have you ever needed to identify which parts of the execution process are consuming the most time? Have you longed for some instrumentation? Users of complex platforms like Siebel CRM are familiar with the Application Response Measurement platform and the ability to drill down into domain and subdomain data to find out why something is not performing well.

Intelligent Advisor is not Siebel CRM nor is it trying to be, however this 20C New Feature is the start of more visibility of execution data. So let’s look at what the Execution Statistics functionality introduced in 20C means for rule authors and developers.

Firstly, consider the following : I’ve got a heavy set of rules, and I want to find out what is consuming execution time – is it a particular element – a specific attribute or something else.

There are three things to mention. Firstly, you need a project, and you need some Test Cases. The first pieces of functionality are based around the obvious principle that since test cases are executed on the client PC, and statistics of execution are available in the engine, why not make them available to the rule designer?

Execution Statistics - 20C1

So in the above example this is a project that calculates the journey between two station in the Paris underground network. It’s a pretty heavy set of rules with thousands of interconnected entity instances.

And there are some test cases in a Test Case file.

Execution Statistics - 20C2

We’re going to investigate the three bullet points shown. The first two are based on the Test Cases in your project. If you use the Run button, then the links should appear (assuming you have never done this before). CSV Files are generated. The first file, testPerformance.csv, is generated in the root directory of the project. It is a CSV and once you have cleaned it up, it looks like this:

Execution Statistics - Performance Analysis

So this is a pretty good start for performance analysis – we can see the time is recorded as a very highly precise number. We can see which main components are taking time – in this case the child station amount which is a big loop over thousands of combinations.

The second link is more oriented towards understanding which of the test cases you gave the engine to run are taking longer than others. So clicking the second link provided you with a detailed set of statistics for the test cases. This file is stored in a new folder TestLogs under the root of your project with a name like TestCaseLog_20200827144055.csv. The history of your runs is kept for you since the file is timestamped.

Performance Analysis Test Cases

So in my case I can investigate further by loading the most time-consuming test case into the debugger and looking at it in more detail.

The third button is used in a similar way, but requires external content, specifically a JSON file from one of your REST Batch runs. When you click the Analyse Batch Request button and provide a file (for example, a batch JSON file looks a bit like this in my case (this is just one case, the file probably has 500 cases) :

JSON File Execution Statistics

When the file is selected using the button, after a few seconds (or longer, depending on your project) then a new link appears next to the button (you get to choose the filename and location for this one) :

Access JSON Statistics

Opening this file gives the following output, which is the same performance information, only this time for your JSON files. This is useful if you are using Batch Assess. JSON files like this can also be loaded int the Debugger.

Execution Statistics JSON Output

So you can see that the 20C release has made excellent strides in the direction of execution analysis – rule designers now have something to work with!

Our Survey Results – The Future of Rule Design

A few weeks ago we began collecting results for our latest survey – the subject of course (I’m sure you have been aware of this – apologies if you have received too much communication about it, but we consider it to be one of the most important subjects on the horizon at the moment) is the future of rule design. If you have not voted yet please do!

Many customers have leveraged Word and Excel as an adoption vector – after all, it is easy to “sell” Intelligent Advisor to people who use Excel every day, or who are used to working with Word. Irrespective of your opinion of Oracle Policy Modeling, and where you think the future of rule design is heading, it is hard to deny that these tools are omnipresent in every organization.

So, as we look to the future and imagine what tools might be used in the future – not basing ourselves on any concrete information, not talking about anything that might be used as a future purchasing decision criteria – just wondering about where things might go. It’s probably safe to say that a web editor is on the horizon – a fully Cloud product would need a fully Cloud editing tool.

But there are other possibilities (some which represent missed opportunities – like OpenOffice) and of course there might be no change – we could all be using Word and Excel in the Cloud. So if you are interested in the perspective of the other people who read this article / this site, here are the preferences that people have expressed so far.

The data can of course evolve as more people take the survey, but it is already fascinating reading. Of course it does not answer all of our questions, and to drill-down into the results will take further surveys and questions. But at least we can begin to see what people expect for the future of rule design.

Intelligent Advisor – 3 Cool Things

Intelligent Advisor – Cool Things I didn’t know. Sorry for the clickbait title but they are genuinely things that I didn’t know until I stumbled upon them by chance the other day. Of course the chances are you all already knew about them, but I thought I would reproduce them here for a bit of light relief. They are by turns interesting, useful and perhaps a bit strange but either / any which way I hope they are useful.

Cool Things #1 Multi-Fill Debugging

Fill in multiple attributes of the same type in the Debugger: Suppose you have a bunch of attributes that you need to fill in at the start of a debugging session. Imagine that five of them are booleans. And you just want to make them all true or false. This works also for multiple dates, times or whatever – as long as the attributes have the same type. Just select them all in the debugger using the Shift or Control key and hit Return. You can enter a single value and it will be placed in ALL of the attributes. That’s number one of our cool things right there!

Cool Things 1
Cool Things 1

Cool Things #2 : Reference Tags for Bug Tracking

This one is dedicated to all my friends in Caen. If you are someone who has to work often on debugging documents and fixing tickets, then you will maybe know how useful the Reference Tag feature can be for this. For example you fix something in Word or Excel and push it to testing, only to have to go back a few days later to make more changes. So you can use the Finder in the Oracle Policy Modeling interface and just type in the reference tag details to quickly find any and all places you referenced it. Of course this is good for any reference tag. That’s number two of our cool things! This is good if you use JIRA or some other bug tracking system, or if you want to mark user stories or anything else.

Cool Things 2
Cool Things 2

Cool Things #3 : Run Debug in Browser

This one is probably already familiar to many but it does deserve a mention here. When running the Debugger, just press the Control ley before you click the little green icon (alternatively use the Control + F5 combination to start the debugger) and you will get two windows – the normal debugger in the embedded Internet Explorer 11 thing, and a session of your interview in the default browser of your computer. The browser session doesn’t have impact on the debugger but it is very useful if you are messing with a JavaScript extension for example, or if you want to test geolocation attributes properly. That’s number three of our cool things selection for today!

Cool Things 3
Cool Things 3

Do you have some to share?

If you have your own favorite tricks then share them with the world and we’ll give a prize to the best ones we see here.

The Consultant’s Guide to Oracle Intelligent Advisor

Well, it has taken a bit longer than originally intended (the current lockdown kind of slowed things down) but I’m happy to say that the new book is available for preorder now. It’s been retitled and significantly reworked, in the new book we have thirty four chapters and lots of examples in Zip Archives to play with. We’ve really tried to create the Consultant’s Guide to Oracle Intelligent Advisor.

It has been reviewed and many chapters rewritten to be bang up-to-date for Intelligent Advisor latest release 20B. Of course it covers all the things a new starter needs to know, and should be a useful reference to anyone working with Intelligent Advisor. We even fixed all the URLs to match the new standards of Oracle documentation (as I am sure you have noticed, Intelligent Advisor is now in the URLs).

This kind of book of course can only be possible when so many people help out – the Oracle team have been absolutely fantastic, as always, and provided lots of ideas and help. And the readers of this website have also provided so many things for the book, the community really stepped up.

In the next 10 days or so, we will also be releasing the complete set of videos (there are about another fifteen or so to finish in the studio) and they will be available as a package with the book. I’ll let you know as soon as that is done.

For the time being however, you can read all about the Consultant’s Guide to Oracle Intelligent Advisor over on P8 Tech (the Publisher’s Website). The book will be the OPA Hub Shop as well.

Article Survey : The OPA Hub Website

Article Survey : The OPA Hub Website

Article Survey : The OPA Hub Website

OPA Hub Logo for Article Survey 2018Here at the OPA Hub Website, we want to provide articles that are of benefit to our readers. As such we would like to better understand what articles are of most interest. Although we have data from analytics providers like Google Analytics and Facebook to name only two, it is always in our opinion simpler and more effective to ask questions directly to our audience. So this is the justification for asking you to spend just a few moments filling out our Article Survey.

If there are items that are not visible in the list proposed, we would encourage you to add comments at the bottom of the Article Survey using the Comment feature, as normal.

Coming Up : New Content

Whilst on the subject of what you would like to see in the future we can already reveal what is coming up in the next quarter, aside from the usual content:

  1. A report from any Oracle Policy Automation sessions in Oracle OpenWorld 2018
  2. A series about the mysterious RuleScript
  3. A look at another Example Project : the Travel Compensation Project and how it works
  4. Getting Started with Oracle Policy Automation Book Edition 4 : in the works already

Coming Up : Training Available

We will be looking to run another session of our Workshop in the final quarter of the year. So while you are doing the Article Survey, feel free to comment / add information about a location or team that needs a training event (anywhere in the World). The standard content is shown here.

Article Survey : Q4 2018

So without further ado, here is the survey. Thank you very much for taking the time to participate in the survey. All the results will simply be used to better orient our writing and creative energy, and we will not contact you unless you specifically request it in the comments.

Logo by Southpaw Projects LLC