|
|
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].&[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].&[B].&[174].&[174Y].&[174YA].&[6594042])),
[Replen Strategy].[Replen Strategy].[All],
(([Store].[Geography].[District].&[28]))
CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, ACTION_TYPE
</Query>
<Query>/* 1 : 2 */
SELECT { (([Store].[Geography].[District].&[28])),
(([Store].[Geography].[District].&[28])),
(([Store].[Geography].[District].&[28]))
} ON COLUMNS ,
DESCENDANTS ( ([Time].[Calendar].[Calendar Year].&[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>
|
|