Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Sorting of Reports in Dashboards

Posted by Venkatakrishnan J on November 28, 2007

I just picked up an old unanswered question in the forums to blog about today. The question is “How do we enable sorting of reports within Dashboards”?. We will see two ways of achieving this. One approach will enable sorting on a report to report basis. The other approach will make it default across all the reports in all the dashboards. In order to enable sorting one by one for all the reports, open the reports for which you want to enable the sorting in dashboards for and go the table properties. There just enable the “Sorting in Dashboards” check box and save the report. Now you would see that the report has sorting enabled within the dashboard.

      

      

In the second approach our aim is to make the sorting enabled(default) for all the reports in the dashboards. Setting this one by one for all the reports would be a bit cumbersome. In order to do avoid this we need to modify a custom XML message. Go to {OracleBI}/web/msgdb/messages and you would find a file called answerstemplates.xml.

      

Copy this XML file to {OracleBIData}/web/msgdb/customMessages. If you do not have the customMessages directory, create it.

      

Now, edit this copied XML file and search for the following messages

<WebMessage name=”kuiCriteriaDefaultViewElements” translate=”no”><HTML/></WebMessage>

Change the above message to

<WebMessage name=”kuiCriteriaDefaultViewElements” translate=”no”><HTML>
<view signature=”tableView” sortable=”true” />
</HTML></WebMessage>

As you see we are basically overriding the webmessage which is responsible for the sorting. Now save the XML file and restart BI Server and the Presentation Services. Now if you log back into the dashboards you would find that the sorting would have been enabled for all the reports.

      

Advertisements

5 Responses to “Oracle BI EE 10.1.3.3/2 – Sorting of Reports in Dashboards”

  1. David Andersen said

    Does Oracle have any plans to make these sorts of config options available in the Admin screens rather than requiring an XML message change? The only way they could make it harder to do is if they required one to set bit flags and recompile the code.

  2. Venkatakrishnan J said

    You are right. But the problem with that is there are so many options it becomes tough to prioritize what has to be kept in the Admin screens.

  3. […] 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 […]

  4. Manish Singh said

    It’s Not working. 😦

  5. Manish Singh said

    Little more details!!
    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.

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: