Cognos's flagship product has historically been PowerPlay. It can access Essbase and Analysis Services cubes, yet its new ReportNet product (for query and reporting) can currently access only SAP BW Info Cubes.
Hyperion has long had two distinct products: Hyperion Reports for OLAP-based financial reporting and Hyperion Analyzer for OLAP analysis. With its newly acquired Brio product line, the former Brio products have been rebranded as Hyperion Intelligence (DOLAP) and Hyperion SQR for production, relational reporting. Hyperion Intelligence, then, provides a third way to access OLAP data for analysis and management reports. Throughout the year, Hyperion plans to provide further integration among these products.
Microsoft's new Reporting Services can theoretically create a report from an Analysis Services cube, although the report author must write custom MDX. For analysis, though, Microsoft relies on other partners such as ProClarity and Panorama to provide the OLAP interface, in addition to the BI suite vendors reviewed here.
This segment of the BI Scorecard highlights just a few of the OLAP architectures and features you must consider when selecting or standardizing on a BI tool. For an administrator, the ease of designing, building, and tuning the OLAP platform is critical. For end users, capabilities such as attribute analysis, write access for what-if analysis, traffic light displays, and time-period analysis are also important.
Next Focus: Administration
You've provided users with a full range of query, reporting, scheduling, spreadsheet, and analysis capabilities. It's now up to IT to administer the BI application. Fail to consider these criteria, and you'll have a sexy application that easily breaks. In the next installment of this series, I'll cover administration concerns.
Cindi Howson is the president of ASK, a BI consultancy. She coteaches The Data Warehouse Institute's "Evaluating BI Toolsets" and is the author of Business Objects: The Complete Reference (McGraw-Hill Osborne Media, 2003).