Abstract
Crosstab reports, also known as pivot tables, are a breed unto themselves, and each reporting tool handles them very differently. Likewise, each RDBMS has its own SQL approach for assembling crosstab data. In a similar fashion, each RDBMS has its own OLAP extensions (like SQL Server) or are OLAP databases unto themselves (like the Arbor/Essbase multidimensional OLAP engine that’s also licensed by IBM as DB2’s OLAP engine—see http://www.essbase.com for more information). In this chapter you’ll learn how to assemble, query, and create crosstab data, and how OLAP databases differ from the traditional relational model.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2003 Carl Ganz, Jr.
About this chapter
Cite this chapter
Ganz, C. (2003). Crosstab Reports and OLAP. In: Real World Enterprise Reports Using VB6 and VB .NET. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0770-2_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0770-2_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-064-5
Online ISBN: 978-1-4302-0770-2
eBook Packages: Springer Book Archive