MDX parser not supporting AS2005 syntax
Brought to you by:
avix
Analysis Services MDX Select With clause supports
syntax like this:
With Member [Measures].[M0] as 'Sum(NonEmptyCrossjoin
(S6,{([PLANT].[Plant Name].currentMember)}, 1) As
LocalSetAlias,[Measures].[Accum Claim])' Member
[Measures].[ M1] as 'Sum(LocalSetAlias,[Measures].
[Actual DS Weight])' ...
Note that the first member definition there's is a
local set alias, LocalSetAlias defined. That name
can then be used in the rest of the member
definition. This syntax tends to produce a faster
query response for AS2005.
The CUP generated parser does not support this syntax.
Logged In: NO
My email is kit.wong@pvelocity.com