Database Reference
In-Depth Information
8. Do note that although you can edit the MDX, you cannot include functions
that are not supported by the cube browser. For example, the browser does
not support sorting data, so neither can we include the
order
function to sort
data nor can we include any dimension, except for measures on columns (yet
another limitation of the 2012 cube browser).
9. The cube browser does allow us to filter data. Click on the
Select dimension
drop-down box above the result set and select the Promotion dimension.
Next, select the
Promotions
hierarchy, and set the filter to
Volume Discount
41 to 60
(filter expression dropdown allows you to pick an option from the list
of available promotion categories, types, and names). Switch to the design
view again to see the updated MDX. Notice that this time the query used
a subselect (subquery) to limit the output. Also have a look at the following
code:
SELECT
NON EMPTY { [Measures].[Unit Price],
[Measures].[Total Product Cost] } ON
COLUMNS,
NON EMPTY { ([Due
Search WWH ::
Custom Search