TM1 Forum

Look at TM1 manual, it's specifically mentioned that you CAN'T insert objects like Chart. " When you insert an Active Form in a worksheet, the form ’owns’ all rows that are required to display the form. You cannot insert additional data or objects (such as charts or images) in any row that ...

You may have a corrupted or missing subset somewhere.

SKIPCHECK; ['kangkc']=['kc_kang']; FEEDERS; ['kc_kang'] => ['kangkc']; In your case I would have created an alias - I really hate having hundreds of elements mirroring each other using rules :) (So I could never work at government agency where one might be able to change his or her name (honestly, ...

SKIPCHECK;;
['kangkc']=['kc_kang'];

FEEDERS;
['kc_kang'] => ['kangkc']




I used a fair bit of ExecuteCommand in my consultancy work involving TM1, and there are many possibilities in process automation. TI is a very dynamic and yet simple ETL tool.

No no no...

This is not the right way to call VBScript from TI.

ExecuteCommand will need to call a exe or a cmd, bat file. It can't execute a VBS directly.

Do this instead to execute VBS:

ExecuteCommand('C:\windows\system32\cscript.exe D:\ErrorEmail2.vbs',1);

Check whether you have done these: 1. Create a drill through process xxxx (the actual TI process will be named as }Drill_xxxx, and can only view when you turn on View control objects) 2. Create a drill through assignment rule and relate the process defined to the rule as in xxxx (and not }Drill_xxxx)

No worry.

Just found that MS released another ActiveX Killbits, KB973346. I would try to avoid this till I have time to test it out.

You don't need to use "IF" looking at your logic, just use the "\" instead of "/"

TM1 rule will handle it well. See the rule guide:

\ (back slash) - Same as / (forward slash), but returns zero when you divide by zero, rather than an undefined value.

A few other things before testing:

1. The unique id username@domain under NTLM works for me for a few install sites. You may need to play around with the unique id.
2. Make sure the server is joined to the domain (ie has a valid computer account in the domain tree). This is a must.

Good luck.

On X64 installation, PDFCamp driver is not installed by default. You can log a call to IBM to request for it or you can contact me offline.

If you can afford to down the server to do a quick test, switch the SecurityPackageName to NTLM and try it. This may not solve it if you need to use kerberos for some reason but at least help to isolate the problem. I have experience issue with Kerberos before and it get worse when I need to get TM1...

Definitely, running under domain account will always be the preferred setup. Anyway, it's off topic for this thread. See if the originator of this thread can provide the cfg configuration. Need to see if it's using NTLM or Kerberos.

No, TM1 service does not need to be started under a domain account. Please check whether the server is joined to the domain? If so you can start up TM1 service under local system account and Integrated Login will still work. I have done this many times and it should work. Can you post your tm1s.cfg ...

Er.....I'll do it via subset for specific requirement on order. It's too tedious to play around with indexes which can be easily re-arrange via subset.

Seems like you have NOT set up the user -> Windows Account in your TM1 server. Have you tried using integrated login with TM1 client? If TM1 client can't log you in, you have not setup integrated login correctly..yet...

For interest of other. We managed to find out the cause. For some reason the root ca certificates get imported partially. The revocation list didn't get imported hence the problem.

We just upgraded from TM1 9.0SP3 to 9.1.4 (9.1SP4). All 9.0SP3 clients and 9.1.4 clients can connect to the new server. However we are having problem with TM1 Web. Digging further into the tm1web log, we found that it seems to be a SSL error communicating with the Admin SSL. Both the TM1 admin serve...

Works fine here with 9.4.1 and Excel 2007.
Is your admin server started?

Hi, To enable workflow, you will need all the workflow objects to be placed in the cube directory in order to start defining all the workflow thingy. Under default installation, you should see a directory in the Custom folder "TM1 Planning Manager V2" (may change based on release). Copy al...

Hi, You can do Chinese characters in pre 9.4 release of TM1. The catch is you have to be on the respective language OS to enter the characters. In your case will be Chinese OS. Aliases can be entered under the Chinese OS in Chinese and excel templates etc will display correctly. However when reading...