Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Changing Default views of Compound Layout

Posted by Venkatakrishnan J on December 24, 2007

I got another question from a customer yesterday with regard to changing the default views of Compound Layout in Answers. So, basically if you go to answers and create a new report, you would find that by default Compound layout would have have 2 views included i.e Table and Title views as shown below

      

But what the customer basically wanted was to include a filter and table view by default (i.e filter view instead of title view). The method is given in the bookshelf. But unfortunately it does not work as specified due to a documentation bug. In order to make this work, go to {OracleBI}\web\msgdb\messages folder and you would find a file called answerstemplates.xml. Copy this file to {OracleBIData}\web\msgdb\customMessages. If you dont have this folder then create it. Now edit this file and search for kuiCriteriaDefaultViewElements. This is the message that handles all the default values possible in Answers. Now add the the following tags to this message after the HTML tags,

<view signature=”compoundView” >
<cv signature=”tableView” />
<cv signature=”filtersView” />
</view>

      

Once this is done restart your presentation services. Now you would see that by default you would have got Table and Filter views within your compound layout.

      

If you notice, the methodology above is same as the one that we followed for enabling the sorting of reports in Dashboards here. So, use this methodology when you want to modify any custom XML messages.

P.S:   Happy holidays and Merry Christmas everyone!!!

Advertisements

2 Responses to “Oracle BI EE 10.1.3.3/2 – Changing Default views of Compound Layout”

  1. Manish Singh said

    Everything i have worked same as you all have written but still not working.
    Can you tell me the what all things i should check.
    Neither column sorting is working nor this.
    Is this any environment problem?
    I have restarted the Server and Presentation service.

  2. Deb said

    Hi,

    I have modified the Compound Layout default view in OBI, but would like to add a staticchart as a default as well. Is this possible? It appears I need to substantiate it somehow after it processes and before display. I am getting the following error: Assertion failure: pTemplateIDAttr != 0 at line 518 of ./project/webcharts/xmlcompiler.cpp. However, if I select the Chart from the dropdown and go back to the compound layout all is correct.

    Please advise.
    Thanks,
    Deb

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: