This section shows rules for the slicer specification (WHERE clause). The slicer axis is a way of limiting a query to apply only to a specific area of the database.
A slicer specification consists of the WHERE keyword followed by a tuple, member, or set. You can optionally query for certain dimension properties in the slicer specification.
[WHERE [<slicer_specification> [<dim_props>]] <slicer_specification> ::= <set> | <tuple> | <member>
Note: | The cardinality of the <set> in the slicer should be 1; in other words, if a set is used, it must evaluate to a single tuple. |
<dim_props> ::= [DIMENSION] PROPERTIES <property> [, <property>...]
For example, you may want an entire query to apply only to Actual Sales in the Sample Basic database, excluding budgeted sales or any other measures. The WHERE clause might look like the following:
SELECT
{([West].children)}
ON COLUMNS,
{([Diet].children)}
ON ROWS
FROM Sample.Basic
WHERE ([Scenario].[Actual], [Measures].[Sales])