Search found 23 matches

by PeteB
Wed Apr 10, 2019 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SAP Connector on 10.2.2 and PAX
Replies: 6
Views: 4210

Re: TM1 SAP Connector on 10.2.2 and PAX

Hi Wim, From TI we can run the following BW query successfully where we use the wizard to generate the MDX and the "prompts" button to select the Company. In the TI wizard we can see the following MDX expression. SELECT * FROM [0FIGL_O02/REP_GL_LINE_ITEMS] SAP VARIABLES [!V000002] INCLUDIN...
by PeteB
Tue Apr 09, 2019 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SAP Connector on 10.2.2 and PAX
Replies: 6
Views: 4210

Re: TM1 SAP Connector on 10.2.2 and PAX

Hi Wim, I am trying to understand how we might be able to enable drill though from TM1 to BW. Your post said - adding a parameter to a TI process is piece of cake. Passing that parameter to the queried data in the FM package is less of a piece of cake... If I read your quote with a very optimistic v...
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: 24854

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

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 RFE...
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: 24854

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

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 v...
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: 8977

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

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

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

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 ...
by PeteB
Thu Dec 07, 2017 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Turbo Debugger
Replies: 10
Views: 10358

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

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

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

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: 13
Views: 15334

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

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

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

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

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