TM1SET function - Any trick getting it to work?

Post Reply
JohnO
Posts: 92
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.9.x
Excel Version: Office 365 16

TM1SET function - Any trick getting it to work?

Post by JohnO »

https://www.ibm.com/docs/en/planning-an ... ons-tm1set

I am using PAW 84, PASS 83, PAfE .83 and am on local.

1) I have followed the above instructions.
2) I have tested the MDX,
3) The URI I used is the same as that generated in a Quick Report - I assume that is the correct thing to do.
4) TM1 Server, Dimension and Hierarchy names are all good.
5) I created the named range tm2\\_tracked as per instructions.

But nothing happens when I double click. No errors, just nothing.


Also as a point of interest it would seem this function can only be used in one range on a worksheet (Though I assume multiple times in that range) given the named range has to be applied to it.
Last edited by JohnO on Thu May 25, 2023 1:19 am, edited 2 times in total.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: TM1SET function - Any trick getting it to work?

Post by gtonkin »

Hi John, iirc, my connection in PAfE used the URI to the PASS server rather than the TM1 server and HTTPPortNumber.
The PASS "pass-through" was the missing link.
wcoffen
Posts: 4
Joined: Thu Aug 16, 2012 2:46 pm
OLAP Product: PA/TM1
Version: 2.0.9.17
Excel Version: 365

Re: TM1SET function - Any trick getting it to work?

Post by wcoffen »

John,

There was a defect once where if USESSL=F was in the config file, then it would fail. I believe 24Retail had USESSL=F set as shipped.

I'm not sure when (or if) that was corrected, but support told me about the defect in October 2022 around when TM1Set was first made available.
JohnO
Posts: 92
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.9.x
Excel Version: Office 365 16

Re: TM1SET function - Any trick getting it to work?

Post by JohnO »

wcoffen wrote: Wed May 24, 2023 1:46 pm There was a defect once where if USESSL=F was in the config file, then it would fail.
Thanks, but it is set to T
JohnO
Posts: 92
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.9.x
Excel Version: Office 365 16

Re: TM1SET function - Any trick getting it to work?

Post by JohnO »

gtonkin wrote: Wed May 24, 2023 8:18 am Hi John, iirc, my connection in PAfE used the URI to the PASS server rather than the TM1 server and HTTPPortNumber.
The PASS "pass-through" was the missing link.
Thanks, I tried but that didn't help.
JohnO
Posts: 92
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.9.x
Excel Version: Office 365 16

Re: TM1SET function - Any trick getting it to work?

Post by JohnO »

Though I had tested creating tm2\\_tracked as worksheet and workbook level it seemed I had ended up saving at workbook level. When I recreated at worksheet level it worked.

Apologies to all for wasting time.
Post Reply