Search found 54 matches

by wissew
Tue Jan 31, 2017 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Session Timeout when exporting Websheet
Replies: 2
Views: 2191

Re: Session Timeout when exporting Websheet

Ty,
I hope you've had the user clear their browser cache and delete their history. I know it sounds basic but sometimes we forget to try these steps.

Wes
by wissew
Wed Apr 06, 2016 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Scheduled Reports
Replies: 3
Views: 3245

Re: Scheduled Reports

Workarounds: There are several different possible workarounds: Remember, these are possible workarounds. The best solution is to use Excel 2013. I had used Method #1 in a prior role and that resolved it in Excel 2007. If you can't upgrade the existing server, Run it from the replicated environment
by wissew
Wed Apr 06, 2016 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Scheduled Reports
Replies: 3
Views: 3245

Re: Scheduled Reports

Sounds like you are hitting everything correctly. When you launch Excel do you have Perspective launch without any macro messages and see the IBM splash screen? I am assuming you have perspectives added as a addin to Excel and macro security is se to low. Have you gone into the Excel trust center se...
by wissew
Tue Sep 15, 2015 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 Fix Pack 4 - Temporary Objects in TI
Replies: 25
Views: 18305

Re: 10.2.2 Fix Pack 4 - Temporary Objects in TI

Has anyone tested this in real life yet? What's the feed back on it?
by wissew
Tue Dec 16, 2014 3:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Element with Null Value
Replies: 3
Views: 3713

Re: Dimension Element with Null Value

Lee,
Another approach would be to use the nvl funcion in sql to populate the nulls with you default element to eliminate any evaluations in Ti. ie NVL(FieldName, 'Not Available')
by wissew
Tue Feb 04, 2014 7:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBSS Not functioning in TM1Web 10.2
Replies: 3
Views: 3638

Re: DBSS Not functioning in TM1Web 10.2

I found out that it is in the IF for FP1 and should be out this week.
by wissew
Tue Feb 04, 2014 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBSS Not functioning in TM1Web 10.2
Replies: 3
Views: 3638

DBSS Not functioning in TM1Web 10.2

I have a client that has a string cell referenced in a bdss on a web sheet. It is visually behaving as it should in the web. The target cell is changing color after recalc but the data is not being set to the cube nor is it displaying in the dbss. Is anyone else experiencing this? Any work arounds k...
by wissew
Tue Sep 10, 2013 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2 Available for Download
Replies: 82
Views: 73090

Re: TM1 10.2 Available for Download

Has anyone gotten Performance Modeler 10.2 to work?
by wissew
Wed Sep 04, 2013 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 TI Error Data is not Real
Replies: 14
Views: 8871

Re: TM1 TI Error Data is not Real

NumberToString() inside the cellputs() should work.
by wissew
Thu Aug 15, 2013 8:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Subsets
Replies: 5
Views: 4054

Re: Order of Subsets

You could try prefacing the month name with the code, 01-Jan, 02-Feb,...
by wissew
Thu Aug 15, 2013 8:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 10013

Re: TI SQL performance issue

Steve is on to something. The ' key is need to encapsulate the month and year code.
by wissew
Fri Oct 12, 2012 5:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rename TM1 admin host
Replies: 8
Views: 6252

Re: Rename TM1 admin host

Here's a suggestion: Use QA & Dev as a prefix to the TM1 server name. All will be available when you list multiple hosts as the admin host. You will just need to add a find and replace to your migration process for templates and reports. You can move TM1 objects (*.pro, *.cub, etc.....) between ...
by wissew
Fri Jul 06, 2012 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A rules question
Replies: 3
Views: 2299

Re: A rules question

It does... here are the dimensions of both cubes: http://www.axenda.com/images/personal/ruleerror2.png As you can see, the other dimensions are identical. Mike Mike, Within the DB section you need to use the dimension names that are in the target cube. ['Quantity'] = n: DB('RuleTest1', !Quantity, !...
by wissew
Thu Apr 05, 2012 12:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fixpack 2 install
Replies: 13
Views: 7672

Re: Fixpack 2 install

IBM was nice enough to provide a brief installation guide with FP1. In the abcense of a FP2 guide I would refer to the previous guide keeping in mind that you would need to have FP1 installed first and then install FP2. - TITLE: Cognos TM1 9.5.2 Fix Pack 2 - URL: http://www.ibm.com/support/docview.w...
by wissew
Tue Apr 05, 2011 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Top unable to display all clients
Replies: 2
Views: 1994

Top unable to display all clients

I'm using version 9.1.4 tm1top and I can't view all the clients logged on to the server. Only shows about 65. Any work arounds?
by wissew
Thu Mar 10, 2011 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: executecommand() with batch files
Replies: 29
Views: 30164

Re: executecommand() with batch files

Cam I think what you need to do is forget about TM1 until the batch files works when executing manually outside of TM1, once you are confident it works then try executing it from TM1, otherwise it can be too hard to see what is going on, if it works outside tm1 but not inside tm1 it immediately nar...
by wissew
Tue Mar 01, 2011 11:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Garbage Memory
Replies: 21
Views: 14500

Re: TM1 Garbage Memory

What's the ram on the server?
by wissew
Tue Mar 01, 2011 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Garbage Memory
Replies: 21
Views: 14500

Re: TM1 Garbage Memory

SWEET!!!
by wissew
Thu Jan 20, 2011 10:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RULE FORMATING CELL
Replies: 2
Views: 2504

Re: RULE FORMATING CELL

Has anyone used rules to force a cell format? I what to restrict the number of decimal points accepted by the cube on a dbs from the user. They don't alwas get the rounding right and Excel has a habit of poor rounding on calculated values. I may be wrong but as far as I know cell formatting won't a...
by wissew
Thu Jan 20, 2011 6:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RULE FORMATING CELL
Replies: 2
Views: 2504

RULE FORMATING CELL

Has anyone used rules to force a cell format?
I what to restrict the number of decimal points accepted by the cube on a dbs from the user. They don't alwas get the rounding right and Excel has a habit of poor rounding on calculated values.