Search found 685 matches

by paulsimon
Sun Jun 23, 2019 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automated TM1 Regression Testing Framework like nUnit?
Replies: 8
Views: 2512

Re: Automated TM1 Regression Testing Framework like nUnit?

Hi Cathy It looks like you are more interested in comparing Excel workbook reports? If so, then we use a utility to do this. If you are looking at doing regression testing after a version upgrade, then we use the following approach: Start the old and new versions on two different servers with identi...
by paulsimon
Fri May 31, 2019 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 394

Re: RunTI Issue

Hi I would check the TM1Server log to see whether the processes are running but failing or whether they are never being run at all. I suggest that you make the process output a last time completed to a cube so that you can tell whether they were run or not. Perhaps make the process that triggers the...
by paulsimon
Fri May 31, 2019 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 176

Re: display Dimension dialog box from TI process

Hi As a side note in PAW the Action Button does prompt you to pick something at the time you click the button if the process has parameters. However, in practice most users prefer to pick the element via something like a SUBNM and then click a button to run the process at a later time. This is becau...
by paulsimon
Mon May 13, 2019 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Good Practice on Attributes
Replies: 1
Views: 197

Re: Good Practice on Attributes

Hi I suggest you search this forum on attribute hierarchies. They are probably best regarded as demo-ware. You will be better building hierarchies explicitly using the new TI functions such as HierarchyElementAdd. You essentially follow the same approach that you did with DimensionElementInsert and ...
by paulsimon
Thu May 09, 2019 8:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access denied to cells for non admin users in TI Logs
Replies: 3
Views: 185

Re: Access denied to cells for non admin users in TI Logs

Hi We frequently get this sort of issue. I therefore developed a utility that lets you pick a user, it then works out which groups they are in and then checks the security at cube, dimension, and element level as well as cell security, and also checks for other reasons, such as consolidated cells, r...
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: 509

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

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

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

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

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: 9
Views: 742

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

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

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

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

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

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

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

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

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

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