Search found 254 matches

by BrianL
Thu Jul 13, 2017 6:56 pm
Forum: Cognos TM1
Topic: DimensionDeleteAllElements failover
Replies: 14
Views: 650

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: 883

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: 196

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: 292

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: 192

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: 508

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: 784

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: 516

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: 655

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: 655

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: 1379

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: 702

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: 1379

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: 702

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: 721

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...
by BrianL
Wed Feb 08, 2017 1:40 pm
Forum: Cognos TM1
Topic: Please help with Expand Function
Replies: 14
Views: 801

Re: Please help with Expand Function

1. Believe it to be a standalone piece of java that doesn't require PAW, I think it has to be a fairly recent TM1 version or the correct API calls don't exist under the hood. I think it works with 10.2.2. (untested). So if you are on maintenance I guess you could download PA and just use the debugg...
by BrianL
Wed Feb 08, 2017 1:39 pm
Forum: Cognos TM1
Topic: Please help with Expand Function
Replies: 14
Views: 801

Re: Please help with Expand Function

But (and I'll be quite happy if I'm wrong about this) I don't believe that it allows you to step through AND edit the code AND dynamically assign values within a complete IDE in the style of Eclipse, the Visual Basic Editor, Visual Studio, etc, etc. Correct, it won't do that. Still I found it usefu...
by BrianL
Tue Jan 31, 2017 3:47 pm
Forum: Cognos TM1
Topic: TM1 Crashes
Replies: 14
Views: 669

Re: TM1 Crashes

AnonimusMax wrote:We are only using bulk load mode for an export to Oracle.
I've never heard of BLM being used for data export before. What's the reasoning?
by BrianL
Tue Jan 31, 2017 2:40 pm
Forum: Cognos TM1
Topic: TM1 Crashes
Replies: 14
Views: 669

Re: TM1 Crashes

Since crashing is pretty clearly a bug in the product, you'll find IBM to be the best resource for solving this. That being said, any chance you're using Bulk Load Mode at all for any of your data loads?