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
- Go to the Business Analytics work center
- Go to the Design Data Sources view
- Find a Financial Data Source, e.g. G/L Account Period Totals / Balances
- Hit Preview button
You'll receive above info message. But reports on that data source (e.g. Trial Balance) show data as expected.
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.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To