Search found 206 matches

by kangkc
Mon Oct 17, 2016 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

I patched up a CX 9.5 today. All components are working, Xcelerator as well as Web (.NET based). I believe your setup is a CX 10.1 as 10.2.2 is based on TM1 Enterprise image and no longer using CX manager etc. Manual steps for 10.1 should be the same as 9.5 as both TM1Web are .NET based. I suspect t...
by kangkc
Fri Oct 07, 2016 2:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 10.2 Integrated Login Kerberos setup
Replies: 46
Views: 49253

Re: TM1 Web 10.2 Integrated Login Kerberos setup

You can specify multiple TM1Web servers on a single Cognos BI Server. Just separate each server with a comma.
by kangkc
Thu Oct 06, 2016 5:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

For those who are still on 9.4 (for some reason), the new SSL certs issued by IBM will not work as in 9.4 the private key is encrypted using different cipher. Only way is to use custom certs. Just in case any of you still hanging on to 9.4. In here http://ibm.biz/TM1SSLCertificate There is a sectio...
by kangkc
Tue Oct 04, 2016 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

For those who are still on 9.4 (for some reason), the new SSL certs issued by IBM will not work as in 9.4 the private key is encrypted using different cipher.
Only way is to use custom certs. Just in case any of you still hanging on to 9.4.
by kangkc
Thu Sep 29, 2016 1:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

I am simulating the D-day by switching the clock ahead to 2017 and this is what we will be seeing (?) in the admin host debug log. Admin server will fail to start. Can anyone confirm this is the right steps to verify ? 5272 DEBUG 2017-09-29 00:58:55,708 TM1.Event mt_SetEvent: Set event 0x00000000000...
by kangkc
Mon Sep 26, 2016 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web 10.2.2 FP4 using SSL with default installed cert
Replies: 5
Views: 4385

Re: TM1Web 10.2.2 FP4 using SSL with default installed cert

If you do not have a JAVA_HOME define, you shouldn't encountered this issue. Else just look under IBM provided JRE and locate the mentioned jar and copy that to where you define the JAVA_HOME.
If possible, don't define any JAVA_HOME and leave that to the default setup by the TM1 installer.
by kangkc
Tue Sep 13, 2016 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

Yes. We have tested it. All services have to be stopped before V2 certs configuration. And of course Admin server has to be up first before all TM1 instances once V2 certs are done. The client side will be client by client.
by kangkc
Thu Sep 08, 2016 12:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 10.2 Integrated Login Kerberos setup
Replies: 46
Views: 49253

Re: TM1 Web 10.2 Integrated Login Kerberos setup

In your BI install, did you include Content Database ? Suggest you include this with the default content database before you switch to other RDBMS. We have gone through many CAM (with AD) integration with 10.2.2 and enabling TM1 Application Servers with 3rd party SSL certs. Not exactly smooth nor ea...
by kangkc
Mon Sep 05, 2016 12:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

You can only set to use ONLY SSL client (False) or both Non-SSL and SSL (True).
Doesn't seems to have a way to disable SSL totally.

At the moment installing V2 certs seems to be the only way before a new 1024 certs are made available via fix.
by kangkc
Fri Sep 02, 2016 6:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 123370

Re: SSL breaks on Nov 24

On second thought UseSSL=F may not work as Admin server may not able to function due to expired cert.
by kangkc
Wed Aug 17, 2016 12:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirosoft Visual Basic Error
Replies: 14
Views: 10776

Re: Mirosoft Visual Basic Error

Is the workbook/worksheet protected? If so remove the protection and see if that resolved the issue.
There is an issue with protected worksheet with Perspective and Excel.
by kangkc
Wed Aug 10, 2016 7:34 am
Forum: Commercial and Events
Topic: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik
Replies: 21
Views: 75486

Re: TM1 Gateway support SSRS

We have just validated the support for SQL Reporting Services (SSRS) with our TM1 Gateway.

See it in action on Youtube:

https://youtu.be/cDjpXU0M-ak
by kangkc
Tue Aug 09, 2016 1:53 am
Forum: Commercial and Events
Topic: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik
Replies: 21
Views: 75486

Re: TM1 Gateway now support Power BI Drill down

We have just added the capability of drill down with our TM1 Gateway in Power BI using the In-line Hierarchy which is currently a Preview features in Power BI.
You can see it in action at

https://www.youtube.com/watch?v=I4fb57rpuBs
by kangkc
Wed Apr 27, 2016 2:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI on the Cloud
Replies: 16
Views: 10344

Re: TM1RunTI on the Cloud

Using REST API to execute TI on the cloud instance from user location may be another feasible option. REST API http port is opened on the cloud.
by kangkc
Mon Mar 28, 2016 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - Public URL
Replies: 4
Views: 3075

Re: TM1 - Public URL

I think your problem is the redirecting URL as highlighted: ../planning.html&ps= http%3A%2F%2Fwebserver%3A9510 &pg=%2Fapplications.jsp" which translate to http://webserver:9510 From the public it will not be able to reach this URL. This is specified in the planning.html under Cognos BI.
by kangkc
Mon Mar 28, 2016 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web 10.2.2 FP4 using SSL with default installed cert
Replies: 5
Views: 4385

Re: TM1Web 10.2.2 FP4 using SSL with default installed cert

Found the problem after 1 week of testing and researching. I can confirm that 10.2.2 FP4 break the Application Server SSL and this is consistent after testing with 3 newly installed servers. I updated it with FP5 and this seems to resolve the application server startup problem but it hit another Jav...
by kangkc
Mon Mar 21, 2016 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web 10.2.2 FP4 using SSL with default installed cert
Replies: 5
Views: 4385

TM1Web 10.2.2 FP4 using SSL with default installed cert

Has anyone managed to setup TM1Web 10.2.2 (FP4) with SSL using default installed cert. IBM has a short article on how to enable TM1Web with SSL with external certs but there isn't much discussion on using the default installed certs. I did a java keystore check and confirm the default certs are inst...