Search found 52 matches

by bihints.com
Wed Nov 14, 2012 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple EXCEL.EXE *32 processes running after a while
Replies: 7
Views: 3916

Re: Multiple EXCEL.EXE *32 processes running after a while

beckersbest wrote: However is there a 3rd party tool to just terminate all EXCEL.EXE *32 processes from time to time (e.g. using the task scheduler at 11pm every day)?
in the prolog of a chored process:
ExecuteCommand('cmd /c taskkill /F /IM excel.exe',0);
by bihints.com
Tue Jan 24, 2012 3:02 pm
Forum: Useful code, tips and tricks
Topic: TM1 Data Directory Compare Tool
Replies: 7
Views: 3033

Re: TM1 Data Directory Compare Tool

winmerge also displays differences between the files side by side, highlighting the chunks of code that differ.

or simpler, no installs required:
DOS: xcopy /L can list what files may need to be copied.
bash: rsync -anuve
by bihints.com
Tue Jan 24, 2012 1:38 pm
Forum: Useful code, tips and tricks
Topic: TM1 Data Directory Compare Tool
Replies: 7
Views: 3033

Re: TM1 Data Directory Compare Tool

windows: http://winmerge.org/
linux: diff -qr dirA dirB
by bihints.com
Tue Nov 08, 2011 5:50 pm
Forum: Useful code, tips and tricks
Topic: Documentation Deficiencies
Replies: 19
Views: 12407

Re: Documentation Deficiencies

Ironically, the SwapAliasWithPrincipalName trick, that has been going around the blogs since last year, has just been posted on the official IBM technotes: http://www.ibm.com/support/docview.wss?uid=swg21571068 A few years ago, I suggested to one Applix support manager of the time that it could be u...
by bihints.com
Tue Oct 26, 2010 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cognos 10 Launch announced
Replies: 16
Views: 3519

Re: IBM Cognos 10 Launch announced

I only caught the tail end of it. The only mention of TM1 I heard was that it ran 80% faster under Cognos 10 that Cognos 8. In general it is much faster. According to @GregBonnette 's tweet http://twitter.com/GregBonnette/status/28731360993 : OH in Q&A: 80% Performance improvement in #Cognos10 vs. ...
by bihints.com
Mon Oct 11, 2010 10:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 processes
Replies: 5
Views: 660

Re: Tm1 processes

install http://www.wingrep.com, then run a search for the name of the cube in all .pro and .rux files in your TM1 data folder.
It will return all references to the cube, unless the name is held in a control cube.
by bihints.com
Wed Sep 29, 2010 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View takes an hour to appear
Replies: 9
Views: 3687

Re: Cube View takes an hour to appear

2. I inherit the cube from someone who left, the cube does have some crazy and serious conditional rules, total 160 lines ... Now with the change of "MaximumCubeLoadThreads", the system seems to be much more stable, the tm1sd.exe remains at 9-10 G even after the restart, thus I do not have to manua...
by bihints.com
Tue Aug 17, 2010 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT - Columns Headings
Replies: 4
Views: 3320

Re: ASCIIOUTPUT - Columns Headings

set a flag in the prolog, test it, then change its value once you passed your columns headings.
example:

PROLOG TAB:

Code: Select all

header = 1;
DATA TAB:

Code: Select all

if(header = 1);
    asciioutput(file,'my,columns,headings');
    header = header - 1;
endif;
by bihints.com
Wed Feb 24, 2010 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Blueprints
Replies: 14
Views: 4911

Re: IBM Blueprints

the forms can be skipped and the "meat" is to be found directly at this link (no forms / multiple sign-ins / download manager nonsense): http://download.boulder.ibm.com/ibmdl/pub/software/data/sw-library/cognos/datamodels/ http://download.boulder.ibm.com/ibmdl/pub/software/data/sw-library/cognos/pdf...
by bihints.com
Wed Feb 24, 2010 8:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get Usergroup within TI
Replies: 5
Views: 1390

Re: How to get Usergroup within TI

Either . create a view from the cube }ClientGroups and import it in TI or .loop through all elements of the }Groups dimension for a given user: user = 'john.doe'; i = DIMSIZ('}Groups'); while(i > 1); group = DIMNM('}Groups', i); if(CellGetS('}ClientGroups',user,group) @= group); #insert code here to...
by bihints.com
Wed Oct 14, 2009 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express install error:SDK-ERR-0034
Replies: 4
Views: 3638

Cognos Express install error:SDK-ERR-0034

Hi, I'm not sure if this is the right forum to post as there are no dedicated forum for Cognos Express (yet). Well, I managed to go through the maze of multiple pages of logins, forms, licenses agreements, and failed download manager, to get to the actual download link of the 1.5GB install zip for C...
by bihints.com
Tue Oct 13, 2009 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automation of Excel TM1 Based Reports
Replies: 15
Views: 4027

Re: Automation of Excel TM1 Based Reports

Hi Jim, I have put together some VBA code that reads from a TM1 cube what reports to update, where to save them, whom to email/notify it or print. All entries are consolidated into rollups such as "Monday" "Tuesday" etc.. So the script runs only the reports on the given days specified. So I do not n...
by bihints.com
Fri Sep 11, 2009 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM/COGNOS Pain
Replies: 34
Views: 5155

Re: IBM/COGNOS Pain

I think you can only partially blame IBM for that, i.e. I agree that any new release should be officially supported for a longer period than is currently the case. The other part of the blame should be on stupid internal IT policy. well we can't say IBM is making it easy. .they do not keep 9.0 supp...
by bihints.com
Fri Sep 11, 2009 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM/COGNOS Pain
Replies: 34
Views: 5155

Re: IBM/COGNOS Pain

sorry, I just went through our IBM/Cognos quotes again after some of the feedback here. I didn't see the lines in small characters at the bottom of our last year fees quote claiming it is VAT free :P . typical. So the increase is "just" 10%. Though the fact remains we are still pushed to upgrade to ...
by bihints.com
Fri Sep 11, 2009 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM/COGNOS Pain
Replies: 34
Views: 5155

Re: IBM/COGNOS Pain

As a side thought is there anything in the legals of the maintenance contract that means the money paid to IBM most be spent on TM1? Obviously not a problem when it was Applix since they only had 1 product but with IBM the money could just disappear and be spent on anything. Mind you getting to pay...
by bihints.com
Thu Aug 20, 2009 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Applix 9.4 FP2
Replies: 18
Views: 5995

Re: Applix 9.4 FP2

On the other hand, TM1 customers shouldn't need to rely on other Forumers to let them know when a new version is out. Guess IBM'll figure that one out after the survey. Or not. They sort of did already. There's an RSS feed at http://www-01.ibm.com/software/support/rss/db2/3446.xml?rss=s3446&ca=rssd...
by bihints.com
Thu Aug 13, 2009 9:50 am
Forum: General
Topic: Asia Pacific User Conference in 2009?
Replies: 11
Views: 3989

Re: Asia Pacific User Conference in 2009?

So who turned up there? official site http://www-01.ibm.com/software/au/data/cognos/forum2009/ and the sessions program http://download.boulder.ibm.com/ibmdl/pub/software/au/downloads/IBM_Cognos_Forum_Agenda.pdf a few people currently tweeting on #ibmcfap http://search.twitter.com/search?q=TM1+%23ib...
by bihints.com
Thu Jul 09, 2009 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running chores on a given day every month
Replies: 6
Views: 1059

Re: Running chores on a given day every month

Why not set Windows scheduled tasks of your server to run the TM1ChoreExecute.exe available in the tools section of the forum?
by bihints.com
Wed Mar 04, 2009 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ObjectDuplicate client lock
Replies: 14
Views: 2018

Re: ObjectDuplicate client lock

Thanks for the update bihints, Have you tried to get any background on the issue from IBM? I think 9.0 is still on active support so they might be more inclined to help. yes I opened a request after noticing this thread, though it looks like a dead end. They claim it is a Citrix issue but I manage ...