OLAP Features in SQL Server

0
393

Introduction to OLAP Features

  • OLAP means Online Analytical Processing.
  • OLAP feature are usefull for data warehousing and data mart application
  • OLAP operations are performed on

1. Group By
2. Rollup
3. Cube

1. Rollup

  • Used to generate a reports that contains subtotals & totals.
  • SUM is a aggregate function.
  • The total is based on A one dimensional data hierarchy of grouped information.

Syntax

SELECT <Column(s)> FROM Group By Rollup (Column1, Column2...)

2. CUBE

  • The result set is multidimensional cube i.e cross tabulation of all possible combination of the columns.
  • It allows to take a specified set of grouping columns and create sub totals for all possible combinations.
  • In our example CUBE operation generated rows for possible combinations of values from Id, Ename & Salary.

SyntaxSELECT <Column(s)> FROM <Table_Name> Group By Cube(Column1, Column2...)

 

Null

  • These are the unknown values.
  • All the null values are considered equal & all put into one NULL group.

Summary

This blog provided an introduction to OLAP features in SQL Server.

 

SHARE
Previous articleDate Time Formats Used in C# MVC
Next articleReal Life Example Of ASP.NET MVC 5
Currently working as a Software Engineer in MNC company. Having working knowledge of technologies like ASP.NET, MVC 5.0, C#, Kendo UI, KnockOut.Js, JavaScript, SQL Server 2012, HTML5 etc. He had conducted more than 80 hands on Seminars, Workshops for College, Schools and Training Institutes. He blog at http://www.c-sharpcorner.com/members/rupesh-kahane2

LEAVE A REPLY

Please enter your comment!
Please enter your name here