Displaying Charts and Graphs in Enquiries
TEMENOS EDUCATION CENTRE
NOTICE
These training materials are the copyrighted work of Temenos Headquarters SA and other companies in the TEMENOS group of companies
(The Copyright Owner). The training materials contain protected logos, graphics and images. Use of the training materials is restricted solely for
use by licensed end users, partners and employees. Any un-licensed reproduction by any means, redistribution, editing, transformation,
publishing, distribution, or public demonstration of the training materials whether for commercial or personal gain is expressly prohibited by law,
and may result in severe civil and criminal penalties. Violators will be prosecuted to the maximum extent possible. Such training materials shall
not be represented, extracted into or included in part, or in whole, as part of any other training documentation without the express permission of
the Copyright Owner, which must given in writing by an authorised agent of the Copyright Owner to be valid. Where such permission is given a
clear and prominent notice must be displayed on any and all documentation accrediting the Copyright Owner with having copyright over the
materials. End-user licenses will in no event contain permissions extending the use of these training materials to third parties for commercial
training purposes.
Without limiting the foregoing, copying or reproduction of the training materials in part or in whole to any other sever or location for further
reproduction or redistribution is expressly prohibited, unless such reproduction is expressly licensed by the Copyright Owner.
Copyright © 2010 Temenos Headquarters SA
Conventions Used
Applications in T24 are represented in BOLD UPPERCASE letters
The fields in the applications are mentioned in UPPERCASE letters
This learning unit is workshop based
Slide 2
Objectives
After completing this course you will be able to -
Analyse the need for statistical representation of data
Create enquiries that can display data in the form of Pie Charts, Bar
Charts and Progress Bars
Explain the various types of graphs in T24
Create enquiries that can display data using graphs
Slide 3
Displaying Charts / Graphs
Enquiries can display output in various formats
Bar Charts
Pie Charts
Progress Bar
Graphs in T24 can be displayed in 2 formats –
SVGObjects(SGViewer must be installed to view images / graphs etc)
PNGImages
The format of the graph objects should be configured in
browserParameters.xml
Slide 4
Task 1 – Bar Chart
Create an Enquiry based on the LD.LOANS.AND.DEPOSITS
application and display the following fields
Id
Amount (as a bar chart)
Slide 5
Create the Enquiry
Slide 6
Create the Enquiry
Slide 7
Output
Slide 8
Workshop 1
Create an Enquiry for the CURRENCY application
Fields to be part of your enquiry are - @ID, NUMERIC.CCY.CODE,
CURRENCY.MARKET,CCY.NAME and SELL.RATE
The value in the field CCY.NAME should be displayed as italicized text
Display the value in the column SELL.RATE in the form of a bar chart
Slide 9
Task 2 – Pie Chart
Create an enquiry on the LD.LOANS.AND.DEPOSITS application and
display the values of AMOUNT in a pie chart format
Slide 10
Create the Enquiry
Slide 11
Create the Enquiry
Slide 12
Output
Option to view as a
Bar Chart
Pie Label
Slide 13
Workshop - 2
Create an Enquiry based on the LD.LOANS.AND.DEPOSITS
application
Display the following fields – CUSTOMER.ID and INTEREST.RATE
In the last column of the enquiry report display a pie chart for the field
INTEREST.RATE
For the pie chart the customer MNEMONIC will be the label
Slide 14
Task 3 – EB.ENQUIRY.GRAPH
Create an Enquiry based on the LD.LOANS.AND.DEPOSITS
application . Display the following fields - @ID,CUSTOMER.ID,
CURRENCY, AMOUNT. Display the value of AMOUNT as a BAR
graph.
Slide 15
Create the Enquiry
Slide 16
Create the Enquiry
Slide 17
Output
Slide 18
Line Ordinal Graph & Pie Chart Graph
Slide 19
Workshop - 3
Create an Enquiry based on the CURRENCY application
Display the following fields - @ID , SELL.RATE , and BUY.RATE
The data of your enquiry will be represented in the form of a bar graph
Display the graph only for currencies with BUY.RATE less than 5
Label for the graph – CCY Vs BUY.RATE
Mention the scaling factor as 10 units for the X-axis
The legend source for the graph will be the value of BUY.RATE
Slide 20
Bar Line Ordinal Graph
Slide 21
Workshop 4
Create an Enquiry based on the ENQUIRY application with the
following fields - @ID, BUY.RATE and SELL.RATE
The enquiry report should be displayed as bar line ordinal graph
Data for X-axis - BUY.RATE
Data for Y-axis - SELL.RATE
Data for Z-axis - @ID
Label for the Graph – Bar Line Ordinal Graph
The value from the field BUY.RATE is displayed as legend
Slide 22
Quiz
The application EB.ENQUIRY.GRAPH is used to represent data in the
form of graphs – True / False
To get a bar chart display for the data in a given enquiry field,
FIELD.DISP.TYPE is set to CHART - True / False
The enquiry output is displayed without grids if the ATTRIBUTES field is
set to PAGE - True / False
Id to the application EB.ENQUIRY.GRAPH can be any alpha numeric text
– True / False
Slide 23
Summary
An Enquiry is a ‘SELECT’ executed in order to fetch data from T24
SVGViewer must be installed to view Bar Charts, Pie Charts, Progress
Bar etc
The values that can be set in field FIELD.DISP.TYPE to display Enquiry
output in various ways are:
BAR
PIELABEL
PIE
PROBRESSBAR
EB.ENQUIRY.GRAPH – provides four types of graphs namely,
BAR.ORDINAL,PIE.CHART, LINE.ORDINAL and BAR.LINE.ORDINAL.
Slide 24
A Review - More on Enquiries In T24
In this learning unit you have learnt drilldowns, workflows, fast path
enquiries and graphs in T24.
You will now be able to,
Analyse the need for statistical representation of data
Create enquiries that can display data in the form of Pie Charts, Bar
Charts and Progress Bars
Explain the various types of graphs in T24
Create enquiries that can display data using graphs
Slide 25
Thank You
TEMENOS EDUCATION CENTRE
NOTICE
These training materials are the copyrighted work of Temenos Headquarters SA and other companies in the TEMENOS group of companies
(The Copyright Owner). The training materials contain protected logos, graphics and images. Use of the training materials is restricted solely for
use by licensed end users, partners and employees. Any un-licensed reproduction by any means, redistribution, editing, transformation,
publishing, distribution, or public demonstration of the training materials whether for commercial or personal gain is expressly prohibited by law,
and may result in severe civil and criminal penalties. Violators will be prosecuted to the maximum extent possible. Such training materials shall
not be represented, extracted into or included in part, or in whole, as part of any other training documentation without the express permission of
the Copyright Owner, which must given in writing by an authorised agent of the Copyright Owner to be valid. Where such permission is given a
clear and prominent notice must be displayed on any and all documentation accrediting the Copyright Owner with having copyright over the
materials. End-user licenses will in no event contain permissions extending the use of these training materials to third parties for commercial
training purposes.
Without limiting the foregoing, copying or reproduction of the training materials in part or in whole to any other sever or location for further
reproduction or redistribution is expressly prohibited, unless such reproduction is expressly licensed by the Copyright Owner.
Copyright © 2010 Temenos Headquarters SA
