Business Intelligence – Oracle

Oracle BI EE – Help URL in Title View

Posted by Venkatakrishnan J on January 22, 2008

I had an user today emailing me about the non-working of Help URLs in Title Views. I thought i would take a look and the results were pretty strange. First to give you a background, Help URLs are those URLs to specifc documents that an end user can refer to while looking at a report. They occur as Question Marks on the top of a title view. When one clicks on the question mark it would take you to the document specified in the help URL. Now lets start with entering some simple URL like in the Help URL text area and see what happens.


Well, in fact nothing happens. Then lets try entering just fmap: in the Help URL and see what happens. Now we get the “?” in the preview. But if you hover over this question mark you would notice that the URL would be something like this http://localhost:9704/analytics/Missing_”. Very strange. So far, i am not sure why the Missing_ is appended to this. Maybe because of OC4J.



I confirmed this is the same behaviour even in and Now, the question is how do we get this to work. In order to make this work, go to {OracleBI}\oc4j_bi\j2ee\home\applications\analytics\analytics and create a folder called Missing_.


Once this is done copy all your html help documents into this folder. For example, lets copy a html document AboutPrompts.html from {OracleBI}\oc4j_bi\j2ee\home\applications\analytics\analytics\olh\l_en to {OracleBI}\oc4j_bi\j2ee\home\applications\analytics\analytics\Missing_. Now restart OC4J. Enter fmap:\AboutPrompts.htm in the Help URL text area. Now you can see that you would be able to access this html page directly by clicking on the Question Mark. So, all you need to do is copy and paste all the necessary documents to {OracleBI}\oc4j_bi\j2ee\home\applications\analytics\analytics\Missing_ and restart OC4J.



13 Responses to “Oracle BI EE – Help URL in Title View”

  1. Adrian ward said

    Another wierd thing I have experienced is with Oracle App Server and Styles. When you install OBIEE on the app server it includes the analytics web folders inside the web server instance. Here you can add your new styles and edit the filemap xml. However, sometimes OBIEE looks in the original stand alone folders (Data\web\res) for the styles. To get around this we are copying the customisation to both locations. Any thoughts why it sometimes has issues??

  2. Venkatakrishnan J said


    Generally, i have seen that anything related to skins/styles have to be modified at two locations. One is in OC4J/App Server and the other is in {OracleBI} and {OracleBIData} seems to be a dummy for styles. Documentation needs a major revamp.


  3. Saraswathi said

    Hi Venkat,

    Thanks for your help.

    But in, no matter whether the files are stored in the presentation server ,you can place the URL say in the help URL text box and you get to see ‘?’ link and when you click on that it directs you to google page.

    I am not able to figure out through which file in the server we are able to achieve this so that we can go about doing the same in

    Please let me know if you get to know anything in this regard.

    Thanks and Regards,

  4. deepak said

    can we include *.chm files

  5. Kurt Wolff said

    Write more about fmap:
    I also used the Missing_ folder to store images used in conditional formatting.

  6. Kaushik said

    This Help icon(“?”) is displayed at report runtime. Can this also be displayed along with the Report Name, in the left pane of the Answers page while loading the page?

  7. Soumya said

    Hi Venkat,

    I am trying to mimic this in my environement where i do not hav OC4J and i run an IIS with Apache. i am a little confused as to where should i place my help files for OBIEE to understand.
    how does OBIEE undrstand the link to these files?
    Could you please clarify..


  8. Bruno said


    Same problem here… Were you able to find a solution instead of creating the “Missing_” directory?


  9. Sarosh said

    We are running IIS. To find the folder in which to create the Missing_ folder, open IIS Manager and right click on Default Web Site\analytics and click on Properties. Check the Virtual Directory logical path for this web site folder (for example, D:\OracleBI\web\app. Create the Missing_ folder in this and copy your html help files in this folder. For the Title View Help URL, enter fmap:\ – for example, fmap:\HelpSalesReport.htm.



  10. Bruce said

    I find that the help files need to be located in two locations:

    they have to live here in order for Answers to work

    they have to live here in order for Dashboards to work

  11. Jason said

    I just added /../ to make the path go back to root before continuing. so something like….

    “fmap:/../location/file.html” gets rid of the Missing_

  12. haroun said

    Thanks Jason. That’s solved this really annoying missing issue.

  13. Mahesh said

    Hi venkat,we are using Help URL’s in Title which is coming properly.But would like to know if we want to display “translated” htlm file depends on the country user logs in.How can we achieve that?Means when a English user logis in the Help htm file display the details in english.We have some Europen users who want to see the Help files in their local language.But I guess we can specify one fmap:*****.htm in the Help URL which will show only English always.We were using a separate link previouslly by using static text which uses repositiry variable and shows the htm file based on users language.Can you advice me if there is anyway to display help files in local langauges.Each Europen nation has provided the translated file but we have to take this dynamically.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: