Report preparation task returns "Source data contains no rows" error

The Report preparation task may report errors when processing OLAP dimensions and cubes if the information necessary to populate those objects has not been imported into the Data Warehouse. The error message appears in the following format:

Processing error [Source data contains no rows] <object name>

Solution

If you are importing a subset of data into the Data Warehouse (for example, you are not running the Campaign data import task), you might want to disable the processing of objects for which there will be no data. This will prevent the "Source data contains no rows" error messages.

To disable processing of Analysis Services objects, set the ProcessingEnabled flag to 0 in the CubeProcInfo and DimProcInfo tables for the cubes and dimensions you do not want to process.

If you are importing all data into the Data Warehouse, the import process may not work as expected. If data is not being generated by your site, and is therefore not imported, the source data will contain no rows, and that data will not be available for reports. It is also possible that the site and visit activity for your site are not properly correlated. Check to ensure that your site is issuing an AuthTicket when each visitor connects. Your visit activity might be identified as belonging to an anonymous user.

If you do not want to include certain data in the reports you generate, and do not collect or import that data, see Knowledge Base article Q301580. This article provides information about preventing OLAP processing errors in instances where the SQL Server object on which the relevant cubes and dimensions are built contains no data.

For information about troubleshooting Business Desk reports, see Troubleshooting Business Desk Analysis.

Copyright © 2005 Microsoft Corporation.
All rights reserved.