SAP Knowledge Base Article - Public

2796181 - Missing Table rows, or Chart data, when exporting a Story to PDF from SAP Analytics Cloud

Symptom

  • Missing rows of data when exporting to PDF.
  • Not all the chart data exported to PDF format.
  • Not all the rows of the tables are exported to PDF format.
  • In SAP Analytics Cloud, when exporting a Story that contains a Table or a Chart to PDF format, only the visible rows are exported. All other rows are not exported.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. In SAP Analytics Cloud, add a Table or Chart to a Story
  2. When viewing the Story, notice not all the rows or values appear in the Table or Chart, as there is not enough room to display everything.
  3. Export the Story to PDF format, by selecting "File - Export - PDF"
  4. When opening the generated PDF document, notice it only display the rows for the Table, or data for a Chart, that displays on the screen. It is is missing the non-visible data.

Cause

  • When exporting a Story to PDF, the PDF file shows exactly what appears on your Story pages at the moment when you export them. Therefore, if any charts or Tables in your story are scrollable, only the visible parts of those charts are included in the PDF file. This information is also in the SAP Analytics Cloud documentation.

Resolution

  • If possible, resize the Table or Chart to ensure all the content is visible in the SAP Analytics Cloud story, before exporting to PDF format.
  • To get the full table in the exported PDF it is advised to enable pagination (pagination is only available on Canvas pages).

    1. Open the story in edit mode.
    2. Select the table.
    3. Click on Designer.
    4. In the builder, check the Auto-size and page table vertically option.
    5. Go to View mode and go through each page again waiting until all of them are loaded.
    6. Export the story. Full table is exported in the PDF/PPT.

    For reference see this product documentation: Using Pagination in Stories

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, export, missing, table, Auto-size and page table vertically, pdf, ppt , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-UNS-DSG , Unified Story Designer Issues , LOD-ANA-XUS , User assistance, performance statistics , Problem

Product

SAP Analytics Cloud 1.0