Use reporting extension

bricebrice Member Posts: 2 Contributor I
edited September 2019 in Help
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

   
Tagged:

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    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,
    Marius
  • bricebrice Member Posts: 2 Contributor I
    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

    Cordialement
  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    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>
  • aKe_nichnanaKe_nichnan Member Posts: 1 Contributor I

    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 advanced

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn

    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

Sign In or Register to comment.