A term used to describe a complex data analysis function provided by multidimensional tools that allows users to view their data from any angle.
An OLAP user-initiated process of navigating by calling for page displays interactively, through the specification of slices via pivoting and drilling.
This is an informal term referring to data retrieval and manipulation. We can picture a data warehouse as a cube of data, where each axis of the cube represents a dimension. To "slice" the data is to retrieve a piece (a slice) of the cube by specifying measures and values for some or all of the dimensions. When we retrieve a data slice, we may also move and reorder its columns and rows as if we had diced the slice into many small pieces. A system with good slicing and dicing makes it easy to navigate through large amounts of data.
A colloquial phrase recognizing the ability to analyze data along many dimensions and across many subsets, including analyzing a data warehouse from the perspective of fact tables and related dimensions.
Changes and arranges data when you choose different categories for your report drill down and drill up filter information For example, if a report shows the number of products sold by each branch at the end of the last quarter, you can slice and dice information to show revenue over the last two months for each product line.
The ability to access subsets of a data cube by adding constraints to one or more dimensions.