Resolve error messages in analyses

This topic contains tips for solving error messages.

For error messages in Microsoft Excel (for example, about errors in formulas), please refer to that program’s Help.

To resolve error messages in analyses:

1. Go to:
   • General / Output / Management / Analysis (all analyses)
   • CRM / Output / Management / Analysis
   • Financial / Output / Management / Analysis
   • Fiscal / Output / Management / Analysis
   • HR / Output / Management / HRM analysis
   • HR / Output / Management / Payroll analysis
   • Order Management / Output / Management / Analysis
2. Open the analysis.
3. Perform the following steps for each data collection in the analysis:
   1. Select the data collection.
   2. Click on: Change.
   3. Click repeatedly on: Next.
   4. Click on: Example.

      If the data you expect is entered into the example, the data collection is OK. If the example does not contain any data, check the filter (previous step in the wizard).

      If a message appears instructing you to replace fields when you open an analysis, perform this procedure.

   If all data collections are correct, continue with the following steps.

4. Open the analysis in Microsoft Excel.

   You can suppress the automatic starting of macros by keeping Shift pressed when opening an analysis.

   If this resolves the error, check the macros in question.

   If not, continue with the following steps.

5. Close the analysis.
6. Make a copy of the analysis so you can experiment with it.
7. Open the analysis.
8. Enter a general filter to limit the number of records. This makes it easier to check the analysis.

   

9. Open the analysis in Microsoft Excel.
10. Experiment with the analysis, for example by removing some of the worksheets. This allows you to isolate the error.