Hello Gurus,

Need your help on following:

1. Whether an MDX query be stored in an XML format? e.g. can the below
query be stored in an XML file format: (the query is for illustration
only).

with set [PromoMonths] as 'Filter([Time].[Month].Members,
Not IsEmpty( ([Unit Sales], [Double Your Savings]) ) )'
set [PromoRange] as 'Head( [PromoMonths] ).item(0).item(0) :
Tail( [PromoMonths]
).item(0).item(0)'
member [Measures].[Uplift] as '([Unit Sales], [Double Your Savings])'
member [Measures].[This Quarter] as '[Unit Sales]'
member [Measures].[Last Quarter] as '( ParallelPeriod
( [Time].[Quarter] ), [Unit Sales] )'
member [Measures].[Growth] as ' [This Quarter] - [Last Quarter]'
select [PromoRange] on Columns,
{ [This Quarter], [Last Quarter], [Growth], [Uplift] } on Rows
from [Sales]

2. If #1 is yes, is there a standardized schema file which would
validate the MDX query stored in an xml format.

3. Is there a available parser which would convert the MDX query stored
in XML format to a proper MDX query given in #1.

4. I am trying to build a GUI tool to create the MDX expressions as my
end users are not conversant in MDX. Any help/information detail in
this regard would be very helpful.

Please provide me a link or send me details at ajit555 (AT) yahoo (DOT) com.

Regards,

Ajit.