Search found 222 matches

by Paul Segal
Thu Jul 20, 2017 7:06 am
Forum: Cognos TM1
Topic: Connecting with Integrated Login using VBA
Replies: 7
Views: 501

Re: Connecting with Integrated Login using VBA

Are you on IntegratedSecurityMode = 2? If so, this will work

Code: Select all

Application.Run("N_CONNECT", "YourServer", "","")
Otherwise look at this thread http://www.tm1forum.com/viewtopic.php?t=765
by Paul Segal
Tue Jul 18, 2017 9:26 am
Forum: General
Topic: Upcoming server migration
Replies: 14
Views: 1158

Re: Upcoming server migration

Hi Martin,

Advertising seems to be working, but I don't appear to be getting emails from the forum. Not that there's a rush...

While I'm here, thanks for the work and effort you put into this.

Best

Paul
by Paul Segal
Wed Jul 05, 2017 5:19 am
Forum: Cognos TM1
Topic: PAX for Excel 2013 is Slow Slow Slow
Replies: 1
Views: 230

Re: PAX for Excel 2013 is Slow Slow Slow

I've been doing some testing on PAX, on 2013 and 2010, and I don't get this behaviour. You may want to get the latest Fix Central versions of PAx and PAW: https://www-01.ibm.com/support/docview. ... wg24043782
by Paul Segal
Tue Jun 27, 2017 11:51 am
Forum: Cognos TM1
Topic: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM
Replies: 1
Views: 164

Re: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

For anyone interested this is a bug, and a fix is in the pipeline - PI83093 DROPDOWN ARROW FOR A SUBNM CELL DISAPPEARS WHEN SHEET ISPROTECTED (EVEN IF CELL IS SET TO BE UNLOCKED) - although no date for it yet.
by Paul Segal
Thu Jun 22, 2017 9:28 am
Forum: Cognos TM1
Topic: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM
Replies: 1
Views: 164

Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Protecting a sheet in Excel and then unprotecting a cell in the sheet that has a (vanilla) SUBNM formula appears to break the SUBNM formula - I can pick a new element from the set editor, but the cell drop down doesn't appear and the SUBNM cell is not updated with the new element when it's selected ...
by Paul Segal
Thu Jun 15, 2017 2:19 pm
Forum: Cognos TM1
Topic: Error accessing set editor from PAx
Replies: 5
Views: 212

Re: Error accessing set editor from PAx

Well, I've fixed it, but not cured it. I had the http port set to 8080 on the PAW start.bat rather than 80 as there was something else on 80. I've got rid of the something else and rebuilt PAW using port 80 and it now works. Thanks for the help though, Steve.
by Paul Segal
Wed Jun 14, 2017 4:21 pm
Forum: Cognos TM1
Topic: Error accessing set editor from PAx
Replies: 5
Views: 212

Re: Error accessing set editor from PAx

I did (I'm pretty sure). I get the PAW-like logon screen, which works and lets me in.
by Paul Segal
Wed Jun 14, 2017 2:19 pm
Forum: Cognos TM1
Topic: Error accessing set editor from PAx
Replies: 5
Views: 212

Re: Error accessing set editor from PAx

It doesn't look like that's it - IE11 is installed, and I've even made it default now. I still get the same result.

Thanks
by Paul Segal
Wed Jun 14, 2017 1:47 pm
Forum: Cognos TM1
Topic: Error accessing set editor from PAx
Replies: 5
Views: 212

Error accessing set editor from PAx

Anyone else come across this? Everything else seems to be working OK. This is accessing GO_New_Stores, so should be fairly standard.
Capture2.PNG
Capture2.PNG (44.09 KiB) Viewed 212 times
by Paul Segal
Tue May 23, 2017 10:29 am
Forum: Cognos TM1
Topic: TM1 cube cannot accept 0 (zero)
Replies: 6
Views: 298

Re: TM1 cube cannot accept 0 (zero)

The short answer is yes, TM1 can "move" a 0 from one cube to another without using a zero out function. We really need more detail of what you're doing and how you're doing it to provide any assistance. It would be useful if you could read the forum guidelines and put your question with them in mind.
by Paul Segal
Tue May 23, 2017 7:07 am
Forum: Cognos TM1
Topic: TM1 cube cannot accept 0 (zero)
Replies: 6
Views: 298

Re: TM1 cube cannot accept 0 (zero)

It's difficult to be sure without more specifics, but it's possible that in your scenario 3 the view used has zero suppression turned on, in which case the behavior is as expected. Normally the best option is to zero out the receiving cube, or relevant portion thereof, and then do the move/copy, but...
by Paul Segal
Thu May 18, 2017 10:44 am
Forum: Cognos TM1
Topic: TI Process Error
Replies: 11
Views: 918

Re: TI Process Error

MyVariable is definitely a string, right?
by Paul Segal
Fri Apr 28, 2017 6:54 pm
Forum: Cognos TM1
Topic: Calculate Time taken for a TM1 server between start and be ready
Replies: 5
Views: 535

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

Powershell is your friend here: start the TM1 service using a powershell script which writes a time-stamp to a file, then performs a start-service on your tm1server. Once the server is up read the file with the time-stamp into TM1 as part of the startup chore as outlined by Tom and you have your ans...
by Paul Segal
Wed Apr 26, 2017 8:40 am
Forum: Cognos TM1
Topic: cool TI Editor - where to buy?
Replies: 5
Views: 616

Re: cool TI Editor - where to buy?

Give Cubewise a call - they're normally quite receptive to people wanting to spend money with them.
by Paul Segal
Mon Apr 24, 2017 10:57 am
Forum: Cognos TM1
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 700

Re: Sublime Text TM1 syntax highlighter

Did you install RegReplace? This is required for the convert bit to work.
by Paul Segal
Mon Apr 24, 2017 6:55 am
Forum: Cognos TM1
Topic: Sublime Text TM1 syntax highlighter
Replies: 6
Views: 700

Re: Sublime Text TM1 syntax highlighter

This will be in your user directory settings, so for me this is c:\users\psegal\appdata\roaming\sublime text 3\packages\user. Obviously you need to change as appropriate for your username etc.
by Paul Segal
Mon Apr 10, 2017 8:33 am
Forum: Cognos TM1
Topic: TM1 10.2.2 FP6 IF1 crashing without log entries
Replies: 10
Views: 662

Re: TM1 10.2.2 FP6 IF1 crashing without log entries

Presumably you've checked available disk space?
by Paul Segal
Mon Apr 03, 2017 2:00 pm
Forum: Cognos TM1
Topic: TM1 10.2.2 Fix Pack 7 delayed
Replies: 11
Views: 1320

Re: TM1 10.2.2 Fix Pack 7 delayed

Fix pack 7 appears to be available now: http://www-01.ibm.com/support/docview.w ... wg24043147