Business Intelligence ArticlesThe following articles are available for download as PDF files. If you don’t have the Adobe Acrobat Reader please download it here.
Symmetry PROOF Approach, Symmetry White Paper. The white paper provides an overview of PROOF design principles and standard PROOF design patterns.
How to Leverage Project Server 2007 with PerformancePoint Server 2007 Monitoring and Analytics, William G. Brown, Symmetry and Microsoft White Paper, January, 2009. This white paper provides an overview of the PerformancePoint Server software and how it can be used to develop dashboards with the existing relational and analytical databases created with Microsoft Office Project Server 2007. In addition to detailing some advanced techniques for creating analytically rich scorecards, it covers how to organize Key Performance Indicators (KPIs) and other best practices. Sample data files (PerformancePoint Builder Workspace and ProClarity Briefing Book) are also provided. See the ReadMe file for more information.
Business Intelligence Offerings: Oracle and Microsoft, Symmetry White
Paper, August, 2005. The white paper reviews the key considerations in
deciding on a BI offering, compares the strategies of Oracle and Microsoft,
and evaluates their respective BI offerings.
Evaluating Business Intelligence Offerings: Business Objects and Microsoft, Symmetry White Paper, August, 2005. The white paper reviews the key considerations in deciding on a BI offering, compares the strategies of Business Objects and Microsoft, and evaluates their respective BI offerings.
Undocumented Express, William G. Brown, Oracle Internals, February, 2000. The article describes a series of useful Express tips and functions that take advantage of Express' stored procedure language.
Getting Started with ADAPT, Dan Bulos with Sarah Forsman, Symmetry white paper, July, 1998. The white paper introduces the basic elements of ADAPT, explaining each of the nine ADAPT database objects and their symbols, and illustrating how to use the symbols with simple examples.
Oracle Financial Analyzer:A Look Under the Hood, William G. Brown, OTJ, winter, 1996. The article discusses how you can develop Oracle Financial Analyzer applications faster and streamline ongoing system maintenance.
OLAP Council White Paper, Sarah Forsman, April, 1996. The paper defines OLAP, who uses it and why, and reviews the key features required for OLAP software.
OLAP Council Benchmark Study, Dan Bulos, April, 1996. The paper describes the OLAP Councilís Analytical Processing Benchmark, APB-1.
How To Evaluate OLAP Servers, Dan Bulos, DBMS Magazine, August, 1995. The article contains a comprehensive checklist of features that you can use as a framework for evaluating OLAP servers.