Manually enabling features in the tm1features.json file
There are some features in Planning Analytics for Microsoft Excel that will need to be manually enabled before use. This topic will provide you with a list of features that need to be manually enabled and how you can manually enable certain features in Planning Analytics Workspace.
How do I edit the tm1features.json
file?
- Ensure that no Microsoft Office applications are open.
- Navigate to the C:\<user profile path>\Cognos\Office Connection folder.
- Open
tm1features.json
in a text editor. - Edit the desired parameter.
- Save the
tm1features.json
file.
Tip: You can also find the Office Connection folder in Planning Analytics for Microsoft Excel by clicking
and then navigating up one level.
Note: If the
tm1features.json
file does not exist, you can create one by using an
empty text file and naming it tm1features.json
. Be sure to save it to
C:\<user profile path>\Cognos\Office Connection\.List of features in Planning Analytics for Microsoft Excel that need to be manually enabled
- Constrained Calculations
- To enable Constrained Calculations, you need to set the
r56_EnableManualConstrainedCalc parameter to
true
.{ "r56_EnableManualConstrainedCalc": true }
- Quick Report headers
- To enable the information header in a Quick Report, you need to set the
r48_QuickReportLabeling parameter to
true
. By default, the parameter is set tofalse
, and the header information is hidden.{ "r48_QuickReportLabeling": true }