Reasons why Pulse will not log a Excel workbook


#1

Extend vs Excel Logger

Pulse uses an Excel add-ins to monitor how Excel is used by TM1 users. Starting with Pulse v5.6, you can choose between two Excel add-ins. We recommend using the new Excel Logger instead of Extend. Excel Logger is a lighter version which will work better for Excel 2016 64 bits than Extend. If you just need the logging feature, you should use now Excel Logger. Excel Logger is the new Excel Add-ins for Pulse moving forward.

Please find below all the reasons why Pulse would not be able to log Excel workbooks:

1. Check if Extend or Excel logger is setup properly

It is very quick to set up Extend or the Excel Logger, just follow these steps:

2. Check if the Excel Logging box is ticked in Pulse

Login to Pulse as Admin, go to Administration > Configuration and check if the TM1 Workbooks box is ticked:
image

3. By default Pulse logs only TM1 enabled workbook

The Extend or Excel Logger toolbar communicates back to the Pulse server each time a user creates, saves, opens or closes a TM1 enabled Excel workbook. A TM1 enabled workbook is one that contains at least one of the following formulas: TM1RPTVIEW, VIEW, DBRW, DBR or DBS. If the Excel add-ins can’t find a TM1 formula, it will not log the workbook.

4. Search by default on the first 50 rows and 50 columns

The Excel Add-ins search for TM1 formulas only on the first 50 rows and 50 columns of each tab. If the TM1 formulas are after these rows and columns, the workbook won’t be logged.
These settings can be found in the cwxtndxl.ini file located in C:\Users\username\AppData\Roaming\CWExtend

DETECT_SHEET_RANGE_ROW=50
DETECT_SHEET_RANGE_COLUMN=50

5. Check ‘TM1_LOG_MAX’ property

In the same cwxtndxl.ini file, ensure that TM1_LOG_MAX is a value that is not zero (i.g. 30). This denotes the time interval that these Excel information gets sent to Pulse.
If TM1_LOG_MAX=0, the Excel addins will not send any data to Pulse.

6. Check the logs

After these steps, if the Pulse workbook logging is still not working, you can find more information in the logs (ErrorLog.txt). The Excel addins logs can be found in the following folder:

  • C:\Users\username\AppData\Roaming\CWExtend

It can be noted that Extend and the new Excel Logger uses the same user profile folder (AppData\Roaming\CWExtend). This has been done to help the transition from Extend to Excel Logger. If you want to replace Extend with Excel Logger, you just need to replace the add-in in Excel and then Excel Logger will use your previous settings defined in AppData\Roaming\CWExtend.