Standardizing the Database Level
Integrated Fact-Based Decision Making

 
Overview
Managers within your organization make decisions every day that can have significant impact on your business. Those decisions will be as good as the information they are based on.

Globalization and fast pace of today's business require accessibility and flexibility to analyze and share that information with suppliers, partners, and customers. Companies today tend to operate on a number of applications within an enterprise that were either purchased departmentally or came along with an acquisition. Typically they may operate on different operating systems, are written in different languages and utilize different databases. The ability to access these various data sources, extract vital business information and consolidate it so that decisions are made on a complete situational picture is critical.

INFINITE BI
INFINITE BI is based on OLAP technology (on line analytical processing), a decision support methodology that allows users to analyze information summarized into multidimensional views and hierarchies. It includes today’s most common BI requirements incorporated into a single program – business analysis, dashboards, balanced scorecards and reporting.
 
  Business analysis tools identify trends on business information so the user can drill down through extensive business statistics to isolate problems and opportunities.
 
 
Dashboards serve up real time business performance indicators and trends to executives and managers.
  Balanced scorecards allow companies to track budgets, align strategic direction, measure performance and project forward in “what if” games.
  Reporting includes the tools to define and design reports, schedule distribution or provide them on demand via the user’s portal page.
  Security is a critical consideration when implementing BI tools. INFINITE BI provides several layers of granularity. User roles define access to menus, forms, and reports. With record level security access to specific information in reports and forms builds can be restricted. With cell level security access to individual cells within a cube can be restricted.

INFINITE BI is a highly scalable, browser accessible, complete solution that is intuitive for both the tech group and the business user. It is an ideal solution for companies wishing to implement business intelligence functionality with a low cost of ownership that is both easy to deploy and easy to maintain.

Business Analysis
INFINITE BI meets a company’s need for an uncomplicated interactive multidimensional visualization, analysis and reporting solution to target opportunities, track performance, and increase profits. It has been designed to import data from enterprise data sources into a central repository and provide business intelligence and decision support. Designated data sources can be updated in real time when necessary. With the easy to use browser interface, the tool allows a skilled analyst and non-technical users alike to quickly manipulate and analyze data and generate reports when they need them without the need for IT involvement.

Create Queries and Graphs
 
Queries based on the predefined metrics and keys
  Complex formulas based on existing metrics
 
Comparative queries comparing current and historical data
 
Graphs on the fly based on the selected information
 
Drill down starting from summary to details level without knowing the underlying cube structure
Custom and dynamic filters to subset data set
Real time data updates as required
 
 
Publishing and Running Queries
 
Save and share queries
  Export to other applications and databases (Excel, Word, Oracle, etc.)
 
Role and filter based security to protect data from unauthorized access
 
Integrate with other applications using web services
 
Enhanced performance using summary tables
Distribute Queries and Graphs via email, subscription or deliver to portal
 
 
Dashboards
Placing a dashboard on an executive’s sign-on page provides an at-a glance, real-time snapshot of the business – revenues, expenses, sales, shipments, returns, etc. Traffic lights, alerts, drill-downs, summaries, graphs and gauges are setup in a portal. Content can be pre-defined by user group or customizable. Data can be clickable, allowing the user to drill down within the data presented.
 
Easy to implement using the web interface
  Snapshot of business performance
 
Shorten time to decisions with reports, maps, charts, scorecards User group-defined performance indicators to monitor business unit/departmental performance
 
Enable drill down for dashboard elements to underlying queries

 
Balanced Scorecards
Balanced scorecards have been around for over ten years, but many companies have not adopted them because they seemed so complex to implement. By focusing on key strategic business drivers – financial performance, customer retention, employee satisfaction and innovation/new product development, for example – companies can gauge performance both quantitatively and qualitatively. Once statistical relationship can be established among various business activities, executive can play "what-if" games to understand what effect strategic initiatives might have on the business.

Snapshot view of performance against targets
  Performance trends with direct access to underlying data and reports
 
Means to measure non-financial performance critical to long-term business health
 
Metric data to measure past performance and project future trends

Reporting

The integrated report engine module lets the end-user community can design and develop professional reports with the integrated report engine module included with INFINITE BI. Browser deployed reports require no setup, applets or installation at the client machine. Security-based publishing of pre-defined reports makes reporting effortless for the end-user community. At the same time, a sophisticated toolkit allows authorized users to create, customize, publish and run reports on an ad-hoc or scheduled basis. The Report creation Wizard is designed with users with little or no technical background. The Wizard will guide the users from table selection to publishing the reports.

Creating Professional Reports

Delegate reports from legacy applications to modern reporting environment
  Design professional reports using the engine’s buttons and icons to insert business charts, format style, and related functions
 
Easy to design and customize – no programming experience required
 
Customize formatting to include orientation, font, location of business graphs and charts, and more
 
Create ad hoc reports via the web interface
Build reports to run at a scheduled time or immediately
Create reports with filtering, sorting, calculations and summary functions
Customization capabilities allow the report format and layout to be changed on demand
Integrate preformatted charts to visually enhance the report

Publishing and Running Reports

Reports can be read, printed, and disseminated to users based on security definitions
  Web browser accessibility is achieved with a zero-footprint approach
 
Drill-down capabilities allow users to get to the level of detail required before printing or disseminating
 
Export functions include integration with other applications (i.e. Excel), PDF file format, or push out directly to a printer
 
Create email distribution to any mail account on virtually any timetable
Add reports to portal for reports-on-demand


 
SOA

Services Oriented Architecture (SOA) is an evolution of distributed processing and the Internet. SOA is a methodology, it not a programming tool such as web services, Microsoft.NET, Java, XML, etc. Rather, these are tools to implement SOA architecture.

INFINITE Software uses SOA in the implementation web services for portals, integration and legacy modernization and workflow reengineering projects. The objective is to revise these older internal processes and interfaces and transition them to more flexible web services.

SOA and web services help INFINITE Software achieve very important modernization needs.
 
 

 
Enable legacy applications to operate in today’s technology environment.
 

 
Integrate Midrange or mainframe legacy systems with the enterprise – Microsoft desktop and newer Java applications that need to be able to interact.
 

 
Replace most of the current hard-coded interfaces with services that can be used within the enterprise intranet, business extranet and the Internet.
 

 
Extend and expand organizational reach with web-based B2B, B2C and B2E portals

 

TRADEMARKS


Copyright © 2008 INFINITE Software. IBM Midrange,AS/400, OS/400 and System/36 are registered trademarks of the IBM Corporation.Windows, Internet Explorer, Visual Basic,VB Scripting are registered trademarks of Microsoft. INFINITEweb, INFINITE BI, INFINITEiSeries, INFINITE 36 are registered trademarks of INFINITE Software. All other product and brand names are registered trademarks of their respective companies. No part of this document may be reproduced without written permission of INFINITE Software.