...
Popular Online Analytical Analytical Processing (OLAP) server technologies such as Pentaho Mondrian Project, JasperReports, and Microsoft SQL Server Analysis Services (SSAS) enable business users to analyze large quantities of data, offering features such as drilling into and cross-tabulating information from complex analytical queries in real-time. However, the default user interfaces (UIs) are limited, and it can be difficult or impossible to add the additional behaviors that are typically needed when integrating with a larger application. Connecting CubeGrid APIs to these multidimensional, or 'cube'‘cube’, data sources will allow you to:
...
- Microsoft SQL Server Analysis Services (SSAS) is available as a part of Microsoft SQL Server, a proprietary RDBMS written in C++ and sold in a wide variety of commercial and free editions. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. Microsoft's Microsoft’s OLAP engine supports MOLAP, ROLAP and HOLAP storage modes for data, and supports the XMLA standard as the underlying communication protocol. Cube data can be accessed using MDX and LINQ queries, and data mining specific functionality is exposed via the DMX query language.
...
- getConnection() creates an OLAP connection to Mondrian server by default. For this example, we used the "FoodMart" “FoodMart” sample dataset included with Mondrian.
- getConnectionJasper() creates an OLAP connection to JasperReports Server. To use this method, first rename getConnectionJasper() to getConnection(). For this example, we used the sample dataset included with JasperReports Server.
- getConnectionAServices() creates an OLAP connection to Microsoft Analysis Services. To use this method, first rename getConnectionAServices to getConnection(). For this example, we used the Adventure Works samples referenced below.
...
Download the project source code used in the examples here.
Examples
Lastly, we'll we’ll show a few images of the Project in action.
...
- Opening screen for Data Cube selection
- Select Data Cube from the OLAP Server
- Select Dimensions (Facets) of the Data Cube for placement on rows and columns
- Select 'Create CubeGrid'‘Create CubeGrid’
Figure 2: The newly created CubeGrid with Control Panel for Dimension (Facet) manipulation
...
Please Note: Some Dimensions in the test cubes are very large and not collapsible due to their non-hierarchical nature. For example, the 'Customers' ‘Customers’ dimension in the 'Sales' ‘Sales’ cube sample for Mondrian shows all values. As a result, the cube may become difficult to navigate or show a slow scripts browser warning. The recommended way to avoid this is to require that the end user choose specific members from large dimensions before adding them to the cube.
...