Issue using SUBNM in Excel

[Guillaume. B]

Hi guys,

I have problem using SUBNM in Excel 2010.
Here is my SUBNM formula : =SUBNM("SERVEUR:CUBE";"";"")

My problem is : sometimes when i use the subnm the subset editor opens but when i select an element and click "OK" nothing happens.
For exemple, i select the the "subset1" and click "ok", i expect that the 3rd parameter of my SUBNM become "subset1". Instead, the formula remains unchanged...

Any ideas ?

Thank you in advance

TM1 10.1.1 FPA
Excel 2010

[Christopher Kernahan]

Hi Guillaume,

1. Is the name of your dimension "CUBE"? If not, this should be a Dimension name.
2. There are semicolons in your formula. Unless this is an internationalisation thing, shouldn't they be commas?
3. If you manually type in the name of the element in the parameter, does the formula update or change behaviour?
4. Maybe include a screenshot of the formula.

[Guillaume. B]

Hi Christopher,
Thank you for your answer.

Here is my fomula : =SUBNM(Server&":"&$I$376;"";"")
1. The cell named "Server" contains the server name "SERVEUR_DEV" and the cell I376 contains my dimension name "z_Subsets_Indic_CM_Tech-Admin".
So my fomula is : =SUBNM("SERVEUR_DEV"&":"&"z_Subsets_Indic_CM_Tech-Admin";"";"")

2. There are other SUBNM in my application. They use semicolons and are functional.

3. If i manually type an element name in the formula then use the subnm it still didn't work. The formula returns to is basic form : =SUBNM(Server&":"&$I$376;"";"")

I noticed that if i use the TM1 method "TM1RECALC1", the subnm works. But i don't understand why some of them work without use this method.

[dymoy]

I believe you can't use cell references in SUBNM statements to identify the server and dimension, at least in v 9.5.2 Here's a quote from the section on SUBNM statements in the IBM Manual:

"Note: Do not use cell references as arguments with the SUBNM function. Cell references prevent the function from correctly calling and launching the Subset Editor when you double-click the cell that contains the SUBNM function."

[deepakjain2020]

Hi All,

Issue seems to be bit similar. Phrasing the issue

List of Subsets which are created manually and not exist as element in dimension.

• A

• B

• C

Subset C contains A and B subset with in it.

Excel worksheet uses function SUBNM, when user is selecting Subset A from Subset C. No data is populated in excel.
I have work around and found that SUBNM looks for the element in Subset.
Subset A becomes as an element in Subset C, but as it is not as an element in dimension data will not get populated

When user does the same through web, data is populated.

Can someone please share the reason why data is showing in web and not in excel worksheet for same scenario.


If any more information is required, please let me know.

Regards,
Deepak Jain