- Tech know how online


In the context of business intelligence, the term rotation represents a figurative description for changing the perspective on the key figures in an OLAP cube

. OLAP cubes are descriptive representations of multidimensional structures. They consist of key figures ( facts) and dimensions with attributes assigned to these key figures. This allows the user

to view the key figures from different perspectives. For example, they can switch from viewing the key figures over time to viewing the key figures by product group or by sales region. This process is called rotation because you are figuratively switching from the view of one dimension to another, as if you were rotating a cube.

Rotation of data structures

Rotation of data structures

Tools for viewing OLAP cubes in pivot tables

have functions with which you can rotate the view by swapping the dimensions in the axes of the pivot table or (more visually clear) by swapping the horizontal and vertical dimension axes. Rotation is required for the slice and d ice analysis technique.

Informationen zum Artikel
Englisch: rotation
Updated at: 10.04.2010
#Words: 174