SUBNM is supposed to lookup a value from a SUBSET by using either the subset index number OR the element name. It also has the ability to do that lookup based upon an alias, but it's not working correctly when using the element name.
If a subset called "Valid" contains the elements A, B and C then the formula SUBNM(server:dim,"Valid",1) will report a value of "A". This is correct.
If the formula SUBNM(server:dim,"Valid","D") is written however, the SUBNM will return "D" as long as its valid within the DIMENSION. This is incorrect, as "D" is not an element within the "Valid" SUBSET.
If a user wanted to check if an element existing in the DIMENSION, then they would use DIMIX not SUBNM.
SUBNM, when using an element name, should only return a value when the element exists in the SUBSET, not the DIMENSION. I believe the current functionality is incorrect and should be amended.
SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
- Posts: 3
- Joined: Mon Jun 02, 2008 1:35 pm
- OLAP Product: TM1, Jedox
- Version: TM1 10.2.2, Jedox 6
- Excel Version: Excel 2016
- Location: Budapest
Re: SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM
Hi, Vincent
could you help me? I come back in this weeks to TM1 after long time. Do you know about the status of this SUBNM issue?
I'm using 10.2.2 FP5 but this issue is exactly the same as for 8 years!
Is there any workaround?
Thank you for an answer.
Best regards,
Attila
could you help me? I come back in this weeks to TM1 after long time. Do you know about the status of this SUBNM issue?
I'm using 10.2.2 FP5 but this issue is exactly the same as for 8 years!
Is there any workaround?
Thank you for an answer.
Best regards,
Attila
-
- Community Contributor
- Posts: 161
- Joined: Tue Apr 02, 2013 1:41 pm
- OLAP Product: tm1, cognos bi
- Version: from TM1 9.4 to PA 2.0.9.6
- Excel Version: 2010
- Location: Toronto, ON
Re: SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM
This has been always an issue, even within a TI Process, there was no function to check if an element exists in a given subset, until the last Fix Pack ( 10.2.2 FP6 ), now there a new function to check for that
Ardian Alikaj
-
- Posts: 3
- Joined: Mon Jun 02, 2008 1:35 pm
- OLAP Product: TM1, Jedox
- Version: TM1 10.2.2, Jedox 6
- Excel Version: Excel 2016
- Location: Budapest
Re: SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM
Thanx ardi, you save me lot of time.