SAP Knowledge Base Article - Public

2660162 - No Data in Financial Data Extraction Run AIS File When Using Customized Reporting Package

Symptom

  • You use a customized Reporting Package in the Financial Data Extraction Run.
  • In the Messages tab of the Extraction run the message 'No report data available to display; check the selection' is displayed.
  • You get no data in the downloaded AIS file.
  • You expect to see  Data in the AIS file from the Financial Data Extraction Run.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger work center.
  2. Go to the Periodic Tasks - Extraction Run for Financial Data view.
  3. Highlight Run ID XXX (where XXX is the Run ID of the Financial Data Extraction Run).
  4. Press Edit Reporting Packages.
  5. Highlight ABC (ABC represents the customized Reporting Package): In the Details section you can see, for instance, one or two standard report IDs DEF and GHI which are correct (where DEF and GHI represent the standard report IDs).
  6. Back in the Extraction Run for Financial Data view highlight run ID XXX and press View.
  7. Navigate to the Data Selection tab: You can see that the correct Reporting Package has been chosen.
  8. Switch to Messages tab: The message 'No report data available to display; check the selection' is displayed. This means that no Data has been extracted. You expect some Data Sets here.
  9. Switch to the Processed Successfully tab: Everything looks as expected.
  10. Switch to the Processed with Errors tab:  No errors are displayed here.

Cause

The mapping of the customized Reporting Package with the Selection and the View of the Reports needs to be adjusted as the current parameters of the reports don't sync with the necessary data selection of the Extraction run.

Resolution

As the standard parameters don't suffice the requirements of the Extraction run, you need to create new reports as a copy of the existing standard reports DEF and/or GHI. In the new reports the selections and views are to be adjusted. Afterwards, you create a new customized Reporting Package in the General Ledger work center and assign the newly created reports. Finally, this new reporting package can then be used for the Extraction run.

To copy the standard reports:

  1. Go to the Business Analytics work center and navigate to the Design Reports view.
  2. Search for Report ID DEF.
  3. Highlight Report DEF and press new - Report as Copy.
  4. Enter a name for the new Report, JKL, for example, which you can later recognize easily.
  5. Press next until step 5 - Define Variables.
  6. Select the respective Variable Name and press Maintain Default Values.
  7. Enter the period for the Variable Name (for example, between 01.01.YYYY until 31.12.YYYY) and press OK.
  8. Press Next and then Finish.

Then adjust the Report selection and view set-up:

Go to the Business Analytics work center  and navigate to the Design Reports view.

  1. Find the newly created Report JKL (where JKL is the new Report).
  2. Open the Report JKL.
  3. Press Selection - Save as.
  4. Enter a name for the Selection, MNO for example.
  5. Press Set as Default.
  6. Press Go.
  7. Move relevant variables from Not Currently Shown to Rows.
  8. Press View - Save as.
  9. Enter a name for the View, PQR, for example.
  10. Choose Set as Default again.

Finally, create a new Reporting package and add the new report:

  1. Go to the General Ledger work center and to the Extraction Run for Financial Data view.
  2. Press Edit Reporting Packages.
  3. Press Add Row.
  4. Create a new customized Reporting Package ABC.
  5. Under Details press Add Row.
  6. Select the Report ID JKL.
  7. Select the Report View ID MNO.
  8. Choose the Selection Variant ID PQR.
  9. Press Save and Close.

Execute the Financial Data Extraction Run again, this time with the newly customized Reporting Package.

Now the AIS file contains Data Sets.

Keywords

AIS File, No report data available to display; Financial Data Extraction Run; Customized Reporting Package; Report View ID; Selection Variant ID; Report ID; Extraktionslauf für Finanzdaten; Berichtspaket; Selektionsvariantennummer, Berichtsnummer; Berichtssichtnummer , KBA , ais file , no report data available to display , financial data extraction run , reporting package , selection variant , report view , extraktionslauf für finanzdaten , selektionsvariantennummer , berichtspaket , berichtsnummer , berichtssichtnummer , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions