To set up Excel logging to Pulse you need to open the cwxtndxl.ini which is in the following folder:
-
AppDataRoamingCWPulseLogger.
Please find below the list of parameters:
-
PULSE_SERVER: URL to the Pulse server (use the server name and not the fully qualified name).
-
UPDATE_STAMP: For mass updating user settings of the Extend/Excel Logger. More information on the Setting Up Excel Logging to Pulse with Extend article.
-
ENABLE_SIMPLE_TM1_SHEET_CHECK: This is to enable/disable the check for a certain named range in determining whether an Excel sheet is a TM1 workbook. It simply checks for the Named Range: TM1REBUILDOPTION, if it is available on a worksheet.
-
RECALCULATE_FIRST_SHEET: To trigger a sheet recalculation on the first worksheet. Some prefer to put settings on the first worksheet to determine the correct Admin Host / Environment, hence this setting.
This also enables the Excel Logger to correctly grab the correct username in the worksheet, especially those workbooks whose Excel environment is set to Manual calculation.
-
DETECT_SHEET_RANGE_ROW / DETECT_SHEET_RANGE_COLUMN: The area of rows/columns used in checking the type of worksheet is.
The diagnostics section is optional, and you can remove that from the INI file. The ENABLE_DEBUG is the parameter we would usually be asking to be set to true to enable extra logging of information for investigating/troubleshooting issues.
More information about how to set up the Excel logger can be found here: