10 ways to get the most out of substitution in Intelligent Advisor #5

After a brief hiatus with some other articles that were in the pipeline, we are back looking at the wonderful subject of substitutions in Oracle Intelligent Advisor. What is number five on our top ten ways to use them? Let’s find out!

#5 – Substitutions using Gender

This concept has been around for a long time in Oracle Policy Modeling and I am surprised and disappointed by how many people do not know it exists (and therefore spend a chunk of time messing with custom labels. I do understand that it does not fit every scenario however (as you will see in a later episode in this article series).

Create a text attribute, and call it something practical like the gender of the person. This assumes that you have an entity called the person that has an identifying attribute called the person and that you have set the following information on that attribute:

Gender-based substitution
Note that the Edit Attribute dialog gives you an example of the kind of formulation that you are trying to achieve. “The amount Bob has in his account”. So, to obtain gender substitution we need to create attributes using this possessive style:

I personally think that documentation is a bit weak here – it could make it clearer that the substitution based on gender needs this kind of double-barrelled possessive structure. Now we can add the various elements to the Screen.

Don’t forget to add a drop-down with a list of values. They should be Male and Female. Depressingly, there is no built-in defined option for non-binary so you have to build it yourself:

And now you can see your substitution in action in the Debugger. Notice how the label in the third attribute question text changes automatically as I change the gender in the previous attribute.


Join us in a couple of days for more substitution fun!

Richard Napier

Author: Richard Napier

After 8 years in case management and ERP software roles, Richard Napier joined Siebel Systems in 1999 and took up the role of managing the nascent Siebel University in Southern Europe. He subsequently was Director of Business Development and Education for InFact Group (now part of Business & Decisions) for 8 years. He now runs Intelligent Advisor IT Consulting OÜ. Owner of intelligent-advisor.com, he also is Co-Founder of the Siebel Hub.

One thought on “10 ways to get the most out of substitution in Intelligent Advisor #5

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Serving Customers Worldwide
Hide picture