Symptom
- In the preview of a data source, i.e. data source HCMTLMB07, it is not possible to fetch required data.
- It therefore seems to be impossible to utilize this data source to merge and create a new report.
Environment
SAP Business ByDesign
Cause
The preview does not always provide all data. For example, a data source like HCMTLMB07 has a temporal join which requires a key date. But in the preview functionality of this data source, this key date is not available as selection parameter. So, it takes the current date for the key date and displays the data for the current date. This is the standard behavior.
Resolution
To see the correct data in above example, design a report based on the data source, where the key date will be available for the selection and the data can be displayed accordingly.
This approach is generally useful in cases where the preview functionality does not provide expected results.
See Also
KBA: 2646546 - Unable To Preview Financial Data Sources
Keywords
incorrect, missing, time, get, retrieve, , KBA , AP-TIM-ANA , Analytics , Problem