Wednesday 20 May 2015

TM1 REST API

TM1 REST API is a great enhancement for TM1.
You can develop lots for own applications using this API. And most beautiful thing is they can be cross TM1 servers! The current TM1 interfaces(Perspectives and Architecture), I have to say, are ugly and difficult to use, especially when you want to exchange data between two servers.
I know tm1runti command and already developed TI processes to transfer data between servers.
TM1 REST API provides a new way to communicate with TM1 server.

I plan to use this to develop a new tool for managing chores, migrating objects, etc.

Looking forward to hoping IBM to make this API stronger to replace the original out-of-date API.

https://www.ibm.com/developerworks/community/groups/community/TM1SDK



Sunday 1 February 2015

Tips for installing Cognos 10.2 64-bit on Windows 7 64-bit

1. Make sure you install all supported software which is listed by IBM report, especially for JDK, version of content store DB and web servers etc. Latest software will cause some unexpected errors. E.g. dynamic query service can't be enabled when using JDK 8 on Cognos 10.2.

2. Make sure all software you installed is in same language, especially for Cognos server itself. Better to have English as default language by changing this setting
IBM Cognos Configuration -> Opertation -> Edit Global Configuration -> General -> Server Language Env = en if you see this error in the cognos server log. "CBSServiceStatusUpdater reached time limit, final status is 2"

3. Make sure Oracle character set is AL32UTF8 and language in AMERICAN if you use Oracle as content store. You can use DBCA to drop or recreate DB and grant DBA to content store user.

4. Follow the links below to finish installation and configuration.

5. Allocate more RAM to Java Virtual Machine if see this error in Event Viewer.
"Could not create the Java Virtual Machine"

6. If you see "QE-DEF-0368" when using FM to connect any source for publishing. Check the link below.