Irfan 1/10/2014 2:01:25 PM
The CrossTab view is very similar but the difference in OLAP/Pivot is; a user can create Herierchy at Row Level and Column Level. These values can dynamically be changed by a user creating the group Herierchy in any order. Moreover summarised values (Total) can be placed at the RowLevel; which is ideal for large transactions and more controled view for decision reports, If we are able to expand and collapse Row Level Herierchy.
To get the real flavour of it is the only way that a user can change/create Herierchy by Drag N Drop + Cascading Filter Parameters.