Report Writer is an important technology for data extraction, presentation and manipulation of the Avaloq Banking System. It is used in almost any parameterisation/customisation area and influences the users experience to a big extent.
With the knowledge of the initial training (Fundamentals of Avaloq Customisation (ACP) parameterisers are able to develop basic reports. However advanced topics and latest developments in this area are an important puzzle piece for parameterisation specialists to deliver good results.
In practice, one of the main reasons for end-of-day processing not finishing on time are poorly performing reports. Often due to expensively built work-arounds due to the lack of knowledge regarding Report Writer features and disregarding usability criteria that lead to low user satisfaction. These are only some examples that show how important it is, that the parameterisation specialist masters this technology and is conscious about performance and usability topics.
At the end of the course, the parameteriser will have a better understanding of the report writer engine, its possibilities, shortcomings and strengths in order to produce more robust and flexibleand high-performance customisation of the Avaloq software.
Upon successful completion of this course every participant will:
thoroughly comprehend the concept of the Report Writer Engine
take advantage of the functionality offered by the task framework
group and sort in reports by almost any criteria required
master aggregation functions of a report datamart
be able to apply the vector concept
create lean and performing reports
bring various layout features offered by Report Writer into action
Avaloq Parameterisation specialists who specify or develop reports basic reports.
Before participating in this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
report writer layers of the report engine
interactions between the report writer layers
Task Definition and Task Templates
the importance of choosing the right task definition
important task definitions in connection with business requirements
Grouping and Sorting
group and sort reports by almost any criteria required
master sorting functionality provided for flat reports
Aggregation and Consolidation
apply aggregation and assignment functions offered by Avaloq
take advantage of the resolution sequence of fields in the datamart
apply the latest layout functionality
understand the concept and limitations of extended reports
execute reports from Avaloq script
point out report specific performance traps
Avaloq Certified Specialist
This course is part of the specialisation in the area of competence