How to create CSV exports from SAC Stories and Applications

    With biExport for SAC you can also export data to CSV: Also multi-dimensional drilldowns and (display) attributes are supported!

    This post shall give you detailed instructions on how you can configure SAC dashboards to export dashbords to the CSV format.

    biExport Widget (Applications)

    After adding the biExport Widget to Analytical Applications, users can do online exports to a great variety of export formats. To enable export to CSV, you need to do the following:

    1. Open the Designer Pane and scroll down to the Display attributes.
    2. Select (at least) Export CSV:
    3. Go to the General attributes. Click on the button next to Load hidden content
    4. Select the Tables you want to export in CSV format. Only for the selected Widgets, biExport will retrieve the result sets and meta data:

    When you execute the application, you will see an Export button with the option to export to CSV:

    Of course you can also use your custom button or link to initiate the export by using the extensive SCRIPTING library.

    The CSV export will transform this table:

    … into this CSV file:

    Scheduling (Stories and Applications)

    The CSV export is also available for scheduled exports. biExport SAC Scheduler can be used to create event-based or calendar-based, automated exports of SAC Applications and SAC Sories!

    To enable export to CSV, you need to do configure the following:

    1. On the Export Document tab, choose CSV as Format:
    2. You can also configure the Separator and whether an Export header shall be visible or not.
    3. All other settings can be applied as shown in this blog post.

    As a result, a Story with a table such as this one…

    … is exported like this:

    Exporting huge result sets

    SAC comes with some limitations on the number of rows, columns and cells that can be displayed. These “drill limitations” are created for performance reasons. You can find more information under the following links:

    If you want to create CSV downloads of bigger tables, you can do so by using another biExport tool: The CSV Downloader is an add-on to SAP BW and provides algorithms to circumnavigate any result-set limitations provided by the OLAP processor.

    An export with the CSV Downloader works different from the biExport CSV export:

    1. You choose a Query
    2. You choose filters
    3. You choose Measures and Dimensions (optionally: Attributes) to be displayed
    4. Optionally: Define the presentation as Key and/or Text
    5. Inititate the export or schedule the generation
    6. Move to the monitor to download the file

    More information on the CSV Downloader can be found in this blog post.

    Thilo Knötzele
    Author: Thilo Knötzele
    Creation date: 09.11.2021
    Category: Implementation
    back to overview