support ASQueryGen XML output

Apr 5, 2011 at 4:01 AM

Rob-

Looks very user friendly... much more so than the ascmd scripts.

One thing I do fairly commonly is take the dozen test cases and blow them out into several hundred queries using ASQueryGen (AS Query Generator from http://sqlsrvanalysissrvcs.codeplex.com) so that I can run longer load tests. I would love it if your tool could run query files like this. The XML file output from ASQueryGen looks like this:

<Queries>
  <Query>/* 1 : 1 */
   SELECT { DESCENDANTS( ([Time].[Calendar].[Calendar Year].&amp;[2004]),
   [Time].[Calendar].[Calendar Week] ) } ON COLUMNS ,
   { [Measures].[On Hand Qty], [Measures].[Model Qty] } ON ROWS
   FROM [REAL Warehouse]
   WHERE ( [Customer].[By Geography].[All],
   (([Item].[By Category].[Product].&amp;[B].&amp;[174].&amp;[174Y].&amp;[174YA].&amp;[6594042])),
   [Replen Strategy].[Replen Strategy].[All],
   (([Store].[Geography].[District].&amp;[28]))
   CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, ACTION_TYPE
  </Query>
  <Query>/* 1 : 2 */
   SELECT { (([Store].[Geography].[District].&amp;[28])),
   (([Store].[Geography].[District].&amp;[28])),
   (([Store].[Geography].[District].&amp;[28]))
   } ON COLUMNS ,
   DESCENDANTS ( ([Time].[Calendar].[Calendar Year].&amp;[2004]),
   [Time].[Calendar].[Calendar Month] ) ON ROWS
   FROM [REAL Warehouse]
   WHERE ( [Measures].[cAvg Retail] )
   CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, ACTION_TYPE
  </Query>
</Queries>