You may want to filter your dataset by an attribute from another dimension, such as the Date dimension. The query designer provides the tools needed to slice and dice the data with multiple dimensions. We may not call the multidimensional model a "cube" if we cannot examine the data in different dimensions.
Let's filter the dataset by the sales amount in the year 2008 only. Normally, we want to test the most recent data but we're ok with the 2008 data for now.
dsSalesTerritory
dataset.Date
dimension. Then, expand the Calendar
attribute. Select the Date.Calendar Year
attribute hierarchy. Drag it to the filter pane.Date
from the options. Select Date.Calendar Year
on the Hierarchy column.18.220.184.6