2009年2月17日星期二

Introduction of "Mondrian Output" job entry

As we all know, There is a "Mondrian Input" step in Spoon, you can execute a MDX query in this step and the result rows will be sent to the next step.
"Mondrian Output" Job entry is similar to "Mondrian Input" step, but it 's a job entry. This job entry can execute a mdx query and the result will be send to a Excel file(Thanks to JPivot), and the Excel file will be added to the result files.
GUI of "Mondrian Output" is also similar to "Mondrian Input" step, except you must specify a Excel file as output and a XSL file as the output style. the file names can include variables.
You can also specify a XSL style file in the GUI, the JPivot's mdxtable.xsl is used as the default style file if you don't set any style file in the dialog.






"mondrian output" job entry













"mondrian output" job entry dialog

result of "mondrian output" job entry

to do:
add an "add chart" option in the GUI and a "chart configuration" panel. in the panel user can set some parameter of a chart such as chart type(line,bar,pie...),font,etc.

1 条评论:

  1. Jason,

    That looks really cool. Perfect way to get mondrian reports to business users for them to read offline. Thanks for contributing this.

    Julian

    回复删除