Search found 71 matches

by jorelb
Tue Mar 23, 2010 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RDC Profile Corruption
Replies: 1
Views: 1428

Re: RDC Profile Corruption

We thought we had the solution by deleting the RDC profile however the problem still persisted. One thing was apparent, folks who were windows admin did not have the issue. To test, I removed myself from the admin group and made myself a regular user –and presto, I started experiencing the problem...
by jorelb
Fri Mar 12, 2010 11:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RDC Profile Corruption
Replies: 1
Views: 1428

RDC Profile Corruption

We have a dedicated X64 box with 32 gig of RAM for TM1 and we are on version 9.4 MR1 and using Excel 2007. Because the box only runs TM1 and has the memory and horse power, we let users RDC to the box to do TM1 work using Excel. Recently, it has been becoming frequent, users would not be able to lau...
by jorelb
Mon Jan 18, 2010 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2007 Sleeping Cells
Replies: 6
Views: 5049

Re: Excel 2007 Sleeping Cells

I am relieved to find out that my users are not the only one experiencing this issue and that it may not be a TM1 but an excel problem. Since TM1 uses Excel as a front end, how can we clearly determine whether the problem is with TM1 or Excel? Another frequent error message I get from excel is “Ex...
by jorelb
Fri Jan 08, 2010 6:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2007 Sleeping Cells
Replies: 6
Views: 5049

Re: Excel 2007 Sleeping Cells

Alan, thanks much - it works! :D

Jose
by jorelb
Fri Jan 08, 2010 5:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2007 Sleeping Cells
Replies: 6
Views: 5049

Excel 2007 Sleeping Cells

We are running TM1 9.4 MR1 on a X64 box and using Excel 2007. On occasions, I will have users reporting a “sleeping cell issue”, that is a cell or group of cells in excel with valid and verified TM1 formula will display #value. Pressing F9 will still display the #value but if users go to the spe...
by jorelb
Tue Oct 27, 2009 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and MAC Compatibility
Replies: 5
Views: 4341

Re: TM1 and MAC Compatibility

I followed Allan's recommendation and sent a plain vanilla worksheet with a TM1 formula and it crashed when opened in a MAC. We considered deploying the worksheet through TM1 Web but since our TM1 solution is a temporary fix for a current problem, we decided the cost of additional licenses was not j...
by jorelb
Mon Oct 26, 2009 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and MAC Compatibility
Replies: 5
Views: 4341

TM1 and MAC Compatibility

We deployed Excel 2007 worksheet templates where users enter data. On a weekly basis, these spreadsheets are emailed back to a central location where it is then uploaded to TM1. The data entry sections of these spreadsheets do not have TM1 formulas, data is uploaded by the superusers turning on a se...
by jorelb
Thu Sep 24, 2009 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StatsByCube
Replies: 3
Views: 3259

Re: StatsByCube

I agree, I would prefer TI, but the main user requirement is real time calculations (they do not want to run the risk of forgeting to run a process). However, I did modify some rules and fixed some intra cube feeders from 1 source cube and the changes improved the intial view load time from 45 sec t...
by jorelb
Wed Sep 23, 2009 7:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StatsByCube
Replies: 3
Views: 3259

StatsByCube

I am trying to optimize a cube that pulls data from other cubes using only rules. Using performance monitor, I get the output below for }StatsByCube. Number of Stored Calculated Cells 5,290,316 Number of Fed Cells 46,628,304 Memory Used for Calculations 64,283,392 Memory Used for Input Data 153,220,...
by jorelb
Tue Sep 15, 2009 5:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Intracube Feeders
Replies: 2
Views: 2013

Re: Intracube Feeders

Thanks Alan!

Jose
by jorelb
Mon Sep 14, 2009 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Intracube Feeders
Replies: 2
Views: 2013

Intracube Feeders

TM1 Version: 9.4 MR1 Microsoft Windows Server 2003 x64 SP2 When I started learning TM1, I was told that I must have feeders when I use “Skipcheck”. However, recently, I was introduced to a concept that if I write a rule that references data from another cube I do not need a feeder from the sourc...