You can capture logs from Anaplan XL Reporting activity.

Configuration

The log configuration can have different output targets, which you can configure as shown on this page.

You can set the minimum logging level to restrict which events are logged. The levels are available, from the noisiest to the quietest:

  • Verbose
  • Debug
  • Information (the default)
  • Warning
  • Error
  • Fatal

Excel Add-in

You can enable logging in the add-in options: Options > Anaplan XL Options > User Interaction tab > Enable Logging.

Then you need to add a file path for the log file, for example, c:\temp\log.txt.

You will have to restart Excel if you change the configuration.

Manually enabling the Excel add-in log

Create the appsettings.json log configuration file in %appdata%\XLCubed Ltd\XLCubed Excel Edition (you can type this address into File Explorer to go to the correct folder) then restart Excel.

Web

By default, the appsettings.json log configuration file is deployed in the /AnaplanXLWeb installation directory, and will log to a file in the Logs sub-directory.

Sample configurations

File logging

This'll log Verbose messages to a file. The backslashes in the file path must be doubled.

{ "Serilog": { "MinimumLevel": "Verbose", "WriteTo": [ { "Name": "File", "Args": { "path": "C:\\Path\\To\\Logs\\error.log", "rollingInterval": "Day", "retainedFileCountLimit": 10, "restrictedToMinimumLevel": "Verbose" } } ] } }

System debug output stream

Alternatively, you can log to the debug output, which you can capture using DebugView a free tool from Microsoft. 

{ "Serilog": { "MinimumLevel": "Verbose", "WriteTo": [ { "Name": "Debug" } ] } }

Note: This will have information from other programs running on the computer, so may be harder to interpret.

Microsoft Application Insights

You can enable Microsoft Application Insights by copying Serilog.Sinks.ApplicationInsights.dll and Microsoft.ApplicationInsights.dll into the installation folder (the bin folder for a web installation) and setting your appsettings.json to load them:

{ "Serilog": { "Using": [ "Serilog.Sinks.ApplicationInsights" ], "MinimumLevel": "Verbose", "WriteTo": [ { "Name": "ApplicationInsights", "Args": { "telemetryConverter": "Serilog.Sinks.ApplicationInsights.TelemetryConverters.TraceTelemetryConverter, Serilog.Sinks.ApplicationInsights" } } ] } }

The connectionString argument is optional if the Application Insights connection string has either been placed in an APPLICATIONINSIGHTS_CONNECTION_STRING environment variable or application setting, when using an App Service.

Depending on the exact version numbers, you may need to add assembly redirection:

<dependentAssembly> <assemblyIdentity name="Microsoft.ApplicationInsights" publicKeyToken="31bf3856ad364e35" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-2.21.0.429" newVersion="2.21.0.429" /> </dependentAssembly>