11-115841041 - Client 9.4.1 FP1 Type Mismatch in SubNM

Post bug reports and the status of reported bugs
Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

11-115841041 - Client 9.4.1 FP1 Type Mismatch in SubNM

Post by Alan Kirk »

As noted in this thread:
http://tm1forum.com/viewtopic.php?f=3&t=954

The behaviour of SubNm formulas changed slightly in FP1 of 9.4.1.

Prior to that version you could enter the syntax:

Code: Select all

=SUBNM("ServerName:DimName")
(That is, omitting the other arguments.)

Double clicking on the cell would launch the subset editor. The other arguments would be populated when you selected an element from the editor.

In 9.4.1 FP1, using that syntax will result in an unhandled VBA error 13 (type mismatch) when the cell is double clicked.

Other SubNM formulas will not work after that happens until you press [F9] to recalculate the sheet.

This bug occurred when the function was changed to allow it to use cell references as arguments. Prior to 9.4.1 FP1, if you used a cell reference for, say, the server name, the double click functionality would not work. It does in FP1, but you must specify all of the arguments for the function.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply