Search found 630 matches

by paulsimon
Wed Oct 17, 2018 8:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 100% Stacked Bar Chart based on Active Form?
Replies: 3
Views: 92

Re: 100% Stacked Bar Chart based on Active Form?

Hi macsir Not sure if you have already answered your own question. We had similar issues with a Waterfall chart. However, as the user only wanted to see the Top 6, we recorded MDX for this and then pasted it in to Excel and concatenated in the appropriate variables, and used this in the Active Form....
by paulsimon
Wed Oct 17, 2018 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly forecast phasing
Replies: 2
Views: 162

Re: Monthly forecast phasing

Hi Sorry but I am with Lotsaram on this. You need to provide more information on what you are trying to do eg cubes and dimension elements. It is certainly possible. If I understand you correctly, this seems to be a rather unusual phasing requirement. It would be more usual to forecast a full year f...
by paulsimon
Wed Oct 17, 2018 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing user when using CAM security
Replies: 3
Views: 128

Re: Removing user when using CAM security

Hi You will need to remove the user from both TM1 and from Active Directory. If you think about it, if you remove a user from AD, how will AD know that that user exists in TM1 to delete them - it is not really in Microsoft's interests to provide support for an IBM product. Similarly if you remove a ...
by paulsimon
Wed Oct 17, 2018 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 BI Package Change
Replies: 1
Views: 30

Re: TM1 BI Package Change

Hi Ajay I have recently needed to create a new TM1 Model/Instance, fortunately the cubes are all the same as an old one. For the old one, I had a data source connection for the packages used by my Report Studio reports which pointed to the old TM1 instance, but I now can't seem to modify these packa...
by paulsimon
Fri Oct 12, 2018 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bug with HierarchyAttrPutS
Replies: 4
Views: 92

Re: Bug with HierarchyAttrPutS

Hi I suggest that you try the following in the order given to see if any of them works around this. a) Swap the order of the attrputs and the SubsetCreateByMDX so the AttrPutS comes second b) Do the SubsetCreateByMDX on the Prolog and the AttrPutS on the Epilog c) Put the SubsetCreateByMDX and the A...
by paulsimon
Tue Oct 02, 2018 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot Open Application URL Entries in TM1Web
Replies: 6
Views: 222

Re: Cannot Open Application URL Entries in TM1Web

Hi Just to let you know that we have been able to open a TM1 Web Sheet via the URL API in PA 2.0.5 and pass parameters using the Sheet-Row-Column approach. The issue that we had was related to Cognos BI variables rather than the URL API. When we hard-coded in the Entity that we wanted to pass, it wa...
by paulsimon
Sun Sep 30, 2018 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot Open Application URL Entries in TM1Web
Replies: 6
Views: 222

Re: Cannot Open Application URL Entries in TM1Web

Hi mce I was trying to help. Unfortunately your question was not very clear. I did try following the link that you gave but got a message from the IBM web site to say that it was invalid. If I understand you correctly, what you are saying is that you can launch a web sheet via the URL API from TM1 W...
by paulsimon
Fri Sep 28, 2018 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 32
Views: 2460

Re: Planning Analytics using twice the memory of 10.1

Hi Paul It is likely to be some time before IBM provide a solution. It might be quicker for you to change your design to reduce the number of alternate hierarchies and remove any old cubes, etc, to cut down on memory requirements. We have encountered several issues when upgrading to PA. I will post ...
by paulsimon
Fri Sep 28, 2018 7:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX query using more than one cube.
Replies: 8
Views: 204

Re: MDX query using more than one cube.

Hi Personally I would do this via Rules. In SQL you can write SELECT * FROM TABLEA WHERE (A,B) in (SELECT A, B FROM TABLEB WHERE ACTIVE=TRUE. A little digging around the internet turned up the following SELECT Hierarchize(crossjoin([Geography].[Geo].[Europe].children,[Product].[Prod].[icCube].childr...
by paulsimon
Fri Sep 28, 2018 6:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot Open Application URL Entries in TM1Web
Replies: 6
Views: 222

Re: Cannot Open Application URL Entries in TM1Web

Hi I am curious as to why would you want to open a Web Sheet that is in a TM1 Application folder via the URL API? It is much easier and more reliable to do it from an Action Button. Are you aware that IBM changed the URL API from 10.1? Although as you are already on 10.2 if it is working there then ...
by paulsimon
Wed Sep 26, 2018 8:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 32
Views: 2460

Re: Planning Analytics using twice the memory of 10.1

Hi

Just to let you know IBM Support have now reproduced the considerable increase in memory that we were seeing when upgrading from 10.1.1 to PA 2.0.5 and have referred this to Engineering for some sort of improvement.

Regards

Paul Simon
by paulsimon
Wed Sep 26, 2018 8:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How To Compare two dimensions
Replies: 8
Views: 3015

Re: How To Compare two dimensions

Hi I use this approach in all major dimension updates. I update an _Origin version of the dimension first. This copy of the dimension is not used in any cubes so if the update fails for some reason it does not affect any data. I then have processes that compare the updated _Origin dimension to the c...
by paulsimon
Thu Sep 20, 2018 8:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java TM1 API : need help
Replies: 7
Views: 488

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

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

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

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

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

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

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

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