Search found 258 matches

by BrianL
Wed Aug 23, 2017 3:17 pm
Forum: Cognos TM1
Topic: HierarchySize Function
Replies: 4
Views: 287

Re: HierarchySize Function

Have you tried passing 'DImensionName:HierarchyName' into DimSiz?
by BrianL
Wed Aug 23, 2017 2:50 pm
Forum: Cognos TM1
Topic: Trouble setting up integrated login in TM1 10.2
Replies: 16
Views: 1033

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: Cognos TM1
Topic: Tracking User Logins
Replies: 18
Views: 1759

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: Cognos TM1
Topic: TM1 Admin Server - Adjusting the default MTU of 1460
Replies: 5
Views: 222

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: Cognos TM1
Topic: DimensionDeleteAllElements failover
Replies: 14
Views: 955

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: Cognos TM1
Topic: Resolving Lock Contentions
Replies: 15
Views: 1298

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: Cognos TM1
Topic: does ODBCOutPut( ) wait for sql to finish
Replies: 1
Views: 276

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: Cognos TM1
Topic: TM1 cube cannot accept 0 (zero)
Replies: 6
Views: 389

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: Cognos TM1
Topic: Sandbox Transactions
Replies: 1
Views: 273

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=T (defaul...
by BrianL
Thu May 11, 2017 8:48 pm
Forum: Cognos TM1
Topic: TM1Top for Planning Analytics Local 2.0
Replies: 4
Views: 625

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: Cognos TM1
Topic: External access to TM1 cube via MDX
Replies: 9
Views: 1008

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: Cognos TM1
Topic: Calculate Time taken for a TM1 server between start and be ready
Replies: 5
Views: 644

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: Cognos TM1
Topic: CAM authentication 401 error - TM1 REST API
Replies: 6
Views: 922

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: Cognos TM1
Topic: CAM authentication 401 error - TM1 REST API
Replies: 6
Views: 922

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: Cognos TM1
Topic: TM1 Java HelloWorld App using TM1 API
Replies: 8
Views: 1582

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: Cognos TM1
Topic: ODBC Driver installation
Replies: 8
Views: 942

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: Cognos TM1
Topic: TM1 Java HelloWorld App using TM1 API
Replies: 8
Views: 1582

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?
by BrianL
Mon Apr 03, 2017 12:54 pm
Forum: Cognos TM1
Topic: ODBC Driver installation
Replies: 8
Views: 942

Re: ODBC Driver installation

You need to match the driver to TM1, so assuming you're running TM1 x64 you need the 64-bit Oracle driver Actually, IBM created a new 32bit proxy for 10.2.2, so this shouldn't be a concern - https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.doc/c_enable...
by BrianL
Fri Feb 17, 2017 3:39 pm
Forum: Cognos TM1
Topic: Real SSO with TM1Web Kerberos/Integrated Login
Replies: 10
Views: 852

Re: Real SSO with TM1Web Kerberos/Integrated Login

If you click on the community name, you get taken to https://www.ibm.com/developerworks/community/groups/service/html/communitystart?communityUuid=52c51723-5949-4a0c-b643-93dfff320fef From there under the files section you can find the .zip file. For convenience the direct link is https://www.ibm.co...