SAP Knowledge Base Article - Public

3316180 - The method Table_x.getDataSource() doesn't display complete data from the data source

Symptom

In your Analytic Application(AD), you have a table and use the method Table_x.getDataSource() to get data from the table ,which query data from a BW Query. You find that part of the source data can't be displayed on the table.

Environment

SAP Analytics Cloud 1.0

Reproducing the Issue

  1. In your AD, you create a table. The table uses a BW live connection as the source and it executes a BW query.
  2. You further create other objects ,such as drop down list, based on the data from the table.
  3. In the drop down list and the table, you find that just part of the data can be displayed. 

Cause

This is caused by "default row limitation" of 500 rows of the table.

Resolution

Change the row limitation as below:

Make your table to be visible(if it is hidden) ->Click the warnings of the table ->Edit drill limitation ->Change to “Unlimited” ->save the AD and run it again.

Keywords

drop down , KBA , LOD-ANA-AD , Analytics Designer , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0