Exploring TM1 - a Chartertech Company
Close this search box.

Logging in Planning Analytics for Excel

Sometimes you may encounter an error with Planning Analytics for Excel and IBM or your IBM partner will request the logs from users of PAX. This blog describes how to enable logging for PAX and where the logs are located.

How to Turn on Planning Analytics for Excel Logging

To turn logging on for PAX do the following:

  1. Open Excel and Planning Analytics for Excel
  2. Click on the IBM Planning Analytics for Excel ribbon
  3. Select on the Options button (to the left of the big Open icon)
  4. Click on the little “IBM” tab at the top left corner of the dialog box
  5. Change the logging level to “All” (or whatever level you’ve been asked to collect logs at).
  6. Click OK

Planning Analytics for Excel Logging

Where are the PAX Logs stored?

By default, PAX logs are stored at:

C:UsersusernameAppDataLocalCognosOffice ConnectionLogs. Obviously, you need to substitute the “username” in this path for your username.

Additional Information to Collect

When you have these logs enabled, ask your users to collect the following information about the problem you are trying to resolve. You will need the:

  1. name of the workbook you had open,
  2. action you were trying to complete (refresh, open, run a process, click a button etc),
  3. approximate time when it occurred.
  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In