Back in December, I highlighted the availability of the a new InfoSphere Warehouse Redbook that focused exclusively on our Cubing Services OLAP feature.
[If you’re unfamiliar with benefits of Cubing Services, check out this short video.]
Since then, the team at IBM International Technical Support Organization (ITSO) have been working hard with our InfoSphere Warehouse experts to deliver new 2 free publications.
The first new publication is entitled “Enabling Robust Business Analytics with InfoSphere Warehouse Cubing Services”. Here’s the abstract:
In this IBM® Redguide™ publication, we describe how you can develop an environment that will enable you to perform more detailed analytics on your data and turn it into powerful information and business insight for making better informed decisions. Business decisions have historically been made primarily by analyzing data with techniques that limit you to a two dimensional view of that data. However, decisions are rarely defined or determined by such a narrow perspective. Now you can view and analyze your data from multiple perspectives – or dimensions as they are called in the technical world. We call this Multidimensional Analysis. With multidimensional analysis, you can extract significantly more business value from your data resources. We refer to that information as business intelligence. You can discover, for example, trends and patterns in the data that you might never have realized were there. And you can begin to really understand what variables truly impact your business. IBM has made it easier and gives you the tools to help you develop this capability and a significant business advantage.
[This publication is a Redguide. Unlike a Redbook, which provides in-depth technical information and implementation guidance, a Redguide is shorter and focuses on the business view of technology.]
The second new publication is a Redbook entitled “Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services”. Here is the abstract:
In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus of this infrastructure is the InfoSphere Warehouse Cubing Services Feature. With this feature, DB2 becomes the data store for large volumes of data that you can use to perform multidimensional analysis, which enables viewing complex problems from multiple perspectives, which provides more information for management business decision making. This feature supports analytic tool interfaces from powerful data analysis tools, such as Cognos 8 BI, Microsoft Excel, and Alphablox.
This is a significant capability that supports and enhances the analytics that clients use as they work to resolve problems with an ever growing scope, dimension, and complexity.
Analyzing problems by performing more detailed queries on the data and viewing the results from multiple perspectives yields significantly more information and insight. Building multidimensional cubes based on underlying DB2 relational tables, without having to move or replicate the data, enables significantly more powerful data analysis with less work and leads to faster problem resolution with the capability for more informed management decision making.
This capability is known as No Copy Analytics and is made possible with InfoSphere Warehouse Cubing Services.
Here’s the chapter outline:
- A multidimensional infrastructure
- The relational multidimensional model
- Cubing services model implementation
- Reporting solutions
- Cubing services performance considerations
- InfoSphere Warehouse on System z: Cubing Services