Exporting Report Model to A Dataflow

In Astera ReportMiner, you can export the extracted data to several destinations such as Excel workbooks, delimited files, or a database table destination such as SQL Server, PostgreSQL, MySQL, ODBC etc.

(Note: The exact providers supported depend upon the ReportMiner license you have purchased.)

1.1

6

Follow the steps mentioned below to export your Report Model to a dataflow:

1. Click on img icon in the Model Layout panel if you want to export your data to an excel destination. This will open a new window where you will have to specify the output file location.

7

While exporting in ReportMiner, you have the option to send only filtered data to your export destination. You can see img sign in the data export properties window where you can apply different filters to your data to get your desired output. Click on it to expand the options.

expand

When you expand the rules for filtering data, you will see three sections:

  • Functions: An extensive library of built-in functions from where you can select any function according to your requirement and apply it on your data.
  • Objects Panel: It contains the layout of your report model from where you can simply double-click on the object and write it in your function.
  • Expression builder: Here you can write your expressions by either selecting it from the built-in functions library or writing one of your own.

2. Write expression ITEM= “SOFA” in the expression builder. Compile your expression to check if it is successful or not and click OK when the compile status is successful.

10

3. Go to the Model Layout panel where you can see your exported file with multiple export setting options such as

  1. Preview Selected Export MC_17
  2. Edit Export Settings 14
  3. Run Selected Export 13
  4. Create Dataflow 15
  5. Open and Remove Export Settings 16

11

4. Click on Run Selected Export img button. While the export is running, you can see the progress details and completion status in the job trace appearing in the Job Progress window. On a successful job run, you will get a clickable link to the destination file and the log file in the job trace. If your export encountered any errors during the run, you can click on the link for the log file and view error details.

12

5. Click on destination file link to open the output file. You can see that only filtered items have been exported to the destination file.

17

6. Now, to export your Report Model to a dataflow, click on Create Dataflow img option present in the Data Export Settings panel.

gif-exporting-Rm-to-DF

18