Database Reference
In-Depth Information
Figure 14-13.
The results of the first and last examples from Listing 14-18
Listing 14-18.
Expression Syntax
--1) You can use parentheses to surround expressions
With Member Measures.[
AddStuff
]
As
(5 + 7) -- Numeric data
SELECT Measures.[
AddStuff
] On Columns
From [CubePubsSales]
--2) However,
you CANNOT use Braces
to surround your expression
With Member Measures.[AddStuff]
As
{
5 + 7
}
-- Causes an #Error
SELECT Measures.[AddStuff] On Columns
From [CubePubsSales]
--3) Oddly, you
CAN use Single Quotes
to surround your expression
With Member Measures.
[AddStuff]
As
'5 + 7'
SELECT Measures.[
AddStuff
] On Columns
From [CubePubsSales]
Calculated members are most commonly placed on the Measures dimension, but this is not a requirement.
They can be placed on any dimension. Listing 14-19 gives some examples using the Date dimension for our
calculated member instead of the Measures dimension. The result of this query is the total sales quantity for the
combined years of 1992 and 1993. Figure
14-14
displays these results.
