Adding hints without Repository (RPD) change

Adding hints without Repository (RPD) change


Adding hints at the table level or join level is most common however requires a RPD change. This involves server restarts and downtimes.

Sometimes it may be necessary to use different hints in some specific answers based reports. And that needs a way to apply hints in OBIEE Answers level, here is how…


NB: These hints are always overridden by the repository hints, so in order to make these to work there shouldn’t be any hints in the repository atleast for the same tables.


1. Go to BI answers and start a new request


2. To add a report specific hint in the request, the first column in the request should have a function with the hint as shown here



As shown in the above diagram the evaluate function is used to create the hint in the database sql but with the table alias, to know the table alias – use the Query repository utility in the BI Admin tool

 


















So in this case the alias will be T69092.


It is very easy to understand if you know what evaluate function is actually used for in OBIEE, if not please take a look at one of the John’s article on it, in simple this function is used to execute database functions from Oracle BI.


For the convenience of others who reached this blog just to see how hints are applied in OBIEE Repository, I am giving that information below;


Adding hints at Table level:


A table level hint is actually passed as part of the database sql everytime an answer based report uses the table. For example, to add a table level hint, go to the table properties and enter the hint in the hint text box as shown here


 


















Adding hints at Join level:


Sometimes it may be required to have the hint only during a particular join between the tables and in this case a hint can be added at a join level. For e.g. Go to the join properties and enter the hint text

 

Popular posts from this blog

Image
If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below. If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below. Open Dev_Machine.rpd Administrator Administrator SetProperty "Connecti...
Read more

How To Unlock Bootloaders on your Xperia Arc S

UPDATE : Before you proceed, please visit  this link  to check if your phone’s boot loader can be unlocked or not? NOTE:  If the light above the USB port on your phone doesn’t turn blue when you connect your phone using the USB cable to your PC while holding the “MENU” button (on Xperia Arc. For Xperia Play – “SEARCH” button), then it means that you cannot connect to fastboot, and hence you cannot unlock the boot loader. Here’s a Step by Step guide (w/ video) on how to unlock bootloaders on your Xperia Arc, Play, Neo & Pro. [info]Although this guide is made using Xperia arc, I can assure that it would work perfectly with Xperia Play, Neo & Pro too. NOTE : Xperia Play users should press the “ Search ” button instead of “ Menu ” button in Step 8th of this tutorial.[/info] [warning]The methods and procedures discussed here are considered risky and you should not attempt if you don’t know completely what it is. If any damage occurs to you or your device, w...
Read more

Inherited Colour Vision Deficiency

Image
Red/green colour blindness is a common hereditary condition which means it is usually passed down from your parents. Colour blindness is usually passed from mother to son on the 23rd chromosome, which is the sex chromosome. Chromosomes are structures which contain genes – these contain the instructions for the development of cells, tissues and organs. If you are colour blind it means the instructions for the development of your cone cells are wrong and the cone cells might be missing, or less sensitive to light or it may be that the pathway from your cone cells to your brain has not developed correctly. The X chromosome is the sex chromosome: males have an X chromosome and a Y chromosome and females have two X chromosomes. For a male to be colour blind the faulty colour blindness gene only has to appear on his X chromosome. For a female to be colour blind it must be present on both of her X chromosomes. This is why red/green colour blindness is far more common in men than women. Bl...
Read more