MicroStrategy - Dicing
The Dicing operation of a data set involves creating a smaller data set by fetching multiple values of one dimension with respect to one value from another dimension. For example, we get the values of sales for different subcategory of products with respect to one single category. Here, there is a hierarchical relationship between the category and sub-category of products.
Consider the data set superstore which contains the following dimensions −
- Customer segment
- Product category
- Product sub-category
Following screenshots show the steps to dice the data with respect to the dimensions customer segment and product sub-category.
Let’s first create a grid report with the dimensions Customer segment and Product subcategory. We can also add the metric Profit.
Next, let's create a filter using the dimension customer segment. For this filter, we choose the value 'Customer segment'. However, we get the value of profit for all the values of sub-categories under this customer segment. Here, the data is diced across the subcategories for a given customer segment.