• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • SPSS Boosts OLAP Performance with ShowCase Suite 7.0

    March 29, 2005 Alex Woodie

    SPSS in April will start shipping ShowCase Suite 7.0, a new version of its collection of business intelligence software for the iSeries server. Based on an OS/400 port of the Essbase 7 multidimensional database that SPSS partner Hyperion first delivered over a year ago, the new ShowCase release is expected to deliver scalability and performance improvements, as well as new data viewing and analysis components to help companies get more usable information out of their data.

    Running online analytical processing (OLAP) and multidimensional database workloads on iSeries servers has gotten a bit of a bad rap lately. Many customers and their IT vendors favor offloading processor-intensive work to less-expensive Intel-based servers running Windows and SQL Server databases, and believe the iSeries is best used for transaction processing, not analytical, workloads.

    While the standards-based computing route may provide more bang for the buck at the low-end, ShowCase has a solid niche at the high-end, where Fortune 100 corporations need 64-bit power to bring disparate databases together into huge data warehouses. The capability with Essbase to build a cube with six, seven, or even up to 10 different dimensions representing various products, geographies, time periods, and other factors can consume a tremendous amount of resources–and provide business insights worth millions of dollars. In some ways, the iSeries, with its advanced storage architecture, ease of management, and vertical scalability is the perfect data warehousing platform, and SPSS, with its Hyperion connection, is in many ways the gold standard for OS/400 OLAP.

    With ShowCase Suite 7.0, the multidimensional scalability story just got better. A new feature with this release called Aggregate Storage Option (ASO) will allow ShowCase Essbase users to create applications “that previously were far too large or complex for your [iSeries] systems,” SPSS says. The ASO will also enable users to calculate cubes much more quickly, which will enable users to refresh their data more often, and provide more timely information to users.

    The usability story also gets better with the new Hyperion Visual Explorer component. ShowCase says this feature displays multiple dimensions of data in a graphical format, which can help users more quickly absorb the underlying meaning reflected in the data, including trends, exceptions, and interdependencies.

    The optional Essbase Integration Services (EIS) component, which integrates data from multiple sources and lets users drill down from the high-level multidimensional level into the underlying relational database level, now supports time-series data created with the ASO feature. This release also brings better support for data mining, SPSS says. More than 250 built-in mathematical functions, as well as various algorithms, help users perform basic data mining tasks against a multidimensional Essbase database.

    ShowCase Suite 7.0 also brings support for Multidimensional Expressions (MDX), a data manipulation language similar to SQL that was created by Microsoft. MDX can be used to query the database, to add new information to it through calculations and formulas, and to calculate cubes built with the ASO feature, SPSS says.

    Another component of the suite, called ShowCase Analyzer, has been improved with more flexible report design capabilities, SPSS says. Specifically, users can now control the content of individual cells, define the look of columns, borders, and fonts, and control other aspects of formatting and printing reports, SPSS says.

    A new “virtual cube” capability for viewing relational data as multidimensional data has also been added with this release. SPSS first started merging relational and multidimensional database technologies with the last ShowCase suite release, version 6.5, 18 months ago (see “SPSS Reaffirms Commitment to ShowCase, OS/400 with New Release”). With ShowCase 7.0, the Analyzer tool’s SQL Grid component lets users access relational data alongside multidimensional data. It also provides access to relational data as if it were multidimensional data using the virtual cubes feature.


    The third core component of the ShowCase Suite, called Enterprise Reporting, also sees enhancements in the area of Web-based report building and distribution; new centralized role-based security protections; and a new Report Services component for better rendering of charts and graphics in reports.

    For more information on ShowCase, visit www.spss.com/showcase.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    PERFSCAN

    Revolutionary Performance Management Software

    At Greymine, we recognize there is a void in the IT world for a dedicated performance management company and also for a performance management tool that’s modern, easy to use, and doesn’t cost an arm and a leg. That’s why we created PERFSCAN.

    PERFSCAN is designed to make your job easier. With revolutionary technology, an easy-to-read report and graphics engine, and real time monitoring, tasks that used to take days can now take minutes. This means you will know your system better and will be able to provide better service to your customers.

    OUR FEATURES

    PERFSCAN is full of robust features that don’t require you to take a three-day class in order to use the product effectively.

    Customizable Performance Reporting

    Whether you are troubleshooting a major system problem or simply creating a monthly report, PERFSCAN lets you select any combination of desired performance metrics (CPU, Disk, and Memory).

    User Defined Performance Guidelines

    No matter if you are a managed service provider managing complex systems in the cloud or a customer analyzing your on-premises solution, PERFSCAN gives you the flexibility to define all mission critical guidelines how they need to be.

    Understanding The Impact Of Change

    Tired of all the finger pointing when performance is suffering? PERFSCAN’s innovative What’s Changed and Period vs. Period analysis creates a culture of proof by correlating known environmental changes with system performance metrics.

    Comprehensive Executive Summary

    Creating performance graphs is easy. Understanding what they mean is another thing. With one mouse click, PERFSCAN includes an easy-to-understand executive summary for each core metric analyzed.

    Combined Real-Time Monitor And Performance Analysis Tool

    With PERFSCAN’s combined built in enterprise real-time monitor and historical performance analysis capability, you will always know how your mission-critical systems are performing.

    Cloud Performance Reporting Is Easy

    Managing performance for production systems in the cloud can be a black hole to many system administrators. The good news is PERFSCAN analyzes all core metrics regardless of the location. That’s why MSPs and customers love PERFSCAN.

    Detailed Job Analysis

    PERFSCAN shows detailed top job analysis for any desired period. All metrics are displayed in two ways: Traditional Report and Percentage Breakdown Pie Chart. This toggle capability instantly shows the jobs using the most system resources.

    Save Report Capability

    Your boss lost the report you gave to him on Friday. Now what do you do? With PERFSCAN’s save report capability, any report can be retrieved in a matter of seconds.

    Professional PDF Reporting With Branding

    Creating professional looking reports for your customers has never been easier with PERFSCAN. Branding for our partners and service provider customers is easy with PERFSCAN.

    Check it out at perfscan.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Wanted: Native RPG and COBOL Support for Browsers Transferring Save Files

    Leave a Reply Cancel reply

Volume 5, Number 13 -- March 29, 2005
THIS ISSUE
SPONSORED BY:

ProData Computer Svcs
SoftLanding Systems
nuBridges
Goering iSeries Solutions
Asymex

Table of Contents

  • Q4bis Streamlines BPCS Reporting for U-Bix Konica Minolta
  • eStorage Joins the VTL Party with the Maxback 4576
  • BOS Adds Security Features to Emulation Products
  • SPSS Boosts OLAP Performance with ShowCase Suite 7.0

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Fortra Issues 20th State of IBM i Security Report
  • FNTS Launches Managed Services for Power Servers in IBM Cloud
  • Total LTO Shipped Capacity Up Slightly in 2022
  • Four Hundred Monitor, May 24
  • Update On Critical Security Vulnerability In PowerVM
  • Critical Security Vulnerability In PowerVM Hypervisor
  • IBM Power: Hosted On-Premises Or In The Cloud?
  • Guru: Watch Out For This Pitfall When Working With Integer Columns
  • As I See It: Bob-the-Bot
  • IBM i PTF Guide, Volume 25, Number 21

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle