SAP Knowledge Base Article - Public

3147578 - One row of data is missing between pages of a Table, when viewing a Story in SAP Analytic Cloud (SAC)

Symptom

  • Row of data missing.
  • Table skipping one row of data at the top of the next page.
  • When viewing a Story in SAP Analytic Cloud, one row of data is missing between the pages of a Table, when the Table option "Auto-size And Page Table Vertically" is selected.

Environment

  • SAP Analytics Cloud 2022.20.25

Reproducing the Issue

  1. In SAP Analytics Cloud, create a Story.
  2. Add a Table with at least one row, and one column.
  3. Select the Table, then click on the 3 dots in the upper right corner, and select the option: "Freeze – Up to row"
  4. Select the Table, and in Builder, check the options:
    • Adaptive Column Width
    • Arrange Totals / Parent Nodes Below
    • Auto-size And Page Table Vertically
  5. View the Story.
  6. At the bottom of the Table, take note of the last row value, and click on the next page.
  7. On the next page, at the top of the Table, take note of the row value.
  8. Go in the Edit view on the Story.
  9. On the Table, scroll to the row that appeared on the last row of the first page of the Table in View mode.
  10. Notice the next row of the Table is not the row that appear on the next page of the Table in View mode.
      
    In other words, when viewing the Story in view mode, one row of data is missing between pages of a Table.

Resolution

  • Check the Table option "Optimization presentation". 
  • Note: This is now the default option for Tables.
          
  • Workaround: To display all the row of a Table, uncheck the Table option: "Auto-size And Page Table Vertically"

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-TAB , Table , Bug Filed

Product

SAP Analytics Cloud 1.0