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.
[WHERE [<slicer_specification>]] <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.
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])
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |