TM1 Forum

hi All, We use 10.2.2 with fix pack 6 and excel is 32 bit office 365. Server is hosted on 2012 R2. I am trying to understand usage of CubeUnload function. I am struggling to understand in which scenario I should be using CubeUnload() function. Whenever I perform CubeUnload on any cube, TM1Instance o...

Thanks for the reply JWilkins, It might be worth noting that the SSL version was changed in FP6 and by default older clients (using the older SSL version) are blocked from connecting. You can enable support for older clients with the SupportPreTLSv12Clients tm1s.cfg parameter. Just to let you know t...

Thanks for a quick reply Declanr, Those are perspective reports. We can certainly run from client machine, but we dont want to put it on them yet, may be later. I will certainly give a try to copy the bin folder of 10.1 and try to use its tm1p.xla file and see how it can connect to both the instance...

Thanks Declanr for your reply. You can have multiple clients installed on 1 machine but its gets very messy so I wouldn't recommend that. With above quotes, Can I install 10.1 client in my TM1 server where TM1 10.2.2 FP6 is installed? (by making sure that, installation folders are different for both...

hi All, This is regarding the TM1 backward comparability issue. Recently we upgraded to 10.2.2 with Fixpack 6. Architect of 10.2.2 FP6 server also has an adminhost of 10.1. The problem that I saw was, when I try to connect to TM1 instances which are running of 10.1 TM1 Server then it gives me an err...

Alright Guys, Let me give some more insights... I turned PersistentFeeder ON, I didnt find any reduction in the RAM Size, but then I restarted the TM1 Instance, and then it came up in very short time and RAM consumption reduced to 57% from 99%. I then loaded one of the yearly file and monitored the ...

hi All, I am in a process of upgrading the TM1 10.1 to 10.2.2 FixPack5. We have got a newTest box on which we have 10.2.2 installed. We are planning to bring TM1 Instance running on Prod into newTest Box and see whether we face any issues or not. Below are the specification of servers. newTest Box: ...

Hi All, I have a situation here, I am trying to call TM1p.xla file from VBA Macro, so that I can use "N_Connect" function to connect to TM1 Instances. I am doing all of these on following System User: Administrator OS: Windows 2012 R2 Standard Edition 64 Bit TM1: 10.2.2 FixPack 5 64Bit and...

hi All, I installed TM1 10.2.2 (64Bit) on Server ABC which is running on Windows Server 2012 R2 operating System. Currently default sample TM1 instances running on it. I am able to see TM1 instances via Architect/Perspective on the machine where TM1 is installed. The problem comes up when I add serv...

hi All, My objective is to open an Excel ActiveForm using .VBS Script As soon as Excel Activeform is opened, Following VBA code will run. NOTE: All Macros are enabled in Excel Trust Center Settings Private Sub workbook_open() Workbooks.Open ("C:\Program Files\ibm\cognos\tm1_64\bin\tm1p.xla"...

hi TM123,

I also came across this issue couple of days back when I was creating Websheets on TM1 10.2.2.
The workaround is simple, use DBR function within the Success and Failure input message box. Like Below.
For me it did work. You can give a try. This should work.

CiPH3R.

Thanks a lot Lotsaram and Michel for the responses. This really helps guys!!!

HI All, I am creating an Active Form report in TM1 Perspective version 10.2.2. My Active Form reports looks like below. img1.jpg My issue is specific to drilldown/Expand feature. When I expand All Cost Center just for 41 element, then it behaves weird. It expands All Cost Center for all the elements...