Search found 261 matches

by BrianL
Fri May 25, 2018 3:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 8986

Re: Parallel run vs. ICX

This sounds like a good use case for the TI debugger. If you're running 10.2.2 FP7 or newer you can set a breakpoint in the debugger on the IX lock acquisition. This should help you understand what TI code is causing the lock.
by BrianL
Fri May 25, 2018 3:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting started with REST API (issue)
Replies: 8
Views: 4917

Re: Getting started with REST API (issue)

What is the UseSSL setting in the tm1s.cfg? If it's set to T you'll need to use httpS instead of http.
by BrianL
Wed Dec 20, 2017 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone used TurboDebugger with PA?
Replies: 1
Views: 2022

Re: Anyone used TurboDebugger with PA?

I've been told that PA environments require an automation account to work with the TurboDebugger tool. If you use java -jar TurboDebugger.jar to run the debugger, do you see any error messages output to the java console? If you're using an older version of the debugger and simply double clicking the...
by BrianL
Wed Aug 23, 2017 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySize Function
Replies: 4
Views: 3582

Re: HierarchySize Function

Have you tried passing 'DImensionName:HierarchyName' into DimSiz?
by BrianL
Wed Aug 23, 2017 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Trouble setting up integrated login in TM1 10.2
Replies: 16
Views: 13109

Re: Trouble setting up integrated login in TM1 10.2

Looking at the error message, port 5498 is the admin server port. Looks like the web sso component is trying (and failing) to connect to an admin server on the machine that's running TM1Web. If that's where you expect the admin server to be, check that there's no firewall blocking access.
by BrianL
Wed Aug 23, 2017 1:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracking User Logins
Replies: 19
Views: 21684

Re: Tracking User Logins

I believe the TM1.Login logger was first made available in 10.2.2 FP1. Anything earlier than that will not create any login log entries.
by BrianL
Tue Aug 01, 2017 6:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Admin Server - Adjusting the default MTU of 1460
Replies: 5
Views: 4080

Re: TM1 Admin Server - Adjusting the default MTU of 1460

To the best of my knowledge it's not actually configurable.

However, the admin server is really only used for discovery. Login and all other operations are done directly with the TM1 Server and do not pass through the admin server in any way.
by BrianL
Thu Jul 13, 2017 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionDeleteAllElements failover
Replies: 14
Views: 10277

Re: DimensionDeleteAllElements failover

I know I'm a bit late to the party, but I think it's also worth noting that as of PA 2.0 you can explicitly ask TI to rollback and discard all work. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_processrollback.html You'd still ha...
by BrianL
Tue Jun 06, 2017 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Resolving Lock Contentions
Replies: 15
Views: 12458

Re: Resolving Lock Contentions

All that to ask this: why is a read on a cube containing the counter dimension preventing modifications to another dimension? And by the way, this runs fine IF instead of using TM1RunTI, ExecuteProcess is used OR the environment for the -connect parameter is hard-coded to avoid reading the }System_...
by BrianL
Thu May 25, 2017 5:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: does ODBCOutPut( ) wait for sql to finish
Replies: 1
Views: 2306

Re: does ODBCOutPut( ) wait for sql to finish

AFAIK the only thing asynchronous in TI is ExecuteCommand when using zero for the Wait parameter.

You can easily test this out. Use the LogOutput function to write to the message log before and after the OdbcOutput call. You'll see timestamps next to the log messages.
by BrianL
Tue May 23, 2017 12:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube cannot accept 0 (zero)
Replies: 6
Views: 4096

Re: TM1 cube cannot accept 0 (zero)

It's also worth noting that by default, TM1 doesn't store zero values and considers a cell containing zero to be empty. You can change this behavior on a per-cube basis by adding the UNDEFVALS keyword to the cube rule.
by BrianL
Mon May 15, 2017 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandbox Transactions
Replies: 1
Views: 2137

Re: Sandbox Transactions

Yes, sandbox transaction logs will be written out when the cube has logging enabled. Each sandbox has its own transaction log. They will show up in the "<LoggingDirectory>\sandboxlogs\<client_name>\<sandbox_index>\" folder. There is also a global tm1s.cfg option EnableSandboxTransactionLog...
by BrianL
Thu May 11, 2017 8:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Top for Planning Analytics Local 2.0
Replies: 4
Views: 4578

Re: TM1Top for Planning Analytics Local 2.0

TM1Top should still work. Is it not part of the server install?

If you try to use a 10.2.2 version of tm1top, I believe there are (at least) new SSL certificates required.
by BrianL
Wed May 10, 2017 5:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: External access to TM1 cube via MDX
Replies: 9
Views: 6992

Re: External access to TM1 cube via MDX

While I haven't used it personally, there is an ODBO provider that gets installed with TM1.

A quick google of "tm1 odbo" is enough to show this.

http://www-01.ibm.com/support/docview.w ... wg21406989
by BrianL
Fri Apr 28, 2017 7:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate Time taken for a TM1 server between start and be ready
Replies: 5
Views: 4194

Re: Calculate Time taken for a TM1 server between start and be ready

You could also try using the StartupChores config option to run your chore as the very last step in server startup. This would eliminate the need to schedule the chore to run every minute.
by BrianL
Thu Apr 20, 2017 3:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAM authentication 401 error - TM1 REST API
Replies: 6
Views: 9071

Re: CAM authentication 401 error - TM1 REST API

I'm not sure the code is your problem. I have been working on this as well for a development project. I spoke with Guido at IBM offering management and he confirmed the only way to access Planning Analytics (cloud) from the REST API is with non-interactive user accounts . I'm assuming that 'Administ...
by BrianL
Wed Apr 19, 2017 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAM authentication 401 error - TM1 REST API
Replies: 6
Views: 9071

Re: CAM authentication 401 error - TM1 REST API

Someone else has asked this question on the IBM DeveloperWorks site. https://www.ibm.com/developerworks/community/forums/html/topic?id=208fc28e-33e7-4802-85a2-6e0bc02186ca The answer appears to be I have been working on this as well for a development project. I spoke with Guido at IBM offering manag...
by BrianL
Mon Apr 03, 2017 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java HelloWorld App using TM1 API
Replies: 8
Views: 6991

Re: TM1 Java HelloWorld App using TM1 API

That might be your problem then. Does the code work if you run with the IBM JRE?
by BrianL
Mon Apr 03, 2017 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Driver installation
Replies: 8
Views: 7082

Re: ODBC Driver installation

mattgoff wrote:...if the matching driver is available you should really use that. A proxy layer should be a last resort to be used only if the matching driver isn't available.
Agreed.
by BrianL
Mon Apr 03, 2017 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java HelloWorld App using TM1 API
Replies: 8
Views: 6991

Re: TM1 Java HelloWorld App using TM1 API

LutherPaul wrote: System.setProperty("com.ibm.jsse2.overrideDefaultProtocol", "TLSv1.2");
That looks like an IBM specific property. Are you using the IBM JRE (as installed by TM1) or an Oracle JRE?