This Android based OLAP client, gives users the ability to define spreadsheets with dimensions and measures and then to manipulate the information to test different scenarios or find answers to business questions. Detailed as well as high-level consolidated data can be reviewed and analyzed within seconds. Using selection lists and drop-down menus to control the data displayed in interactive charts, Axional Mobile OLAP provides a highly intuitive interaction with cubes.
The OLAP Client allows you to quickly analyze multidimensional data in a flattened, two-dimensional grid format or in specific graphs or maps, so that you can quickly find hidden problems, opportunities, and trends. The OLAP Client includes a full set of features to manipulate cubes:
The Drill-down operation summarizes data to subsequent levels of a dimension hierarchy. Is like a Zoom on details on certain part of the cube. The OLAP cube “knows” the hierarchy of the dimension, so when the analyst issues a command to “drill down”, the cube knows the next level of data to be presented. For example, “Product”, can be explored in more detail by product category.
Pivot (or rotate)
This function rotates the data axis to view the data from different perspectives. User can just swap the rows and columns by a single click, or do a more complex operation by moving one of the row dimensions into the column dimension. If required, the system groups data with different dimensions.
Roll-up (or consolidate)
Takes the current aggregation level of fact values and does a further aggregation on one or more of the dimensions. Dimensions have hierarchies or formula-based relationships of data within each dimension. The Roll-up or Consolidation process involves computing all of these data relationships for one or more dimensions, for example, adding up all Cities to get Total Zone data.
While such relationships are normally summations along a hierarchy, any type of computational relationship might be defined, such as “profit = sales – expenses”.
When presenting the resulting table, the OLAP Client automatically decreases the number of dimensions and/or removes row headers.
The user can navigate easily across the cube by adding, moving or changing the order of dimensions and measures in the columns and rows boxes. The OLAP Client offers sophisticated filtering capabilities, allowing the user pre-select a set of values for one or more members of the dimensions. With the filtering capabilities, user can do Scoping, that is, restricting the view of database objects to a specified subset. Further operations, such as update or retrieve, will affect only the cells in the specified subset.
Nesting (of multi-dimensional columns and rows)
Using the Nesting display technique, the user can view the results of a multi-dimensional query that returns a sub-cube, i.e., more than a two-dimensional slice or page. The column/row labels will display the extra dimensionality of the output by nesting the labels describing the members of each dimension. For example, the display’s columns may be:
These columns contain three dimensions, nested in the user’s preferred arrangement. Likewise, a report’s rows may contain nested dimensions:
|Chocolate Bars||Unit Sales||xxxx||xxxx|
|Fruit Bars||Unit Sales||xxxx||xxxx|
The user can navigate easily across the cube by adding, moving or changing the order of dimensions and measures in the columns and rows boxes. The OLAP Client offers sophisticated filtering capabilities, allowing the user pre-select a set of values for one or more members of the dimensions.
Graphics, Charts and Maps
The tool includes powerful graphical capabilities. It gives business users the tools and flexibility to dynamically obtain reports and graphics on a highly interactive and easy to use mobile interface. Some types of supported graphics are:
- Stacked area and columns
It also includes capabilities for Geographical Analysis. Generally, most data has a component which makes references to a place: an address, a post code, a census, a region, a country, a GPS coordinate, etc. The geospatial maps allow the visualization, analysis and management of data with a geographical component. With Axional DBOLAP users can create maps which will help them to visualize patterns, tendencies or exceptions in its data.
The results of Geospatial Analysis can be represented in different types of maps:
- Multilayer maps
- Thematic maps
- Heat maps, including clustering capabilities when zooming in or out
The tool includes the most popular export formats like Microsoft Excel or PDF.