Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

There are two methods for importing CSV data to use for report building:

  1. Create a Data Source process  and follow the instructions for CSV.
  2. Report Builder process

Import Methods

...

  1. The user defines any calculations or converters to be applied to the data, creating additional fields in the final table.
  2. The user defines all default formatting and relationships between fields, such as drill down, through the CSV step. These will be reused whenever someone selects this CSV for report building.
  3. Yellowfin creates a View with all of the above fields, formatting, and relationships for reuse by other report writers. This View will be available during the report writing process, and the View itself can be edited by users with permission in order to adjust the default settings defined.

View Builder Import

...

  1. .

When the View Builder import process is used, the following happens:

  1. The user defines any converters to be applied to the data, creating additional fields in the final table.
  2. Yellowfin creates a table that is listed in the View Builder, allowing the user to select it, as they would any other table from the selected source connection. This table will be available to any View built on the writable source connection.
  3. The user selects the CSV table and adds it to the View like they would any other table, joining it to other tables, etc.
  4. The user defines any default formatting and relationships between fields, such as drill down, through the standard View Builder steps, rather than the CSV step.

Setup

Styleclass
ClasstopLink

top

...

Expand
titleClick to Expand Instructions
  1. Navigate to Administration > Admin Console.
  2. Open the Roles section and click on the role you wish to enable CSV access for.
  3. Enable the following:
    1. Report Types - this provides the user with access to advanced report authoring options, such as CSV Import.
    2. CSV Reports - this gives the user access specifically to the Load CSV File option on the Report Builder's initialisation step.
    3. Advanced CSV Functionality - this allows users to select advanced options, including which writable data source to use, rather than relying on the default option.

      Note: this is an optional role permission.
  4. Save the role.

View Builder

...

    1. .

...

Expand
titleClick to Expand Instructions
  1. Navigate to Administration > Admin Console.
  2. Open the Roles section and click on the role you wish to enable CSV access for.
  3. Enable the following:
    1. Database Views - this provides the user with access to the standard View Builder.
      Image Removed
    2. Create CSV Table - this enables the CSV Import functionality within the View Builder.
      Image Removed
  4. Save the role.

...