Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best OLAP Tools 1

Status
Not open for further replies.

vktrez

Programmer
Apr 19, 2017
1
0
0
BY
Hi, What is olap? Prompt a better and more convenient data visualization OLAP tool for SQL server.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top