2157310 - No Data Shown in Financial Data Source Preview

SAP Knowledge Base Article - Public

2157310 - No Data Shown in Financial Data Source Preview

Symptom

You are doing a preview of a Financial Data Source and receive an info message

No report data available to display; check the selection

along with an empty result list.

However, when you run reports on the same data source you are well able to retrieve data.

Reproducing the Issue

  1. Go to the Business Analytics work center
  2. Go to the Design Data Sources view
  3. Find a Financial Data Source, e.g. G/L Account Period Totals / Balances
  4. Hit Preview button

You'll receive above info message. But reports on that data source (e.g. Trial Balance) show data as expected.

Cause

It is not unusual and not incorrect when a Financial data source does not display any data in preview mode. The reason is that many Financial reports have mandatory selection parameters on purpose because of interdependencies between such parameters. Due to these interdependencies a report could logically not produce any meaningful data. For example, report Trial Balance requires parameters Company, Set of Books and Accounting Period/Year before it can be executed. As the data source preview does not support such parameter entry the report output is empty.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions