IBM ShowCase Reporting Solution

Provide decision makers with efficient tools to access data, create reports, and automate and streamline the process of creating and maintaining relational and multidimensional databases.

What's New in IBM ShowCase Reporting Solution

  • Manage your reporting assets more efficiently, automate report creation and publishing, and provide a broader range of business users with browser-based access to critical information through an enterprise-level reporting platform
  • Leverage all of your data to drive better business performance thanks to improved operability with current versions of leading technology products and platforms, including IBM i 6.1 and 7.1 and 64-bit Java® Virtual Machine (also called IBM Technology for Java)
  • Add predictive capabilities to your IBM ShowCase reporting solution, which now integrates with predictive analytics technology from SPSS, an IBM Company
  • Reporting automation enhancements with IBM SPSS Collaboration and Deployment Services
    • Obtain more fine-grained control by managing individual IBM ShowCase Warehouse Builder definitions from within IBM SPSS Collaboration and Deployment Services
    • View and/or update custom metadata properties for any version of ShowCase from within Query/Report Writer clients
  • Make administration easier:
    • Start or run the Enterprise Server as a Windows Service program
    • Support for Enterprise Server in a Virtual Server Environment (VMWare)
    • Ability to custom configure your firewall
    • Ability to custom configure client time-outs
    • Roll back ShowCase Server patches if desired
  • Build more sophisticated reports with the ability to have 1MB SQL statements in Query and Report Writer
  • IBM ShowCase Reporting integrates with Oracle®JD Edwards World™ A9.2 and EnterpriseOne™ 9.0 releases, as well as providing client support for Citrix 4.5 and XenApp 5.0

IBM ShowCase Query

Easily access information throughout your organization without relying on IT. With IBM ShowCase Query, users can build SQL statements easily and manage queries efficiently, as well as:

  • Support responsive, informed decision-making
  • View data in ways that help them understand conditions more clearly
  • Streamline the building and execution of SQL statements
  • Integrate results directly into spreadsheets using a powerful Excel™ add-in
  • Run both scheduled and ad hoc queries
Easily build Queries to include the data you need
Easily build Queries to include the data you need

Easily build Queries to include the data you need

Integrate data into Excel and easily refresh with the IBM ShowCase Excel Add-in
Integrate data into Excel and easily refresh with the IBM ShowCase Excel Add-in

Integrate data into Excel and
easily refresh with the IBM ShowCase Excel Add-in

IBM ShowCase Report Writer

With IBM ShowCase Report Writer, everyone can create and deploy customized reports using results obtained with IBM ShowCase Query:

  • 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
  • Support your brand and save time by using pre-set style sheets, avoiding the need to reformat each new report
Easily build print ready reports
Easily build print ready reports

Easily build print ready reports


Enterprise Reporting

The capabilities formerly provided by IBM ShowCase Enterprise Reporting are now available through IBM SPSS Collaboration and Deployment Services (formerly called SPSS Predictive Enterprise Services™).

IBM SPSS Collaboration and Deployment Services is a analytical platform that provides your organization with a foundation that enables you to:

  • Facilitate the sharing of reporting assets and foster greater collaboration across teams, departments, and geographic locations
  • Automate reporting processes for greater reliability, performance, and control
  • Deliver reporting to the right people, in the right way, on a scheduled basis or in real time; and also integrate results with operational systems
Automated reporting processes
Automated reporting processes

Automated reporting processes


IBM ShowCase Warehouse Builder

IBM ShowCase Warehouse Builder simplifies data transformation, loading, and replication, as well as building your data mart or data warehouse:

  • 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

IBM ShowCase Warehouse Manager

Protect both information integrity and system resources with IBM ShowCase Warehouse Manager:

  • 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 the Resource Manager and License Manger, you can:

  • Monitor use across multiple IBM 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