How to… Create Custom Gantt Chart Applets in Open UI

Posted by Amardeep Parmar on Thu, Apr 20, 2017 @ 4:50 PM

Calendars1png

Gantt chart applets are used in several places across Siebel  and come in the form of anything from calendars and resource schedulers to dispatch boards. The calendar in particular is used by many as an intuitive, graphical representation of events to come, saving users time and minimising mistakes.

Businesses that have begun using Siebel Open UI will be aware that Gantt Chart Applets have significantly changed from their High Interactivity (HI) predecessors. Developers will see two applets, one for use in HI and one for use in Open UI, with completely different configuration. Unfortunately, if you’re upgrading to Open UI, your Siebel system won’t know about any custom-built pre-upgrade Gantt Chart applets and an Open UI version won’t be created. This can be frustrating for businesses using custom Gantt Chart applets for important functions. Without the right understanding of how to customise these pre-upgrade applets, development can be that extra bit lengthier and more complex.

In this blog post, I’ll look at a quick, effective way to replicate customised Gantt Chart applets in Open UI and will illustrate with examples taken from my very own experience.

Strategy: Get Cloning

Unfortunately, cloning and converting the custom HI Gantt Chart applet to make a fully functional Open UI version is not straightforward. There is very little overlap with the user properties used to control the layout, thus the developer would need to create all of the required user properties. We can clone a vanilla Open UI Gantt Chart applet as a base for customisations to save time. The choice of the base is very important in order to make the process as seamless as possible.

Let’s take a look at an example

Example Case: eEvents Session Gantt Charts

For the purpose of this blog, I will be using ‘eEvents Session Gantt Chart Applet OUI’ and ‘eEvents Session Gantt Chart Applet’ as examples. In the Siebel application, this is displayed under Events > Sessions > Session Timeline. This applet is an example of a Gantt Chart resource scheduler. You may notice from Figure 1 that this applet is empty!

GantFieldsHiddenFig. 1: Events Session Timeline default if not in Siebel Marketing Enterprise

Unlike the HI applet, the Open UI web template item fields only show in the object manager ‘Siebel Marketing Enterprise’. To view the applet in when running other object managers, remove the expressions seen in Figure 2 on the web template items.

GanttExpressionFig. 2: Remove the ‘Expression’ from the Gantt Chart fields

You will now see a fully-fledged applet, as depicted in Figure 3. In Tools, search for both of these applets and use the inbuilt compare tool. You will quickly notice that the user props that control the functionality in HI and Open UI Gantt Chart applets are completely different!

GanttOUIFig. 3: Default Event Session Timeline

Initial Behaviour

In Figure 4, you’ll see that I cloned the HI applet into a new view called ‘Gantt Demo’. When this view is loaded, the applet is empty as it cannot be rendered. This is the exact behaviour a client would experience on a custom Gantt Chart applet after moving to Open UI for the first time. As we can see in Figure 4, this view is useless for end users!

GanttHIFig. 4: HI Gantt Demo in Open UI

From this base, we can now clone the Open UI version of the applet and change some fundamental settings to ensure the right applet is shown at the right time. In the view web template item, ensure that the Open UI version of the applet is listed rather than the HI version. When the application is reloaded as Open UI enabled, you’ll see the Open UI applet as expected in Figure 5.

GanttDemoFig. 5: OUI Gantt Demo in Open UI

Customising the Resource Pane

Now, we can explore some of the key customisations you can make to user properties to improve its appearance. By default, one column will be displayed to the left of the timeline. In Open UI Gantt Chart terms, this is known as ‘Pane 0 Col 0′ within the applet user properties. There are five core properties per pane that require setting up. The format for the value is the type of property followed by the value this property should take, separated by a comma. I have listed the standard column attributes below with their corresponding first half of the value.

User property Value (first half) Value meaning
Pane 0 Col 0 NM Display Name
Pane 0 Col 0 Attr 1 FLD Field to display
Pane 0 Col 0 Attr 2 IDD Drilldown name
Pane 0 Col 0 Attr 3 DDFLD Drilldown field
Pane 0 Col 0 Attr 4 IDD Drilldown name

By changing these user properties, we can easily change what is displayed here. For example, in Figure 6, the first column has been changed to ‘Status’ from ‘Name’.

GanttColumnChange

Fig. 6: OUI Gantt Demo with Status as main resource column

Customising Hidden Columns

Sometimes we might want to show more information per record without needing to drill down. The resource pane can be extended to show these extra columns as seen in Figure 7. We can add further user properties in the same structure as ‘Pane 0′ to add further columns. To remove columns simply deactivate the user properties related to that column. The example in Figure 8 has removed the three other columns that were there by default.

GanttShowColumns

 Fig. 7: OUI Gantt Demo showing all resource columns

GanttRemoveColumnsFig. 8: OUI Gantt Demo with extra resource columns removed

Filtering Fields

The binoculars icon displays an additional pane, the filter pane shown in Figure 9. This pane is not controlled by user properties and instead works in the more traditional web template. To change the fields available in the filter , simply add or re-position the web template items just like any other applet. A simple example, shown in Figure 10, demonstrates how easy it is to remove fields which aren’t required from the filter pane.

GanttBaseFilterFig. 9: OUI Gantt Demo Filter Pane

GanttFilterChangedFig. 10: OUI Gantt Chart Filter Pane customised

Pick and Mix: Combining Open UI Enhancements

There are many more features within the Tools configuration view to alter the applets but this is further enhanced by the use of CSS and JavaScript. For this reason, it’s possible to  completely transform the look and feel of the applet to fit a particular theme or company brand in a few short minutes. Figure 1, for example, draws on Boxfusion Consulting brand colours and demonstrates an amendment to spacing between buttons for greater clarity.

GantBFThemeFig. 11: OUI Gantt Chart customised with CSS

Conclusion

As mentioned, Gantt chart applets are very useful in Siebel for displaying time-related activities visually, and one of the great advantages that Siebel has over many other applications is flexibility when displaying complex information. Many of our customers have used custom Gantt Chart applets in HI and enabling them to use the same functionality in Open UI has been an important requirement for users. Why is it so important? Even the most modest of customisations, such as those to colours, field labels and filters, can significantly improve task flow for the users, and can provide businesses with further opportunity to simplify processes, improve user experience and really make the most of their investment in Siebel.

More information

Boxfusion Consulting are an Oracle Platinum Partner and recognised by Oracle as specialised in the implementation and development of Oracle Siebel CRM. We deliver tangible business benefits for our customers through optimising their Siebel systems, with a key focus on optimised user experience (UX). To achieve this, we provide the complete set of development, design and support services for Siebel CRM and Siebel Open UI.

If you would like to hear more about how you can leverage Oracle Siebel CRM to deliver business benefits that meet your expectations and those of your user community, or you would like to know how Boxfusion can help you gain more intelligence from your data, give us a call on +44 203 283 4315 or contact us here.

Siebel Platinum Specialization

0 comments

Leave new comments

  • (will not be published)

Tags

2014 2015 A/B Testing abcs Active Directory Active X ActiveX ADM Adoption ADSI Agent Desktop Analysis Analytics Apache Ant API Applet application builder cloud service ATG Aurora theme Automated Tasks automotive best practice BI BI Apps BI Cloud Service BICS Big Data Big Machines BI Publisher BI Publisher Reports BI Roadmap Brower-based UI Browser UI Business Application Consultants Business Intelligence Campaign Careers Chat chatbot Cloud Cloud CX Cloud Marketplace cloud migration Cloud Services Co-browse Collaboration COM communications consumer goods CPQ CRM CSS Current Vacancies Customer Experience Customer Portal Customisation Custom Object Support CX CX Cloud CX Summit DAC Daily Organiser Daily Planner Data Analysis data model data visualisation Data Warehousing Day Planner digital transformation Eloqua engagement cloud ETL EXADATA Experience routing Facebook financial services FUSE Fusion Fusion CRM G-Cloud gamification Gartner Gmail Google Drive Google Maps API Graduate Graduates higher education high tech html HTML5 IaaS ICS ID Graph IE8 iFrame Incentive Compensation Incident Mapping widget industry Informatica innovation pack Innovation Pack 2015 Innovation Pack 2016 integration integration cloud service Intergration iot IP 15 IP2013 IP2014 IP2015 ip2016 iPaaS Java javascript JConsole Job Role Functionality journey mapping journey to cloud jQuery Judith Sim Knowledge Knowledge base Larry Ellison LDAP Lead Conversion Mapping life sciences Linux Local XE Machine Learning Macros manufacturing Marketing Marketing Cloud May Release 2015 MBeans mcs messenger migration mobile Mobile application Mobile BI mobile cloud service Mobile Compatibility OBI OBIA OBIEE OBIEE 12c ODI on premise OOTB oow OPA Open UI Open UI pathway Open UI Theme Open UI Training Open World OpenWorld OpenWorld 2012 OpenWorld 2013 OpenWorld 2014 OpenWorld 2015 openworld 2016 OPN Opportunity Assessment Oracle Oracle 12c Oracle BI Oracle BI Cloud Services Oracle Cloud oracle commerce Oracle CPQ Cloud Oracle CRM Oracle CX Cloud Oracle Data Visualization Cloud Service Oracle Knowledge Oracle Marketing Cloud Oracle Modern Business Summit Oracle OpenWorld Oracle Partner Network Oracle PartnerNetwork Specialization for Oracle Sales Cloud Oracle Sales Cloud Oracle Service Cloud Oracle Siebel oracle social cloud Oracle Social Network Oracle Transactional Business Inteliigence Oracle Transactional Business Intelligence Oracle Visual Analyzer OSC OSN OTBI Outlook integration PaaS partner relationship management Performance Personalised Directions widget PHP Php upgrade planning tool Plug-in Wrappers POC Portlets prm Proactive proactive cx Recruiting Recruitment Release Release 9 Release 11.1.1.9 Renne James Reporting tool REST RightNow RightNow CX Roadmap SaaS Sales Cloud Salesforce salesforce automation Sales lightbox SAML Self service Service Cloud Service Cloud February 2015 Release Service Cloud Roadmap sfa Siebel siebel 8.1.1.11 Siebel blog siebel CRM Siebel Open UI Siebel Portlets Siebel Roadmap Siebel upgrade siebel ux Simplified UI SOA soap social Social Monitor Social Relationship Management Specialized Specialized Status SRM SSO Syndicated Widgets tco technical consultancy technical experts Testing third party cookie Time Management UI UI Flow UKOUG UNIX upgrade Usability User-facing prompts user experience user interface UX UX Metrics vertical video chat Virtual Assistant visualisation web customer service WebLogic Web Service Web Services wechat whatsapp Widgets WLST WSDL XML XSLT