Search found 21 matches

by PeteB
Fri Apr 27, 2018 3:18 am
Forum: Enhancements
Topic: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Replies: 6
Views: 1074

Re: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube

Hi Everyone,

I have updated this thread with a link to the second RFE in the TM1 Cognos section https://www.ibm.com/developerworks/rfe/ ... _ID=118320

Regards,

Pete.
by PeteB
Sat Mar 31, 2018 3:10 am
Forum: Enhancements
Topic: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Replies: 6
Views: 1074

Re: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube

Hi Lotsram, Voted for your favourite. I had not seen to the "Cognos TM1" section previously I had looked for TM1 and found Planning Analytics, so I have now raised a second RFE for this function. I am not sure why IBM has the three different areas and if it makes sense to duplicate the RFEs. Cheers,...
by PeteB
Thu Mar 29, 2018 4:08 am
Forum: Enhancements
Topic: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Replies: 6
Views: 1074

Re: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube

Hi Lotsaram, Thank you for your input. Or what about a multi-dimensional from/to mapping e.g 2017 ACT to 2018 BUD? This is covered by the current RFE - Allow developer to specify an optionally collection of, source and target tuples defining the 'slice' to be copied adhering to the following rules, ...
by PeteB
Fri Mar 23, 2018 2:36 am
Forum: Enhancements
Topic: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Replies: 6
Views: 1074

RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube

Hi Everyone, (Sorry about not posting in the correct area previously.) https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=116669 and https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=118320 are an RFEs for a TM1 commend to internalise the copy of rule values to...
by PeteB
Fri Mar 16, 2018 2:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 1217

Re: Parallel run vs. ICX

Hi Everyone reading this thread, Firstly apologies if you have read a similar comment on other very similar treads. It is very likely we each have had a similar problem, which can be fixed by IBM in a future release. I am told by IBM this should be a trivial piece of work to deliver the copy functio...
by PeteB
Tue Mar 13, 2018 11:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 841

Re: Improve TI Processing Time

gtonkin correctly wrote: Noted that the comments on this RFE say that on 1 March 2018, IBM declined this request as functionality is available through TI. However, given this is easy for IBM to do, and will eliminate the performance issues with copy values, even after making the rules, feeders as e...
by PeteB
Tue Mar 13, 2018 2:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 841

Re: Improve TI Processing Time

Hi Everyone reading this thread, It is very likely we each have had a similar problem, which can be fixed by IBM in a future release. I am told by IBM this should be a trivial piece of work to deliver the copy function from a slice of rules cells to value cells and the performance should be signific...
by PeteB
Wed Feb 28, 2018 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy version performance
Replies: 15
Views: 2604

Re: Copy version performance

Hi Everyone contributing to this thread, https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube I am looking for your vote for an RFE for IBM to provide the function to copy rule based cells to values. I am t...
by PeteB
Thu Dec 07, 2017 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Turbo Debugger
Replies: 10
Views: 1968

Re: TM1 Turbo Debugger

Very Good News. IBM have delivered the new version of TurboDebugger to address the wrapping error. From my testing this error has been fixed.
by PeteB
Sun Nov 05, 2017 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Turbo Debugger
Replies: 10
Views: 1968

Re: TM1 Turbo Debugger

The latest update from IBM

Good news, Offering Management are going to fix the issue. It's a Word wrap issue.
by PeteB
Tue Oct 31, 2017 2:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Turbo Debugger
Replies: 10
Views: 1968

Re: TM1 Turbo Debugger

Here is the latest update form IBM Product Offering have said that the TI debugger will become officially part of Planning Analytics Workspace and therefore officially supported, but they can't give me a timeframe of when that will happen. With that said, Product Offering would like to look into thi...
by PeteB
Fri Oct 20, 2017 1:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Turbo Debugger
Replies: 10
Views: 1968

Re: TM1 Turbo Debugger

Hi, The debugger is fantastic, however I am have the same problem with the missing lines of code. It does not consistently occur, ie it does not depend on the number of lines as it impacts both small and large TIs. The same TI will sometimes show all lines and sometimes not. I have raised this as is...
by PeteB
Mon Jul 31, 2017 5:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web crashes and needs to be restarted
Replies: 12
Views: 4498

Re: TM1 web crashes and needs to be restarted

Two weeks ago we upgraded from 10.2 to 11.0 (PAL 2.0) and we started to encounter TM1 Web crashing - java.lang.OutOfMemoryError: Java heap space. This upgrade involved the change from Tomcat to Websphere Liberty. We have made below changes and currently are not experiencing any more crashes, but we ...
by PeteB
Thu Dec 08, 2016 11:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Setting an Alias on Title dimension in a view
Replies: 2
Views: 559

Setting an Alias on Title dimension in a view

Hi, Is there a way to attach an alias to the title dimension in a view. I am currently using the following commands to set the element for the title dimension, however I can't find the command to turn on the alias for the dimension. ViewTitleDimensionSet( sCube, sView, sDim ); ViewTitleElementSet( s...
by PeteB
Wed Aug 21, 2013 7:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 3036

Re: TI SQL performance issue

Hi RMackenzie, Thank you for your great explanation on how TI was working differently to the other tools in regards the ODBC connection. And thanks for your suggestions as well. So, I would try re-writing the query in such a way that each column is cast into a well-known type (CHAR, VARCHAR, DATETIM...
by PeteB
Mon Aug 19, 2013 3:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 3036

Re: TI SQL performance issue

Yes the Use Unicode option is checked Try unckecking it. I have also seen factor 10 or more improvement by doing this. Although the unicode option is the default for ODBC datasources in TM1 the reality is that if you're not dealing with extended character sets then you don't need it. Hi Lotsaram, T...
by PeteB
Fri Aug 16, 2013 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 3036

Re: TI SQL performance issue

Hi Tomok,

Thank you for your response
tomok wrote:Is the Use Unicode opton checked in TI? I have seen SQL performance issues in TI when the database has Unicode data in it and this option is not checked.
Yes the Use Unicode option is checked
by PeteB
Fri Aug 16, 2013 3:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 3036

Re: TI SQL performance issue

Hi Nick and Steve, Thanks for your suggestions, but so far no luck. My main concern is why the same SQL code using the same ODBC connection returning the same data takes significantly longer in TM1 TI versus both Microsoft Query and Hyperion. In fact both Microsoft Query and Hyperion are too quick t...
by PeteB
Wed Aug 14, 2013 6:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 3036

Re: TI SQL performance issue

Hi Nick, Sorry, I should have said I had already tested the SQL both as a drill-through process and a standard process, just in case there was difference. As far as I can tell there is no difference between the drill-through process and a standard process from a TM1 perspective. Thanks for the SAL t...