Search found 618 matches

by paulsimon
Thu Sep 20, 2018 8:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java TM1 API : need help
Replies: 3
Views: 43

Re: Java TM1 API : need help

Hi

I would also suggest that you use the TM1 Rest API instead of the Java API. It is a much more modern API and the Java API never had that much take up, so you are unlikely to get much help with it

Paul Simon
by paulsimon
Fri Aug 31, 2018 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ragged Dimension Hierarchies causing PA2.0 crashes
Replies: 3
Views: 109

Re: Ragged Dimension Hierarchies causing PA2.0 crashes

Hi By all means contact IBM Support as this looks like a bug. We contacted them over a similar issue in PA 2.0.3 (which still exists in PA 2.0.5). Our issue seems to be related to alternate hierarchies leading to the server using incredible amounts of memory because it generates MUNs for every possi...
by paulsimon
Thu Aug 30, 2018 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question - Stack Overflow
Replies: 4
Views: 118

Re: Question - Stack Overflow

Hi Jorge

As Jim says it is most likely a recursive rule that has nothing to stop the recursion. I can't remember the exact limit on the TM1 stack but it is a couple of hundred. I would also check the TM1Server.log. There might be a clue there.

Regards

Paul Simon
by paulsimon
Thu Aug 30, 2018 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DB function in rules with alternative hierarchies
Replies: 3
Views: 130

Re: DB function in rules with alternative hierarchies

Hi Wim Do you possibly have a clash of element names? Is it possible that one of your country consolidations in your Country Hierarchy has eg the same code or an alias that is the same as one of your products or one of your other dimensions? There is a complicated syntax for making clear which you m...
by paulsimon
Wed Aug 29, 2018 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reports against TM1 - Question
Replies: 4
Views: 232

Re: Reports against TM1 - Question

Hi Reuben By the way if you do still need the rule approach then I would suggest that you still use consolidation ie Variance as a parent of Budget and Actual, but then you override the Variance with a C: consolidated level rule. The advantage of this is that you don't need to feed the variance. I u...
by paulsimon
Wed Aug 29, 2018 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reports against TM1 - Question
Replies: 4
Views: 232

Re: Reports against TM1 - Question

Hi Reuben I would check your data first. It it is a typical TB then Income will be negative and Expenses positive. Therefore Budget - Actual will always give you what you want eg Act Bud Var B-A Inc X -4 -5 -1 Income below Budget so negative Inc Y -3 -2 1 Income above Budget so positive Exp X 2 1 -1...
by paulsimon
Wed Aug 29, 2018 9:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 271

Re: Order of Cube-Processing

Hi When exporting a cube or using a view extract, the order is determined by the physical order of the elements in the dimensions. Using a subset with a different order does not affect this. The order of the dimensions is determined by the physical order of the dimensions in the cube. If you re-orde...
by paulsimon
Mon Aug 27, 2018 11:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Problem
Replies: 4
Views: 215

Re: TI Problem

Hi Jorge What do you mean by log file? Do you mean a TM1ProcessError log file? The other thing to check is the TM1Server.log. That may show that perhaps the number or type of parameters in a process have changed or a process name has changed and that is why it is failing since the call to execute th...
by paulsimon
Mon Aug 27, 2018 11:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New hierarchy creation is disabled
Replies: 4
Views: 99

Re: New hierarchy creation is disabled

Hi Wim Are you using PAW? We don't have a license for that so I can't comment, but I have created hierarchies using TI. I think for any practical purposes, TI is going to be the way to go, since the hierarchies will need to be maintained in much the same way as the underlying dimension. For example,...
by paulsimon
Sat Aug 25, 2018 3:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 restapi in C# app
Replies: 4
Views: 356

Re: Tm1 restapi in C# app

Hi

I suggest that you do a search online. There are documents on TM1RestAPI authentication. From what I can remember the login should pass back a number that you then need to give on all later calls. However, there are differences between standard TM1 Authentication and CAM

Regards

Paul Simon
by paulsimon
Wed Aug 22, 2018 9:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
Replies: 8
Views: 648

Re: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?

Hi Just to mention, one of the downsides of option 1 - sending out workbooks with DBS formula is that it is very easy for these to get corrupted if the users start to cut, copy and paste data around, which can result in the DBS picking up data from the wrong location. That is why I would recommend r...
by paulsimon
Wed Aug 22, 2018 9:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change configurations for PAW
Replies: 10
Views: 259

Re: How to change configurations for PAW

Hi

Further down that guidance it says you can change the parameters by either editing paw.ps1 or by using the PAW Admin Tool. I would suggest using the PAW Admin Tool. That seems to work for us.

Regards

Paul Simon
by paulsimon
Wed Aug 22, 2018 8:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Cube Design for a Financial Model
Replies: 6
Views: 409

Re: Best Cube Design for a Financial Model

Hi I agree with Tom, unless there is a real need to see allocations immediately that something changes, I would do them via a TI. In my experience most Accountants prefer to think of running the allocations and don't want things to change immediately. They tend to only run the allocations once the u...
by paulsimon
Mon Aug 20, 2018 11:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
Replies: 8
Views: 648

Re: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?

Hi Again I and lots of other people have VBA that will take a sheet with DBRs and will generate a workbook for, eg, each Cost Centre in a subset list of Cost Centres. It can automatically paste special value these and email them out to the user associated with each Cost Centre. I have other code tha...
by paulsimon
Mon Aug 20, 2018 10:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 29
Views: 1696

Re: Planning Analytics using twice the memory of 10.1

Hi An update on this. Still no response from IBM Support or Development :( I reduced memory requirements by cleaning up all old cubes. This is something that we were going to do anyway, but ideally the other side of the upgrade. I now need to do more testing to ensure that removing references to old...
by paulsimon
Sun Aug 19, 2018 4:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sluggish ODBC recordset
Replies: 4
Views: 114

Re: Sluggish ODBC recordset

Hi George The other possibility other than the SQL database is that it is the network between the SQL Server box and the TM1 box. That might explain why querying it from a client PC using ODBC is much faster. Have you tried running the query on the TM1 Server via Excel using the same ODBC DSN as the...
by paulsimon
Sun Aug 19, 2018 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sluggish ODBC recordset
Replies: 4
Views: 114

Re: Sluggish ODBC recordset

Hi George Sometimes SQL will adopt a different query strategy depending on whether it is being asked to return the first n records or the full record set. I have certainly seen issues around this with DB2/400, but not so much with SQL Server. If you know there are 20000 records then I would try runn...
by paulsimon
Sat Aug 18, 2018 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Dynamic Subset possible?
Replies: 1
Views: 270

Re: Pax - Dynamic Subset possible?

Hi If you try Edit Set in PAX you will find that the default mode is to record the MDX. To try this create an Exploration View. With a dimension in the Row or Column position, right click and select Edit Set. Then click the X on the RHS pane to clear any existing selection, and then in the LHS Pane ...
by paulsimon
Sat Aug 18, 2018 10:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
Replies: 8
Views: 648

Re: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?

Hi

So is there a problem with option 2 ie the XLAM, or did you not understand it?

Regards

Paul Simon
by paulsimon
Sat Aug 18, 2018 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to know last cube updated time in TM1
Replies: 7
Views: 752

Re: How to know last cube updated time in TM1

Hi You can get the time the cube was last updated via the VB/C API and probably by the Rest API too but anyway the information is available in the underlying TM1 model even if it not surfaced in any easily accessible way. The VB/C API method works for any change to the cube, so if the cube is update...