Information Builders Case Studies Complex Reporting for Link Market Services

Edit This Case Study Record

	Complex Reporting for Link Market Services Information Builders

Complex Reporting for Link Market Services

Information Builders

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Finance & Insurance
Applicable Functions	Business Operation
Use Cases	Predictive Quality Analytics Real-Time Location System (RTLS)
Services	Data Science Services System Integration
Challenge	Link Market Services (LMS) faced the challenge of producing over 4,000 complex internal and client ad hoc and management reports every day from two Oracle transaction databases containing up to 1.8 billion rows of data. The company needed a solution that could deliver rapidly, as they wanted to be independent from a competitor as soon as possible. The solution had to be able to connect to a wide variety of data sources and consolidate information into a single report. The company also required a solution that could produce reports as soon as a client comes on board, and deliver these reports instantly. Read More
About Customer	Link Market Services is a premium service provider of share registry, investor relations, and analytics services to listed and unlisted companies in Australia, New Zealand, South Africa, and Papua New Guinea. The company has more than 350 full-time staff and manages the registers of more than 1,000 listed securities. With over eight million holder records under management, LMS maintains a commitment to clients and its goal to provide a quality service. The company's services extend to IPOs, investor relations, analytics, annual general meetings, and company secretarial services, as well as the management of employee share schemes for companies such as Telstra, Qantas, Coca-Cola, and Brambles. Read More
Solution	LMS leveraged WebFOCUS to provide enterprise-wide process-driven BI solutions that integrate the core COBOL/Java/Oracle application to supply pervasive reporting. WebFOCUS was purchased to address the complex reporting requirements across the entire business. This includes the provision of all client reporting from OSCAR, together with general ad hoc and management reporting. As the core reporting engine, WebFOCUS links to the production Oracle environment from COBOL and Java. The solution generates up to 4,000 reports every night. WebFOCUS provides internal specialists with the ability to meet ad hoc reporting requirements effortlessly. The solution also enables LMS to manage and report on many other processes it handles for its clients including register maintenance, dividend processing, check distribution, management of dividend redistribution plans, bank reconciliation for treasury teams, and operational risk management. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Finance & Insurance

Applicable Functions

Business Operation

Use Cases

Predictive Quality Analytics

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

Challenge

Link Market Services (LMS) faced the challenge of producing over 4,000 complex internal and client ad hoc and management reports every day from two Oracle transaction databases containing up to 1.8 billion rows of data. The company needed a solution that could deliver rapidly, as they wanted to be independent from a competitor as soon as possible. The solution had to be able to connect to a wide variety of data sources and consolidate information into a single report. The company also required a solution that could produce reports as soon as a client comes on board, and deliver these reports instantly.

About Customer

Link Market Services is a premium service provider of share registry, investor relations, and analytics services to listed and unlisted companies in Australia, New Zealand, South Africa, and Papua New Guinea. The company has more than 350 full-time staff and manages the registers of more than 1,000 listed securities. With over eight million holder records under management, LMS maintains a commitment to clients and its goal to provide a quality service. The company's services extend to IPOs, investor relations, analytics, annual general meetings, and company secretarial services, as well as the management of employee share schemes for companies such as Telstra, Qantas, Coca-Cola, and Brambles.

Solution

LMS leveraged WebFOCUS to provide enterprise-wide process-driven BI solutions that integrate the core COBOL/Java/Oracle application to supply pervasive reporting. WebFOCUS was purchased to address the complex reporting requirements across the entire business. This includes the provision of all client reporting from OSCAR, together with general ad hoc and management reporting. As the core reporting engine, WebFOCUS links to the production Oracle environment from COBOL and Java. The solution generates up to 4,000 reports every night. WebFOCUS provides internal specialists with the ability to meet ad hoc reporting requirements effortlessly. The solution also enables LMS to manage and report on many other processes it handles for its clients including register maintenance, dividend processing, check distribution, management of dividend redistribution plans, bank reconciliation for treasury teams, and operational risk management.

Impact #1	Fast delivery of over 30,000 monthly reports and up-to-date information on trading activity and investor details.
Impact #2	WebFOCUS manages the production of more than 30,000 reports from three separate Oracle systems every month.
Impact #3	WebFOCUS provides internal specialists with the ability to meet ad hoc reporting requirements effortlessly.

Impact #1

Fast delivery of over 30,000 monthly reports and up-to-date information on trading activity and investor details.

Impact #2

WebFOCUS manages the production of more than 30,000 reports from three separate Oracle systems every month.

Impact #3

WebFOCUS provides internal specialists with the ability to meet ad hoc reporting requirements effortlessly.

Benefit #1	WebFOCUS generates up to 4,000 reports every night.
Benefit #2	WebFOCUS manages the production of more than 30,000 reports from three separate Oracle systems every month.

Benefit #1

WebFOCUS generates up to 4,000 reports every night.

Benefit #2

WebFOCUS manages the production of more than 30,000 reports from three separate Oracle systems every month.

Download PDF Version

Overview

Complex Reporting for Link Market Services

Operational Impact

Quantitative Benefit