Showing posts with label olap. Show all posts
Showing posts with label olap. Show all posts

Sunday, November 7, 2010

Addison Lee deploys SAP business intelligence platform - ComputerworldUK

Addison Lee, London's largest minicab service, is rolling out a new SAP business intelligence system to improve its operations.

Addison Lee will work with IT systems provider Maxima to implement the SAP BusinessObjects EDGE business intelligence platform. The system will provide account teams and sales management staff at Addison Lee with real time visibility of the company's fleet of 3,000 vehicles, and allow them to see the performance levels being achieved for its 10,000 corporate account customers.

Get the latest stories on law, regulation, compliance and patents in the Computerworld UK Law channel.

The system is aimed at helping improve core business processes, as well as providing access to self service tools, business intelligence dashboards and web analytics.

It will be implemented at Addison Lee's London headquarters, with the aim of providing executives and operational managers with role-based real-time dashboards. It will allow them to drill-down for further details, carry out root-cause analysis and generate daily information and alerts on specific operational performance issues.

Peter Ingram, Addison Lee IT Director, said, "Our business is growing rapidly so we needed an enterprise-class business intelligence solution."

Ingram said, "When Maxima introduced us to SAP BusinessObjects Edge we immediately saw that it would be possible for us to secure all the benefits of SAP BusinessObjects in a cost-effective package that was backed by Maxima's own specialist expertise."

As part of the deal Maxima will provide full consultancy, training and support services.

Earlier this month, SAP released a set of real time analytics products that are customised for use in various industry sectors and business functions. The products are based on technologies from the company's 2007 purchase of Business Objects.

They include new tools designed to let enterprises enable mobile access to business intelligence (BI) applications. The new products are customised for companies in the healthcare, consumer products, public sector, financial services, retail and telecommunication sectors.

They are designed to deliver real time analytics capabilities for line of business functions, such as finance, sales, marketing, planning, risk assessment and customer satisfaction.

Monday, November 1, 2010

Matter Management Reporting - A Business Objects Approach


Corporate legal Matter Management systems are implemented through multi-million dollar projects that frequently result in unpopular, underused tools that never provide the expected return on investment. One element, common to many such situations, is the limited utility of the data being captured. The data in the matter management system is either irrelevant or inaccessible to the interested parties. Integrated Matter Management reporting is the solution to this problem.

In the best case, future reporting needs have been considered and included as critical inputs in the design phase of the larger matter management project. In the worst case, reporting was left out of the design entirely, and end users and management are already angry and dissatisfied with what they perceive as a very expensive failure. Once this type of deficiency is identified, Matter Management specialists can correct the design and integrate the key reports into the system that will make it more relevant to day-to-day business and the reporting requirements mandated by management.

The right specialists will be fluent in matter management as well as management reporting and the underlying tools. These subject area experts can upgrade and enhance a successful matter management system, or salvage and improve one that is foundering. Specialty consultants are crucial to a successful matter management implementation because of their unique combination of experience, independence from vendor influence and accountability to the client organization that engages them. The same advantages make them most desirable resources during a project remediation. Skilled resources that rely on the good will of their paying client are highly motivated to comply with customer timelines and expectations.

A good matter management reporting implementation will be flexible, responsive, logical, and user-friendly. The tools most often employed to retrieve and display data from a matter management system are Business Objects (or Crystal Reports), Microsoft Access, Cognos, and Microstrategy. Most of these are Business Intelligence platforms (MS Access is not). Using these tools, a skilled designer creates a metadata layer that interprets complex data for use by end users and report writers (metadata means 'data about data').

In Business Objects, the metadata layer is called a "Universe". Sound universe design is the heart of a successful reporting effort. Poorly designed universes will result in several significant problems, including:


Inaccurate reports
Performance problems (with Reporting, the application and/or the database server)
User dissatisfaction (with usability, results, etc.)
Proper universe design will incorporate the following practices and features:
Custom universes and objects, built to address customer reporting needs.
Consistent, logical universe layout
Clear and friendly naming conventions.
Multiple universes, built around clusters of related data.
Logical, consistent points of interface between universes.
Efficient database joins
In a Business Objects universe design, multiple universes should be created, according to the complexity of the data and business processes involved. The separation of data into multiple universes improves the usability and performance of the reporting environment. Usability is enhanced as the reporting interface presents fewer choices, with more obvious correlations and interactions between fields, so that a report writer can create more accurate reports more quickly. Performance is enhanced as database communications are simplified and streamlined. A matter management reporting environment will use a Matter (Case) universe to anchor the rest of the data. A Finance universe contains everything about invoices and budgets. The Finance universe can be linked to Matters when a more complex report requires details from both universes. A Contacts universe presents all of the details in the "rolodex", encompassing all of the people and companies that are involved in any way with a legal matter in the system. Other universes will link to it whenever additional contact details are required. A Timekeeping universe will present timesheet data and have links to the Matters and Contacts universes. Other universes may be necessary, depending upon the business processes that are part a firm's Matter Management system. These may include an Intellectual Property universe, a Discovery universe, a Risk Management universe, and others.

Once the universes are in place, reports are created through the collaborative efforts of business experts, analysts and report writers. Specialty consultants are a superior resource during this step because they can fill the latter two roles, while conversing fluently with the business experts to maximize reporting results and minimize delivery time.

Summary
A strong reporting implementation is vital to the overall success of any Matter Management system, in many cases driving the benefits that provide the ROI for the entire project. Experienced specialists can contribute dramatically to the success of the effort. The reporting design should be flexible enough to accommodate its ongoing success, as active users will constantly develop new questions for their reports to answer. Good reporting will improve the user experience and management utility of the system, raising both data quality and participation among the user population.

© 2007 Matt Gwilliam






Sunday, October 24, 2010

Crystal Reports 8.5 Professional

Crystal Reports 8.5 ProfessionalDeliver rich, interactive content from virtually any data source, publish it to the Web, and integrate it within applications with Crystal Reports. The professional edition of Crystal Reports allows you to design interactive, actionable content and deliver it to users across the enterprise. Generate report types like subreports, conditional, summary, cross-tabs, form, drill down, OLAP, top N, multiple details, and mailing labels. Build hyperlinks, charting, mapping, parameters, alerts, add-ins for Excel and Access, sorting, running totals, grouping, top N, and bottom N.

Crystal Reports Pro includes Crystal Enterprise Standard, which offers report viewers (including DHTML, ActiveX, and Java), a Web-based report management system, a Web server with licensing for five concurrent users, customizable Web desktop, and report delivery regardless of location or platform. Get driver and support for more than 30 SQL-, ODBC-, OLE DB- and PC-based data sources, including XML. Crystal Reports seamlessly integrates with Crystal Enterprise, the powerful, next-generation enterprise reporting solution from Crystal Decisions.

Price:


Click here to buy from Amazon

Friday, October 22, 2010