Footer 1


198 West 21th Street, Suite 721, New York NY

5109 Pacific Coast Highway, Los Angeles CA


Phone: +88 (0) 101 0000 000

Fax: +88 (0) 202 0000 001

Top Bar Follow Us icons

Latest Posts

    No posts were found.


OLAP Analysis using decomposition approach

Unlike standard Grid/Chart OLAP analysis, Decomposition analysis enables data analysis in multiple steps, while user can see all the steps at the same time and has ability to change each step definition at any time.


Decomposition Analysis consists of analysis levels (steps) added with option to select level members that we would like to explore in subsequent levels we are about to add to see details of analysis interest. This is data drill-down in multiple steps, with great possibility to change selected members of any level, at any time. After you click any level member, it will be included in level selection and complete decomposition tree will be recalculated and visualized with new selection. Decomposition analysis can be saved and shared with other authorized users, collaborate by adding comments and decomposition leaf (last) level can be used to visualize data on the dashboards. Saved decomposition analysis are displayed in ‘Analysis’ section of the application with its characteristic icon.


At each decomposition level, user can select visualization type that best fit current data and nature of analysis (Column Chart, Line Chart, Pie Chart, Doughnut Chart, Table Chart). Level members can be sorted and members can be isolated by TOP n items to narrow level members display of dimensions hierarchies with lots of members. Each Level can be opened in enlarged view with options to visualize and explore decomposition level using whole screen, export decomposition level data in Excel file (with or without chart visualization) or perform Drill-Through actions built in OLAP cube or created ad-hoc in Unique Dashboard BI application. If appropriate at certain point, continue particular decomposition level analysis with standard Grid/Chart analysis in a separate window tab. All decomposition levels can be isolated with additional filters that are added on the top of the analysis and are applied to all visible data on the decomposition tree.


  1. ‘Country’ dimension level is added. Members ‘United States’, ‘Canada’ and ‘Germany’ are selected.
  2. ‘Model Name’ dimension level is added. Showing only ‘Model Name’ members that exists within ‘United States’, ‘Canada’ and ‘Germany’ scope.
  3. ‘Months of year’ dimension level is added showing data only that applies for above levels selected members.
  4. At any time changes selected members of any level to see new analysis data.


Download 30 days evaluation of Unique Dashboard BI software and try all analysis and visualization features in action. It is a simple, 5 minutes installation that will bring you all features unlocked in evaluation version. We will be happy to receive your feedback and inquiries.