A retail company wants to analyze sales data across different cities and product categories for the last 5 years. Which OLAP operation would allow them to view sales data for a specific city for a specific year?

  • Drill-Down
  • Pivot
  • Roll-Up
  • Slice
In OLAP (Online Analytical Processing), the "Slice" operation allows users to view a specific subset of data for a given dimension (e.g., a specific city) and a particular level of hierarchy (e.g., a specific year). Slicing helps analyze data at a detailed level within the multidimensional data cube.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *