Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Getting different view link shortcuts in the Criteria Tab

Posted by Venkatakrishnan J on January 29, 2008

Lets look at a nice customization feature that can be useful in quite a lot of situations. If you go the Criteria tab of any report you would see that you would basically have 4 different shortcuts for different views. For example, look at the screenshot below,

      

As you see above, there are 4 out of the box shortcuts to go directly to the Compound View, Table View, Pivot View and Chart View. But what if you need another shortcut to go directly to the Narrative View or the Filter view. Lets see how to go about achieving that today.

1.   Go to {OracleBI}\web\msgdb\messages. Copy the file answerstemplates.xml from here to {OracleBIData}\web\msgdb\customMessages (if you do not have this directory, create one). Open up the copied file in a text editor.

2.   Search for the XML message kuiAnswersCriteriaEditor. Now if you go through this XML message you can find that this XML message points to the various shortcuts that you saw in the 1st screenshot. For example, the following XML message within kuiAnswersCriteriaEditor shows the pivot view

      <sawm:if name=”privileges[‘View.pivotTableView’].EditView”>
<td class=”AnswersBarButtonCell”><sawm:messageRef name=”kuiAnswersBarImage”>
<sawm:setParam name=”buttonImage”><sawm:fileMap path=”Answers/abbPivot.gif”/></sawm:setParam>
<sawm:setParam name=”buttonTip”><sawm:messageRef name=”kmsgPivotViewDescription”/></sawm:setParam>
<sawm:setParam name=”buttonScript”>AnswersCriteriaEditor.onSelectViewType(‘<sawm:param name=”eid”/>’,’pivotTableView’)</sawm:setParam></sawm:messageRef>

Now lets add a similar message like this for Narrative view as shown below

      <sawm:if name=”privileges[‘View.narrativeView’].EditView”>
<td class=”AnswersBarButtonCell”><sawm:messageRef name=”kuiAnswersBarImage”>
<sawm:setParam name=”buttonImage”><sawm:fileMap path=”Answers/abbother.gif”/></sawm:setParam>
<sawm:setParam name=”buttonTip”><sawm:messageRef name=”kmsgNarrativeViewDescription”/></sawm:setParam>
<sawm:setParam name=”buttonScript”>AnswersCriteriaEditor.onSelectViewType(‘<sawm:param name=”eid”/>’,’narrativeView’)</sawm:setParam></sawm:messageRef>

So, your final kuiAnswersCriteriaEditor web message would look something like this. Once this is done restart your presentation services. Now you should see a shortcut extra for the narrative view.

      

      

Again, this goes to show you the customization capabilities of BI EE. As shown above you can add shortcuts to all the views that you need.

Advertisements

7 Responses to “Oracle BI EE 10.1.3.3/2 – Getting different view link shortcuts in the Criteria Tab”

  1. Esther said

    Hi Venkatakrishnan,

    I regularly read your posts on OBI EE… Your blog posts have been very helpful to me.

    Now, here’s a question for you… I am trying to do this dynamic filter on our fiscal period with character datatype. The values in this fiscal period column are of the format ‘YYYYMM’ with current calendar month (Jan 2008) displayed as 200807 (+6 months to the calendar month). I want to apply a filter in Answers that’s similar to:

    “Fiscal Period Nbr” BETWEEN TO_CHAR (ADD_MONTHS(SYSDATE, -7), ”YYYYMM”) AND TO_CHAR(ADD_MONTHS(SYSDATE, 5), ”YYYYMM”)’)

    Will you be able to throw some light on something like this (may be through another blogpost).

    Thanks a lot in advance!
    -Esther

  2. Venkatakrishnan J said

    @Esther – Can you explain a bit more on what problem you are facing?

  3. Ed said

    Hi Venkatakrishnan,

    I tried out this example, it’s a good insight into how the screens all hang together, thanks. I was wondering how easy it would be add a short cut to a url, such as a refence page on an intranet, I have had a go but not had much luck with isolating the other elements called from the answerstemplates.xml page, have you ever tried anything like this?

    Regards,
    Ed

  4. Ed said

    Hi Venkatakrishnan,

    I tried out this example, it’s a good insight into how the screens all hang together, thanks. I was wondering how easy it would be add a short cut to a url, such as a refence page on an intranet, I have had a go but not had much luck with isolating the other elements called from the answerstemplates.xml page, have you ever tried anything like this?

    Regards,
    Ed

  5. Venkatakrishnan J said

    Ed – Do you want custom URLs in the place of a narrative or a pivot view?

  6. Ed said

    That was where I had tried to do it, yes, but whenever I edited the answerstemplates.xml I got various errors about missing dividers and things, I was trying to add a hyperlink within one of the table cells. Thanks for your post today.
    Ed

  7. Suresh said

    Hi Venkat,
    I tried so many times in order to get the narrative view in the criteria tab.But I am unable to get that view in my criteria tab.I followed the procedure exactly given in this blog.I am using OBIEE 10.1.3.3.2 version.
    Can you help me out please?
    Thanks&Regards
    Suresh.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: