While the MDX is valid and complies when running it as MDX, it does not
compile when ran inside of XMLA

It doesn't like the <> and throws an error "Illegal qualified name
character"


Any ideas?

CREATE MEMBER CURRENTCUBE.[MEASURES].[% Change]

AS Iif([Measures].[Prior Period Daily Spend] <> 0 and NOT
IsEmpty([Measures].[Prior Period Daily Spend]),([Measures].[Current Period
Daily Spend]-[Measures].[Prior Period Daily Spend])/[Measures].[Prior Period
Daily Spend], NULL),

FORMAT_STRING = "Percent",

VISIBLE = 1 ;

Since this is text within XML tags, you need to escape <>, like:

AS Iif([Measures].[Prior Period Daily Spend] &lt;&gt; 0 and NOT


http://www.w3.org/International/questions/qa-escapes
...
When to use escapes

Syntax characters. There are three characters that should always appear
in content as escapes, so that they do not interact with the syntax of
the markup. These are part of the language for all documents based on
XML and for HTML.

&lt; (<)

&amp; (&)

...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

ahh, much appreciated

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote