Troubleshooting Pulse Excel logging

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 that 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:

The Excel Logger needs to be set up on each customers’ laptop.

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

• Setting Up Excel Logging to Pulse with Extend 6
• Setting Up Excel Logging to Pulse with Excel Logger 23

Both Extend and Pulse Excel Logger come with a 32 and 64 bits version. To find out what is your Excel version, open Excel and then go to File > Account > About Excel.

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

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.

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:UsersusernameAppDataRoamingCWExtend or C:UsersusernameAppDataRoamingCWPulseLogger

DETECT_SHEET_RANGE_ROW=50
DETECT_SHEET_RANGE_COLUMN=50

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.

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:UsersusernameAppDataRoamingCWExtend
• C:UsersusernameAppDataRoamingCWPulseLogger

It can be noted that Extend and the new Excel Logger uses the same user profile folder (AppDataRoamingCWExtend). 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 AppDataRoamingCWExtend.

Pulse will log an Excel Workbook only if it the Excel file is saved somewhere, when you create a slice from a cube view, you will have to save the Excel file first for Pulse to pick it up.