Search found 673 matches

by paulsimon
Tue Mar 19, 2019 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1WEB 2.0.6 Number Issue
Replies: 7
Views: 134

Re: TM1WEB 2.0.6 Number Issue

Hi I think what Tom is getting at is that if you have a Web Sheet that is really an Excel Sheet with an Active Form then it will always display values according to the Format Area of the Active Form. Have you just upgraded from a 10.x version to PA? It is possible that the conversion of the web shee...
by paulsimon
Sat Mar 16, 2019 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1096

Re: Automating TM1 in VBA

Hi Wim

We do a similar thing with a Scheduled Task. Have you ticked the run with Highest Privileges flag? That is equivalent to saying Run as Administrator, which might cure your problem.

Regards

Paul Simon
by paulsimon
Sat Mar 16, 2019 5:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1096

Re: Automating TM1 in VBA

Hi Wim When running as TI it will be running under the Service Account that the TM1 Service runs under. If this is still the Local System Account then it probably won't work. If it is running under a domain account, then have you checked that this has access to the file location? If you just want th...
by paulsimon
Mon Feb 25, 2019 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Re: Temp View difference to Perm Views

Hi Lotsaram

I am probably too stupid to realise that it couldn't be done and just went ahead and did it since it seemed like a logical thing to be able to do.

Anyway, I suggest you try an experiment yourself to confirm it.

Regards

Paul
by paulsimon
Mon Feb 25, 2019 11:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Re: Temp View difference to Perm Views

Hi lotsaram We are using PA 2.0.5. My understanding is that a temp view created in a master process is available to any process called by that process. We have a case here where we use a generic process to transfer data from one cube to another. The calling process first uses a temp view to clear ex...
by paulsimon
Mon Feb 25, 2019 10:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads
Replies: 8
Views: 870

Re: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads

Hi

From my reading of this, for most people, MTFeeders.AtStartup should be set to False, since most of us use conditional feeders

Regards

Paul Simon
by paulsimon
Thu Feb 21, 2019 12:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget planning model with dynamically shifting costs
Replies: 7
Views: 245

Re: Budget planning model with dynamically shifting costs

Hi Grusty Another thing you could try is the relatively new TM1S.CFG parameter ForceReevaluationOfFeedersForFedCellsOnDataChange=T I experimented with some simple feeders of the form : []=>DB('summary',!project, DB('relsource',!project,'EndMth')) ; []=>DB('summary',!project, dimnm( 'month' , dimix( ...
by paulsimon
Wed Feb 20, 2019 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget planning model with dynamically shifting costs
Replies: 7
Views: 245

Re: Budget planning model with dynamically shifting costs

Hi I think that the problem that you are going to encounter with any rules and feeder approach to this is that it will work the first time. However, if you subsequently change the end period for a project, it is not going to automatically feed across to the revised periods, unless you do a re-proces...
by paulsimon
Wed Feb 20, 2019 11:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Re: Temp View difference to Perm Views

Hi Mike In this scenario we had a process that takes a parameter of an Entity and it is normally run directly from a web sheet. However, we sometimes need to do a bulk run for all Entities. To do that we have a master process that loops through a subset of Entities and calls the individual Entity pr...
by paulsimon
Wed Feb 20, 2019 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA TM1 Web difference on Scale Divisor
Replies: 2
Views: 113

PA TM1 Web difference on Scale Divisor

Hi On some reports users want the ability to see figures in Units, Thousands, Millions, etc. We implemented this with a lookup and that gives a scale divisor of 1, 1000, 1,000,000 and then our DBRW formula were dividing by rScaleDivisor. This worked fine in Active Forms in 10.1 TM1 Web. However, it ...
by paulsimon
Wed Feb 20, 2019 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Temp View difference to Perm Views

Hi We previously used code like this IF( ViewExists( vCube , vView ) = 0 ) ; ViewCreate( vCube , vView ) ; ENDIF ; ViewSubsetAssign( vCube , vView , vMeasDim, vMeasSub ) ; etc This worked fine with permanent views, since if the view already existed the ViewSubsetAssign modified it as required. Howev...
by paulsimon
Tue Feb 19, 2019 11:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Edit TI Process without first Executing it?
Replies: 16
Views: 2441

Re: How to Edit TI Process without first Executing it?

Hi Venkat The other option if you have access to the SQL side is to start up SQL Server Management Studio right click on the server and start Activity Monitor and then you can kill the SQL query which will then allow the TI process to open. Possibly a bit less fiddly then copying the process out. Ju...
by paulsimon
Fri Feb 08, 2019 9:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java Process - CPU and Memory Utilization
Replies: 5
Views: 269

Re: TM1 Java Process - CPU and Memory Utilization

Hi Thanks for the reply. Glad you found a work around for your problem. However, I think the problem that we are getting is different. Our problem is in TM1 Web rather than PAX. The underlying sheet is a normal Perspectives sheet. We are only connected to a single server. I will let you know if we g...
by paulsimon
Tue Feb 05, 2019 8:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 277

Re: Ascii Quote Fun and Games

Hi Jim You may already be doing this, but in the past when I had to write different languages (including chinese) to files and read them back, I did the following : In the Prolog get the char set vCharSet = CellGetS( vInfoCube, 'Any', 'Character Set' ) ; When writing to a file in the Data Tab you ne...
by paulsimon
Mon Feb 04, 2019 11:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: can anyone suggest approach to write TI/ Rule for implementing interpolation in TM1
Replies: 8
Views: 439

Re: can anyone suggest approch to write TI/ Rule for implementing interpolation in TM1

Hi Val

You could do this with rules - take a look at the Rules Guide - for Stock movements. Your problem is similar to that.

You could also do it with TI. All you need is a WHILE loop

Regards

Paul Simon
by paulsimon
Sat Feb 02, 2019 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java Process - CPU and Memory Utilization
Replies: 5
Views: 269

Re: TM1 Java Process - CPU and Memory Utilization

Hi We had similar issues with CPU usage for Java on the TM1 Web server hitting 100% to the point where no one could login. However, in our scenario we only have a single PA Cube Server instance. When you say that you have Finance and Accounting servers, do you mean two Web Servers or two PA Cube Ser...
by paulsimon
Mon Jan 28, 2019 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 42
Views: 4758

Re: Planning Analytics using twice the memory of 10.1

Hi ykud

Thanks - text in the TM1 Web Cube Viewer is now left aligned. You have done a better job than the IBM Support Desk

Regards

Paul Simon
by paulsimon
Sun Jan 27, 2019 8:11 pm
Forum: Commercial and Events
Topic: TM1 Utilities
Replies: 3
Views: 3697

Re: TM1 Utilities

Dear all Version 128.1 has been released. Recent enhancements include : Check Security - We frequently get questions from users asking why they cannot write to a certain cell. This provides an easy way to find out: Open the sheet that they are working on (or if it is a view, slice it to Excel). Sele...
by paulsimon
Thu Jan 24, 2019 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 42
Views: 4758

Re: Planning Analytics using twice the memory of 10.1

Hi ykud Can you remember exactly which style you changed in flat.css. The only one that we could find changed the numbers as well as text to left aligned. We obviously want to keep the numbers right aligned and just get the text to left align, so we are looking for a CSS Style that particularly appl...
by paulsimon
Wed Jan 23, 2019 10:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX with Expand Above in Subset
Replies: 5
Views: 254

Re: MDX with Expand Above in Subset

Hi Kenneth I see the problem. To get around it I did the following on the SDATA sample cubes, using the account2 dimension which is the most similar one I could find on a sample cube that we can both access. The solution needs two subsets. Create a Subset called Subset Exp Above, which has the Expan...