Save an analysis as a cockpit (HTML) (Profit Communication Center)

A cockpit is a Profit analysis saved as an HTM file (web page). You can use the Command Line Utility to generate a cockpit via the Profit Communication Center.

Example:

You have created the Sales analysis in Profit.

Using the Profit Communication Center, you can publish this analysis as a cockpit to the location C:\Cockpits\Sales.htm every night. This means that you can immediately view this cockpit the next day.

This functionality is available for AFAS Online and in a local Profit installation. In both situations, you use the Profit Communication Center on your own system and the cockpit is saved locally.

Preparations:

• Install and configure the Profit Communication Center (PCC)

  Install the PCC on the system (the application server) that you use for publishing the cockpit.

• Install Microsoft Excel

  Install a supported version of Microsoft Excel on the system (the application server) that you use for publishing the cockpit.

To change an analysis:

Every analysis to be published must contain the 'PublishAnalysis' macro. This macro publishes the analysis as an HTM page. In this macro, you specify the name and file location of the HTM page.

The 'PublishAnalysis' macro can also be used to publish a cockpit that can be accessed from an InSite site. The analysis may therefore already contain a 'PublishAnalysis' macro used for that purpose. You cannot just change such a macro. Always consult the InSite administrator in your organisation.

Creating the 'PublishAnalysis' macro is described in the section on publishing cockpits on InSite.

To create a batch file (.bat):

Add a batch file on the system on which the Profit Communication Center is installed. If you installed the Profit Communication Center in the default location, you can use the following command line:

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="analysis name in Profit" /ENVIRONMENT="environment name"

For example: you want to publish the 'Sales' analysis from the ERPDEMO environment:

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="Sales" /ENVIRONMENT="ERPDEMO"

Publish the Social analysis

Use this commandline to publish the social analysis from Profit HRM.

Commandline:

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="naam analyse in Profit" /ENVIRONMENT="environment name" /HANDLER="socialeanalyse" /WERKGEVER="number" /PERIODETABEL="number period table"

Example:

C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /HANDLER="socialeanalyse" /WERKGEVER="01" /PERIODETABEL="5"

Publish the occupation analysis

Use this commandline to publish the occupation analysis from Profit HRM.

Commandline:

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="analysis name" /ENVIRONMENT="environment name" /HANDLER="bezettingsanalyse" /VANDATUM="dd/mm/yyyy" /TOTDATUM="dd/mm/yyyy" /PERIODETABEL="number period table"

Always use a forward slash (/) for dates, do not use the format of the regional settings of your system.

Example:

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="naam analyse in Profit" /ENVIRONMENT="O12345AA" /HANDLER="bezettingsanalyse" /VANDATUM="01/01/2019" /TOTDATUM="07/01/2019" /PERIODETABEL="5"

Administration filter

The command line offers a field that allows you to filter on administration code.

Add the Administration field to the data collection of the analysis.

Commandline:

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="analysis name in Profit" /ENVIRONMENT="environment name" /UNIT="administratienummer"

Example:

You want to publish the 'Sales' analysis from the O12345AA environment for administration 1.

"C:\Program Files (x86)\AFAS Software\Profit Communication Center\Profit communication center.exe" /PUBLISH="Sales" /ENVIRONMENT="O12345AA" /UNIT="1"