[Mondrian-users] minor enhancement for CmdRunner

[Reidmiller, C. <cre...@ci...>]

Greetings,

=20

We have found CmdRunner to be a helpful tool for testing queries.  We
generally use it in conjunction with a mondrian.properties that has a
trace level of 1 and a debug out file specified in order to see the
generated SQL with associated execution times.  I have added some small
changes to CmdRunner.java and Util.java that provide a bit of summary
information following the SQL details.  The MDX query is displayed along
with the elapsed query time and the time consumed by database work.
Here is an example of the expanded output:

=20

SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select
`dates`.`inv_year` as `c0` from `dates` as `dates` group by
`dates`.`inv_year` order by `dates`.`inv_year` ASC], 16 ms

SqlMemberSource.getMemberChildren: executing sql [select
`part`.`part_type` as `c0` from `part` as `part` where
UPPER(`part`.`part_type`)=3D'M' group by `part`.`part_type` order by
`part`.`part_type` ASC], 47 ms

SqlTupleReader.readTuples [[Cost Type].[CT]]: executing sql [select
`costtype`.`cost_type` as `c0` from `costtype` as `costtype` group by
`costtype`.`cost_type` order by `costtype`.`cost_type` ASC], 31 ms

SqlMemberSource.getMemberChildren: executing sql [select
`dates`.`inv_month` as `c0` from `dates` as `dates` where
`dates`.`inv_year` =3D 2005 group by `dates`.`inv_month` order by
`dates`.`inv_month` ASC], 437 ms

SqlMemberSource.getMemberChildren: executing sql [select
`part`.`part_nbr` as `c0` from `part` as `part`, `invfacts` as
`invfacts` where `invfacts`.`part_k` =3D `part`.`part_k` group by
`part`.`part_nbr` order by `part`.`part_nbr` ASC], 0 ms

=20

Cmdrunner finished executing mdx query:  select

{Crossjoin({[Location].[All Locations]},[Time].[2005].Children)} ON
COLUMNS,

NON EMPTY {[Part].[All Parts].[M].Children} ON ROWS

from [Inventory]

where ([Measures].[Quantity Max], [Cost Type].[current]);

=20

*** Elapsed time for query: 2079 ms,  database time: 531 ms

=20

Would these changes be considered for source inclusion?  If so, I would
be glad to provide them by whatever means is convenient.

=20

Thanks, Chuck=20