Troubleshoot TM1 worksheet functions

Use the information in this topic to help troubleshoot TM1® worksheet functions.

#NAME!
Check that the IBM® Cognos® Office Reporting TM1 add-in is enabled. For more information, see Enable the add-in required to work with TM1 worksheet functions.
#VALUE!
The formula could not be solved. Check the syntax. Make sure that you have specified a valid value for all required parameters and in the required order.
#N/A
Check that you are connected and logged in to the TM1 server referenced in the formula.
RECALC_0_0
The calculation is in progress. If the calculation option in Microsoft Excel is set to Manual, a refresh of the sheet or the book is required to complete the calculation.
Note: RECALC_0_0 may appear if the calculation was interrupted or canceled.
Blank cell or 0 when a value is expected
One or more objects could not be found.

Check that the objects you specified in the formula are available.

  • If the formula references a dimension, verify that the dimension is available on the TM1 Server Application folder.
  • If the formula references a member, make sure that the member exists in the dimension you specified.
  • If the formula references an attribute, make sure that the attribute exists for the member you specified.
  • If the function has an index argument, verify that the value you are using is in range. For example, DIMNM returns a blank cell if the index parameter is 0 or if the index value is greater than the number of members in the dimension.
For example, if a DBRA formula returns an empty cell, perform the following checks:
  • Check that the dimension is available on the TM1 Server Application folder.
  • Check that the member exists in the dimension.
  • Check that the attribute exists for the member.
  • Check that the names you are using in the formula match the names on the TM1 Server Application folder and cube exactly.
Tip: To see the attributes of a member, right-click the member in the tree and select Search Metadata. The Name list contains the available attributes for the member.