New analysis based on data collections

You add a new empty analysis that is based on a data collection or multiple data collections.

To add an analysis based on a data collection:

  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.  Click on: New.
  3. Select based on a data collection.
  4. Select the first data collection. Later on you can add more data collections.
  5. Click on: Next.
  6. Enter the description. 

    Note:

    It is recommended you only use letters, digits and spaces in the name of the analysis. Do not use characters that are not allowed when you add a folder in Windows Explorer. You can use a hyphen (-), but not a slash (/).

    That is because when publishing an analysis on InSite, the analysis must be published in a subfolder that has the same name as the analysis. If the name of the analysis contains characters that are not allowed in Windows Explorer, Profit will suggest a folder name from which these characters have been removed. The cockpit will be published correctly, but for reasons of consistency it is recommended to not use these characters.

  7. The other fields determine the authorisation of the analysis. You can change these later on.

    Take into account that an added analysis is immediately visible for other users, unless you immediately block the analysis.

    The product determines in which menu the analysis is available. For example, if you select the Financial product, the analysis is available in the General / Output / Management / Analysis and Financial / Output / Management / Analysis functions.

    The remaining fields are important for the filter authorisation of analyses.

  8. Click on: Next.
  9. If applicable, add a data collection or change a data collection.
  10. Click on: Next.

    You see the data collections of the analysis selected earlier.

  11. Click on: Next.
  12. If necessary, specify a filter for each data collection.
  13. Click on: Finish.

On a local installation, the analysis opens in Microsoft Excel.

To open an analysis in AFAS Online:

In AFAS Online, you perform the following extra steps.

  1. Start InSite
  2. Click on: Communication Center.

  3. Open the analysis from the My files overview.

Directly to

  1. Add an analysis
  2. New analysis based on a data collection
  3. Copy an existing analysis
  4. Add an analysis based on a view