Search found 680 matches

by paulsimon
Fri Apr 12, 2019 8:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 354

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Hi Paul TM1 You might want to take a look at the IBM Planning Analytics Community (Seems to go by the name Business Analytics but heading is Planning Analytics) https://community.ibm.com/community/user/businessanalytics There have been some recent posts on that related to this. Good luck. It took ou...
by paulsimon
Mon Apr 08, 2019 9:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 354

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Hi Paul

If you are making TM1 visible on an External URL then you really should have your own certificate, rather than using the default Applix one.

Regards

Paul SImon
by paulsimon
Sun Apr 07, 2019 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EOMonth Function
Replies: 3
Views: 175

Re: EOMonth Function

Hi You can use pretty much any of the Rule Functions in TI. Look at the Date and Time Rules Functions section of the TM1 Reference Guide. DAYNO will get you the Date Serial Number of a string date which should be in the form YYYY-MM-DD So if you have a date in string format such as '15-06-2019' then...
by paulsimon
Sat Apr 06, 2019 9:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation of Elements
Replies: 1
Views: 146

Re: Consolidation of Elements

Hi If it just a few elements, use the Dimension Editor If there are more elements than that, define the hierarchy in Parent-Child format and save as a CSV file, then import it using a Turbo Integrator (TI) Process. You don't need any coding the wizard in TI will guide you through that. Make the Chil...
by paulsimon
Thu Apr 04, 2019 7:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 354

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Hi I have never used contributor since no client has ever wanted the default workflow. However, we also struggled to get TM1 Web to work with an External URL. The documentation misses out a number of steps and ports that need to be opened. I suggest that you raise a PMR with IBM as that was the only...
by paulsimon
Wed Mar 27, 2019 11:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Dimensions
Replies: 8
Views: 602

Re: TM1 Dimensions

Hi As well as CellGetNs you will also need to re-create any views on the cube with the extra dimensions. I have a utility that generates the TI script necessary to create all views on the current cube and then this can be manipulated in Excel to add a reference to the appropriate subset on the new d...
by paulsimon
Mon Mar 25, 2019 11:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security
Replies: 4
Views: 237

Re: TM1 Security

Hi Peter First check that the element is a base level element and not a consolidation. Right click on the cell that you are trying to write to and check that no rules apply to the cell In Perspectives on the View Menu ensure that Display Control Objects is ticked Expand Cubes and look for }ElementPr...
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: 261

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: 1202

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: 1202

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: 497

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: 497

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: 916

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: 281

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: 281

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: 497

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: 126

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: 497

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: 2497

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: 308

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...