|
|
|
Slicing
|
|
Slicing data is the process of setting the context of the information you are viewing.
E.g., you can view the sales per customer in the context of the year ‘2006’ for
products ‘A’ and ‘B’. Setting the context is easy in DWE, just select the hierarchy
for which you want to include in the current context a check the desired items.
The left image shows you a selection of customer geography, which is an hierarchy
in the selected cube. We have selected all customers from Birmingham and Huntsville
(in Alabama, USA).
|
|
|
|
Filtering
|
|
|
You can filter your results to leave out or only include values that meet certain
conditions. E.g., you can filter the results to only show the top or worst 10 customers
for product ‘X’, or only show the products that generate profit instead of loss.
Filtering can be achieved by simply clicking on the column header of the column
on which you want to filter and defining the filter conditions.
|
|
|
|
Sorting
|
|
You can sort your results by simply clicking the title of the column on which you
want to sort. Just as you would expect.
Columns can be sorted with or without loosing the hierarchy. Sorting without the
hierarchy means that all values in the column are sorted without looking at the
hierarchy. All values in all columns have been sorted from small to large. Sorting
with the hierarchy means that within a certain level all rows are sorted.
|
|
|
|