Use reporting extension
brice
New Altair Community Member
Bonjour,
I am a new user of rapidminer and my goal is to generate reports like your demo
http://rapid-i.com/enterprise_information/demo_reports/sales/html/index.html
I succeeded to import my excel data with read excel process
Now i want to use report process but when i connected both and lauched them i have not document
Do you have a training video which explained how to generate a report (i did not found it on the web)
Cordialement
I am a new user of rapidminer and my goal is to generate reports like your demo
http://rapid-i.com/enterprise_information/demo_reports/sales/html/index.html
I succeeded to import my excel data with read excel process
Now i want to use report process but when i connected both and lauched them i have not document
Do you have a training video which explained how to generate a report (i did not found it on the web)
Cordialement
Tagged:
0
Answers
-
Salut,
unfortunately I am not aware of any tutorial videos or processes covering the Reporting extension. But you wrote that you already have combined some operators - can you please post what you have so far? An explanation on how to post your process can be found in the link in my signature.
Best regards,
Marius0 -
Bonjour,
Before describe my problem i think it's just i don't have any rapidminer application knowledge
Do you have a manual which describes how to use Reporting Extension
Cordialement0 -
Hi,
I am sorry, as far as I know we do not have any documentation material for the Reporting Extension. However, there are a lot of documentation and tutorials about RapidMiner in general. It is probably a good idea to get accustomed to the general concepts of RapidMiner by watching some of the introductory videos at rapid-i.com/content/view/189/212/lang,en/
After that, it should be quite easy to use the reporting extension. Below I attached an example process for a very simple report.
The general workflow is as follows:
The Generate Report operator creates a report object, where you define a name, the output format and the output folder/file. Then you can add items to the report by using the Report operator. That operator needs data as input, which is added to the report specified by the report_name parameter.
Best regards,
Marius<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.000">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.3.000" expanded="true" name="Process">
<process expanded="true" height="516" width="433">
<operator activated="true" class="retrieve" compatibility="5.3.000" expanded="true" height="60" name="Retrieve Iris" width="90" x="45" y="30">
<parameter key="repository_entry" value="//Samples/data/Iris"/>
</operator>
<operator activated="true" class="reporting:generate_report" compatibility="5.2.000" expanded="true" height="76" name="Generate Report" width="90" x="179" y="30">
<parameter key="report_name" value="my iris report"/>
<parameter key="format" value="HTML"/>
<parameter key="html_output_directory" value="C:\Users\mhelf\Desktop\report test"/>
<parameter key="pdf_output_file" value="C:\Users\mhelf\Desktop\my report.pdf"/>
</operator>
<operator activated="true" class="reporting:report" compatibility="5.2.000" expanded="true" height="60" name="Report" width="90" x="313" y="30">
<parameter key="report_name" value="my iris report"/>
<parameter key="specified" value="true"/>
<parameter key="reportable_type" value="Data Table"/>
<parameter key="renderer_name" value="Plot View"/>
<list key="parameters">
<parameter key="plotter" value="Scatter"/>
<parameter key="scatter_axis_x_axis" value="a1"/>
<parameter key="scatter_axis_x_axis_log_scale" value="false"/>
<parameter key="scatter_axis_y_axis" value="a2"/>
<parameter key="scatter_axis_y_axis_log_scale" value="false"/>
<parameter key="scatter_plot_column" value="label"/>
<parameter key="scatter_jitter_amount" value="0"/>
<parameter key="scatter_rotate_labels" value="false"/>
<parameter key="scatter_multiple_axis_x_axis_log_scale" value="false"/>
<parameter key="scatter_multiple_jitter_amount" value="0"/>
<parameter key="scatter_multiple_rotate_labels" value="false"/>
<parameter key="scatter_matrix_jitter_amount" value="0"/>
<parameter key="bubble_axis_x_axis_log_scale" value="false"/>
<parameter key="bubble_axis_y_axis_log_scale" value="false"/>
<parameter key="bubble_rotate_labels" value="false"/>
<parameter key="parallel_rotate_labels" value="false"/>
<parameter key="parallel_local_normalization" value="false"/>
<parameter key="deviation_rotate_labels" value="false"/>
<parameter key="deviation_local_normalization" value="false"/>
<parameter key="series_rotate_labels" value="false"/>
<parameter key="series_multiple_rotate_labels" value="false"/>
<parameter key="som_jitter_amount" value="0"/>
<parameter key="block_axis_x_axis_log_scale" value="false"/>
<parameter key="block_axis_y_axis_log_scale" value="false"/>
<parameter key="block_jitter_amount" value="0"/>
<parameter key="block_rotate_labels" value="false"/>
<parameter key="pie_absolute_values" value="false"/>
<parameter key="pie_aggregation" value="none"/>
<parameter key="pie_use_distinct" value="false"/>
<parameter key="pie_explosion_amount" value="0"/>
<parameter key="pie_3d_absolute_values" value="false"/>
<parameter key="pie_3d_aggregation" value="none"/>
<parameter key="pie_3d_use_distinct" value="false"/>
<parameter key="ring_absolute_values" value="false"/>
<parameter key="ring_aggregation" value="none"/>
<parameter key="ring_use_distinct" value="false"/>
<parameter key="ring_explosion_amount" value="0"/>
<parameter key="bars_absolute_values" value="false"/>
<parameter key="bars_rotate_labels" value="false"/>
<parameter key="bars_aggregation" value="none"/>
<parameter key="bars_use_distinct" value="false"/>
<parameter key="bars_orientation" value="vertical"/>
<parameter key="bars_stacked_absolute_values" value="false"/>
<parameter key="bars_stacked_rotate_labels" value="false"/>
<parameter key="bars_stacked_aggregation" value="none"/>
<parameter key="bars_stacked_use_distinct" value="false"/>
<parameter key="bars_stacked_orientation" value="vertical"/>
<parameter key="pareto_rotate_labels" value="false"/>
<parameter key="pareto_sorting_direction" value="Descending Keys"/>
<parameter key="pareto_show_bar_labels" value="true"/>
<parameter key="pareto_show_cumulative_labels" value="false"/>
<parameter key="distribution_rotate_labels" value="false"/>
<parameter key="histogram_absolute_values" value="false"/>
<parameter key="histogram_rotate_labels" value="false"/>
<parameter key="histogram_log_scale" value="false"/>
<parameter key="histogram_number_of_bins" value="40"/>
<parameter key="histogram_opaqueness" value="100"/>
<parameter key="histogram_color_absolute_values" value="false"/>
<parameter key="histogram_color_rotate_labels" value="false"/>
<parameter key="histogram_color_log_scale" value="false"/>
<parameter key="histogram_color_number_of_bins" value="40"/>
<parameter key="histogram_color_opaqueness" value="100"/>
</list>
</operator>
<connect from_op="Retrieve Iris" from_port="output" to_op="Generate Report" to_port="through 1"/>
<connect from_op="Generate Report" from_port="through 1" to_op="Report" to_port="reportable in"/>
<connect from_op="Report" from_port="reportable out" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>0 -
I used Generate Report and Report with Excel type.
I got an error: number of rows limit in excel file.
How will I do?
Thank you in advanced0 -
Hi!
The old Excel format (.xls) is limited to ~ 32.768 rows in a worksheet. If you want to put more into it, you'll get this error.
If you just need the data, use Write Excel with the xlsx format.
There's also another Reporting extension available from Old World Computing that might solve your problem better.
Regards,
Balázs
1
