Best OLAP Tools Best OLAP Tools vktrez (Programmer) (OP) 19 Apr 17 14:23 Hi, What is olap? Prompt a better and more convenient data visualization OLAP tool for SQL server. RE: Best OLAP Tools fominlena (Programmer) 20 Apr 17 08:03 OLAP tools are tools for online analytical processing. These tools are used for data analysis that helps to understand complex data and see insights in it. OLAP tools include different methods of working with data, represented in a form of multidimensional OLAP cube. List of OLAP tools includes: Slicing is an OLAP tool that allows to create smaller subcubes from main OLAP cube by choosing single value on one dimension. Dicing is also an OLAP tool that creates a subcube but by picking values on multiple dimensions. Drilling Down/Up tool allows to navigate between the most summarized and the most detailed data. Roll-up OLAP tool summarizes data on one cube dimension. Pivoting allows users to see data from different perspectives by rotating the cube. This list of OLAP tools is not complete and also it doesn't contain one of the most practical tools - OLAP reporting tools. For example you need to add data over last quarter to the annual financial report. With OLAP reporting tools all you need to do is publish OLAP analytical reports onlile rather that working with loads of Excel files. Ranet OLAP supports all the listed tools and OLAP reporting tools as well. Ranet OLAP also supports data from any kind of source.