Achieving Digital Transformation with Oracle's Siebel CRM

OpenUI Responsive Charts

John Bedford
Director, Product Strategy

New OpenUI Responsive Charts

Improving customer experience continues to be the top priority and opportunity for organizations across the globe. To the same effect, there always has been a quest to improve business reporting and information consumption as effectively as possible. Walk into any executive meeting and you will find charts and graphs, used with the intent of representing reporting and decision making information in a meaningful way.

Prior to the Siebel CRM 18.8 Update, OpenUI charts were rendered using jqPlot. Though superior in many aspects, jqPlot based charts had some limitations. Users were not able to control the visibility through zoom-in / zoom-out. To change the look and feel, developers had to modify the behavior through Siebel Tools for each chart.

A new features in the Siebel CRM 18.8 Update are Responsive Charts, using the Data Driven Documents (D3) based charting engine. With this, Siebel CRM continues to provide pre-built industry based charts with enhanced user experience.

OpenUI Charts

Figure 1: Responsive Charts using D3


With Responsive Charts, customization is easy since they are backed up by HTML5 and CSS for the styling of charts. They are responsive across form factors and with zoom-in / zoom-out support which will be useful on many touchscreen devices.

Data aggregation

To improve user experience for more complex charts, we have improved the efficiency for aggregated data functions such as SUM, AVERAGE, and COUNT. Previously, these aggregation functions were done at the Business Component level (on the data already fetched from the database query). These functions are now modified to perform database-based aggregation, resulting in the rendering of large data volume aggregations within milliseconds.

The same search specification, as applied on the list applet, is used to fetch the aggregated data for the chart applet. Moreover, users can drilldown on charts which results in a new aggregation query to refresh the chart. Aggregations at database level for enhanced performance and handling large volume of data include aggregations based on:

  • Period (records aggregated based on Week, Month, Year)
  • Single / Multiple Attributes
  • Multi Value Fields (M:M relationships)
  • Group by value
  • Calculated Fields
  • Range values

Charts can also be built based on the data from external sources via Virtual Business Component (VBC).

A lot of our customers have expressed excitement about the new charting feature. They will continue to improve to enable our customers in delivering a great user experience with OpenUI.

Author credit: Nitin Misra, Principal Product Manager, Siebel CRM Product Management


Join the discussion

Comments ( 5 )
  • richard martinez Friday, September 28, 2018
    Hi John. I'm very excited about this feature. We have licensed the Siebel Clinical product hosted by Oracle. Can you speak to what out-of-the-box charts will be available when our instance is upgraded to 18.8 or later?

  • Mohmmedali Somji Thursday, November 15, 2018
    Are features mentioned in the article available now.
  • John Bedford Thursday, November 29, 2018

    The new Charts features are available in the 18.7 and 18.8 Updates, please refer to the Updates page on MOS:


  • Marc Verbeek Thursday, November 29, 2018
    @richard martinez

    Thank you for the question. There are no additional charts shipped out-of-the-box as part of this update. This enhancement will upgrade the existing charts to this new framework as well as allow you to create new charts that leverage the new features.
  • santhosh Monday, August 12, 2019
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.