SAP Knowledge Base Article - Public

2673792 - How to transfer Report Story, Table, Tiles and Dashboards between instances with Report Center? (Including Bulk Export)

Symptom

This article explains how to transfer Report Story, Table, Tiles and Dashboards between instances when the source and / or the destination instance have Report Center enabled.

Important Consideration: Reports transferred between instances will work only if both instances have the exact configuration for the fields and tables in the report.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

Environment

SAP SuccessFactors HXM Suite

Resolution

Transferring Individual Reports / Dashboards / Tiles:

  1. Exporting the Report Definition file from the source instance:
    1. Navigate to Report Center in the source instance.

      1.jpg

    2. Locate the desired Report / Dashboard / Tile, click the action menu and select 'Export'.

      2.jpg

      This will download the file to your computer.
      File formats:
      Report - Table (Ad Hoc): .sfr
      Report - Canvas (ORD): .xml
      Dashboard / Tile: exported as .zip and extracted file will be .epix (Tile Based Dashboards cannot be exported)

      Tile_Based_DB.jpg


    1. Caution while exporting 'Report - Canvas' (ORD) reports - Report could be overwritten:
      If the destination instance has a report with the same name, importing the report from the source instance will overwrite the one in the destination instance.
      This action is irreversible.
      You will not have an option to rename while importing. Renaming the export file make no difference since the report's name is stored in the report definition.
      If this is not intended, please duplicate the report in the source instance (rename the duplicate if desired) and export the duplicate.

      overwrite.jpg
       
  2. Importing the Report definition file to the destination instance:
    1. Navigate to Report Center in the destination instance and click the 'Import' button on the top right corner.

      import.jpg

    2. Once prompted by the browser
      1. For Report - Table and Report - Canvas reports:
      2. Select the file exported in step I.2 
        Table reports can be renamed during the import and Canvas reports cannot be renamed during the import

      3. For Dashboards / Tiles:
      4. Select the file extracted in step I.3. Renaming is possible during the import.

        import2.jpg

        Please choose a file of type ".acn", ".sfr", ".epix", ".xml" or".zip" files only.

    3. You will get an on screen confirmation about the upload.

Since the B1811 / Q4 2018 release, it is possible to export and import multiple reports in one shot. - Limited to 50 reports at a time

  1. Login to the source instance and Navigate to Report Center
  2. Select the desired reports, Tiles and Dashboards
  3. Click the Export button

    Multi_Export.jpg

    An archive file titled 'export.zip' will be downloaded
  4. Login to the destination instance and navigate to Report Center
  5. Select the Import option
  6. Browse and choose the archive file exported from the Source instance

NOTE: Do not download Story along with other types of reports.

Keywords

Report, Center, Transfer, Dashboard, Tile, Canvas, Table, Ad, Hoc, ORD, Online, Designer, Bulk, Multi, Export, Import, Limit, 50, fifty, move, copy , KBA , LOD-SF-ANA-RCT , Report Centre , How To

Product

SAP SuccessFactors HCM Suite all versions