ShowCase Reporting Solution

Support Smart, Fast Decision Making

You need to make critical business information available to decision makers throughout your organization quickly and cost effectively. ShowCase Suite provides an enterprise-level operational reporting platform that enables you to share business intelligence with everyone from senior executives to front-line staff.

Using ShowCase Suite, these individuals can see and explore information in ways that will help them do their jobs more effectively. For example, they can:

Design reports that highlight key metrics
Integrate reporting into other business processes
Incorporate data or reports into Microsoft® Office applications
Manage reports, queries, and related information in a single, secure, and central repository
Build and manage data marts and data warehouses

The ShowCase reporting solution consists of: ShowCase Query™, ShowCase Report Writer™, ShowCase Warehouse Builder™, and ShowCase Warehouse Manager™. An operational reporting environment is provided through integration with SPSS Predictive Enterprise Services™ , a platform for deploying and managing reporting assets across the enterprise.

The SPSS Predictive Enterprise Services reporting environment gives your organization the ability to automate the scheduling and distribution of reports, and even notify individuals or groups when information is updated. Business users can modify and run reports on demand through a Web browser and customize their interfaces so that essential information is easy to find.

Get the information you need—fast

With ShowCase Query, people in all areas of your organization can access the information they need on their own, so your IT staff can focus on more strategic projects and your employees can work more productively.

ShowCase Query helps users build SQL statements easily and manage queries efficiently. It enables your managers and staff to:

Run both scheduled and ad hoc queries
Streamline the building and execution of SQL statements
View data in ways that help them understand conditions more clearly
Support responsive, informed decision making
Export results directly to popular spreadsheet programs such as Microsoft® Excel™ or Lotus® 1-2-3®

For greater time savings, ShowCase Query “add-ins” for Excel help you eliminate manual re-keying of data into spreadsheets by automatically populating them with data and refreshing the information each time a spreadsheet is opened.

ShowCase Query allows you to access data from multiple sources—including IBM DB2, Microsoft SQL Server™, Oracle® databases, and Lotus Domino® on the System i—to ensure your reports contain all of the information you need.

Create reports to support decision making

ShowCase Report Writer makes it easy for everyone in your organization to create and deploy customized reports using results obtained with ShowCase Query. This component supports self-service reporting and helps your organization optimize both staff time and computing resources.

With ShowCase Report Writer, your organization can:

Efficiently create presentation-quality reports—even crosstab reports—and make a professional impression during business meetings and sales calls
Streamline report creation by using drag-and-drop tools
Give reports more visual impact by introducing graphic elements, such as logos
Easily format fonts, colors, column and row sizes, and other visual aspects of your reports
Support your company’s brand and save time by avoiding the need to re-format each new report through the use of pre-set style sheets

Print or e-mail reports or, using the built in reporting capabilities of SPSS Predictive Enterprise Services, manage reports centrally and distribute and view those reports through a Web browser.

This operational reporting environment enables your organization to:

Establish a central, secure, and searchable repository
Provide users with easy access to content and report output via the reporting platform’s browser-based interface
Share query and report definitions over the Web for scheduled and dynamic execution
Publish Excel spreadsheets
Create reports that include charts and images and link multiple reports
Schedule the processing and distribution of routine reports
Integrate and automate reporting with other business processes using powerful, built-in automation and Python® scripting

Report designers can easily enhance the structure, formatting, look, and feel of reports; save formatting as a style sheet; and distribute reports via e-mail or using the reporting capabilities of SPSS Predictive Enterprise Services.

Report consumers can quickly access and interact with the information they need to improve decision making, receive automatic notifications by e-mail when information they use is updated, and subscribe to content without going through an administrator.

System administrators can control access to information and the actions that can be taken with it, as well as schedule reports and maintain the central repository.

Organize data—and keep it current

With ShowCase Warehouse Builder, you can create a data mart that houses a specific type of information or meets the needs of a particular functional or geographic area. Or create a data warehouse that brings together information for your entire organization.

ShowCase Warehouse Builder helps simplify data transformation, loading, and replication, as well as the building of your data mart or data warehouse. Using Warehouse Builder, you can access and consolidate data from any of the platforms and data sources that ShowCase Query can access, plus Microsoft Excel™ and Access™.

You can also accomplish these essential tasks more easily:

Select specific rows or columns from one or more tables in a transactional database and move this information to new or existing tables for development
Assign meaningful names to any column or table
Create calculated results columns

ShowCase Warehouse Builder integrates with other components of the ShowCase Suite, enabling you to:

Populate multidimensional databases automatically, using direct links to Essbase on either System i server, a Windows NT server, or servers using the Windows 2003 or Windows 2000 operating systems
Run Essbase® routines such as SQL loads, dimension builds, database calculations, and more
Import Query/400 objects and definitions from ShowCase Query and manipulate them to define source data
Automate Warehouse Builder sets within the Predictive Enterprise Services environment.

Through ShowCase Warehouse Builder, the ShowCase Suite integrates with a number of leading Enterprise Resource Planning (ERP) systems, including Oracle® JD Edwards World™ and EnterpriseOne™. This integration enables your organization to develop more meaningful reports from your ERP data quickly and easily.

Manage Data and System Resources

ShowCase Warehouse Manager helps protect both information integrity and system resources.

With ShowCase Warehouse Manager, you can tightly control and monitor user access to data and simplify routine data management tasks. This helps you realize a greater return on your IT investments.

Through the software's Security Manager, you can:

Secure data at the collection, library, table/view, column, and row levels without affecting other applications
Secure data by user or group of users
Create and manage user and group profiles

By using its Resource Manager and License Manager features, you can:

Monitor use across multiple ShowCase products
Define the actions that specific users or groups can take with respect to your data
Set job priorities to optimize resources
Monitor system usage and tune system performance for optimal data access

ShowCase Warehouse Manager's security features integrate with the security of major ERP solutions. For example, the limits you've set to specific applications, rows, and columns in your Oracle® JD Edwards World™ or EnterpriseOne™ solutions are automatically recognized by ShowCase Warehouse Manager.

Manage queries and other important tasks easily through ShowCase Warehouse Manager. For example, database administrators can:

Define and manage database security, aliases, and user profiles and privileges
Secure data by user or group of users
Set job priorities to optimize system resources
Monitor system usage for improved performance and optimal data access

Here is more detailed information on What's New in ShowCase Suite 8.0.

Here is information about system requirements for the ShowCase Suite.

To learn more about how you can benefit from the ShowCase Suite, contact an SPSS sales representative.

Contact SPSS Sales

ShowCase Reporting Solution top

Support Smart, Fast Decision Making

Get the information you need—fast

Create reports to support decision making

Organize data—and keep it current

Manage Data and System Resources