Search found 702 matches

by gtonkin
Thu Jun 04, 2015 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RebuildOption
Replies: 11
Views: 4643

Re: TM1RebuildOption

I have to concur with Alan's experiences - generally when an ActiveForm is perceived as incorrect, it is generally down to something I have done i.e. poor planning and/or implementation. Normally you get tripped up when copying sheets and switching columns/rows, manually bringing a title to column/r...
by gtonkin
Thu May 21, 2015 3:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Negative number issue with TM1 10.2.2 FP3
Replies: 14
Views: 5683

Re: Negative number issue with TM1 10.2.2 FP3

There appears to be an interim fix now.

Relates to APAR PI40539 - This update fixes an issue with entering data in a TM1Web websheet on empty or zero value (0) leaf cells that are not referencing a VIEW statement in their formula.

Download links are back.
by gtonkin
Fri May 08, 2015 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Negative number issue with TM1 10.2.2 FP3
Replies: 14
Views: 5683

Re: Negative number issue with TM1 10.2.2 FP3

I still have not been able to replicate any issues with negatives. @AniketTambavekar - Please can you confirm if you are using Cube view, Perspectives, Architect, TM1 Web, PM etc. when you say: 1. When we enter a value in the cell, the first digit is getting trimmed. This may help the rest of us. p....
by gtonkin
Tue May 05, 2015 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Negative number issue with TM1 10.2.2 FP3
Replies: 14
Views: 5683

Re: Negative number issue with TM1 10.2.2 FP3

I too have tried various tests through ActiveForms, Slice, Data Spread from Excel, Data Spread within Cube viewer, direct input into Cube viewer etc. Cannot replicate.

Please give more detail if there is a specific case that triggers the issue.
by gtonkin
Thu Apr 23, 2015 5:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 tools excel add-in not working in Excel 64 bit
Replies: 15
Views: 8735

Re: TM1 tools excel add-in not working in Excel 64 bit

Hi Alan, Not sure how much tinkering you have done but I had an old template that we needed to test a specific function and found this code does the trick: Option Explicit #If Win64 Then Declare PtrSafe Function TM1_API2HAN Lib "tm1.xll" () As Long #Else Declare Function TM1_API2HAN Lib "tm1.xll" ()...
by gtonkin
Tue Mar 31, 2015 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing the decimal separator to comma
Replies: 6
Views: 4840

Re: Changing the decimal separator to comma

I would try changing the List Separator, Digit Grouping etc. under additional settings without changing other language related settings.
Not sure on the Performance Modeler settings - you will have to play around and test various scenarios.
by gtonkin
Mon Mar 30, 2015 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing the decimal separator to comma
Replies: 6
Views: 4840

Re: Changing the decimal separator to comma

I have had a similar issue before where between TM1 and the OS there was confusion between the Decimal Symbol, Digit Grouping Symbol and List Separator. Try changing these in the OS so that they do not conflict with what you are importing. Run INTL.CPL from the Run box or command prompt then choose ...
by gtonkin
Tue Mar 24, 2015 5:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Full stop in cube name breaks perspectives?
Replies: 4
Views: 2108

Re: Full stop in cube name breaks perspectives?

Just saw this article which may be useful in terms of reserved characters and do's and dont's.
by gtonkin
Wed Mar 18, 2015 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms - Conditional formatting issue
Replies: 1
Views: 1803

Active Forms - Conditional formatting issue

After many, many hours trying to work out why an Active Form report with about 9000 rows was never finishing i.e. taking more than 2 hours to do what appeared to be nothing then killing Excel, I tracked it down to conditional formatting on the first row of the AF i.e. the 1st in the TM1RPTDATARNG. T...
by gtonkin
Thu Mar 12, 2015 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 10.2 Integrated Login Kerberos setup
Replies: 46
Views: 27606

Re: TM1 Web 10.2 Integrated Login Kerberos setup

Hi Amigo, I did using the steps I posted further up in this thread - review and take note of the traps I fell into e.g Getting the correct KDC server FQDN is they key! I had configured my VM as the Domain Controller too which made my test environment easier. Also be careful of the Admin_Server in th...
by gtonkin
Wed Mar 11, 2015 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ActiveX error 429 on opening workbooks/applications
Replies: 1
Views: 1842

ActiveX error 429 on opening workbooks/applications

Microsoft Visual Basic, Run-time error '429': ActiveX component can't create object Anyone who has got clients on Office 2010 and were updated with the December 9 update may be experiencing issues with workbooks containing ActiveX controls i.e. TI Buttons. As soon as you open the workbook the error...
by gtonkin
Wed Feb 25, 2015 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No error messages shown
Replies: 7
Views: 3763

Re: No error messages shown

Have a look inside the error log file created:
Error file: <TM1ProcessError_20150225082529_}_intDPD_CallFeederGen_{3a7ebcb6-e997-4175-a870-7be82479271f}.log>
should be in your Logs folder as specified in the TMS1.CFG file. This may give you some more insight.
by gtonkin
Sun Feb 22, 2015 7:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSO & TM1Web 10.2.2 FP2
Replies: 2
Views: 1744

Re: SSO & TM1Web 10.2.2 FP2

Have a look at the document in the URL you posted. Page 2 sets the stage in terms of the .Net vs Java changes. TM1 Web will act as a client on behalf of a user looking to access a kerberized service, in this context a TM1 server on Windows in a given Microsoft Kerberos realm. In Microsoft Windows,a ...
by gtonkin
Fri Feb 20, 2015 10:49 am
Forum: Enhancements
Topic: RFE 66828-Action Button option to Rebuild a Specified Active Form
Replies: 0
Views: 2345

RFE 66828-Action Button option to Rebuild a Specified Active Form

Just logged this RFE too relating to Action Buttons-sure the user can RebuildCurrentWorkBook but why not just get the Action Button to be more friendly. Action Button currently has a calculation option the Rebuild Sheet. If the user has a report that links to information contained on other sheets, w...
by gtonkin
Fri Feb 20, 2015 10:36 am
Forum: Enhancements
Topic: RFE 66825-Action Button option to Rebuild ALL Sheets/CurrentBook
Replies: 0
Views: 2094

RFE 66825-Action Button option to Rebuild ALL Sheets/CurrentBook

I have logged an RFE for this - please vote! Calculation options for Action Button should include an option to Rebuild Workbook. Currently only the active sheet can be rebuilt. A customer has a report pack with parameters collected on a control sheet e.g. Month, Company, Scenario. The parameters are...
by gtonkin
Fri Feb 20, 2015 9:53 am
Forum: Enhancements
Topic: RFE 66823-Compare Base to one or more Sandbox scenarios
Replies: 2
Views: 11072

RFE 66823-Compare Base to one or more Sandbox scenarios

I have logged an RFE for the following as it irks me that you basically have to copy and paste, flip sandboxes, refresh etc. to try do some useful what-if analysis using sandboxes. When working with sandboxes to compare various what-if scenarios, the user can view the results of the change in the sa...
by gtonkin
Wed Feb 18, 2015 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lost connection to TM1 server.
Replies: 2
Views: 1098

Re: Lost connection to TM1 server.

This is a long shot but have you tried referencing the server using the IP address in the URL - I have a vague recollection of reading something about dashes and or underscores in server names being an issue for TM1 Web and you would either need to add an alias in the DNS or your hosts file without ...
by gtonkin
Wed Feb 11, 2015 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Backup file compare
Replies: 3
Views: 1640

Re: Tm1 Backup file compare

You could also look at SyncToy - Microsoft and Free.

It can be called from TI/Task scheduler/Ad-hoc with parameters to trigger a pre-configured folder pair. The process can add changed files, keep counter-part mirrored etc.
by gtonkin
Tue Feb 03, 2015 7:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button-goto another Worksheet
Replies: 1
Views: 1618

Action Button-goto another Worksheet

This may need to go to Tips & Tricks but before then would like to know if there is a better/easier way to do the following: I have an ActiveForm with Employees on Rows, the refresh pastes values over formulae as users sort etc. When the user clicks the Action Button, I need to transfer them to a te...
by gtonkin
Fri Jan 30, 2015 6:02 am
Forum: Enhancements
Topic: RFE 65166-Sort Numerically within Dimension/Subset
Replies: 8
Views: 3854

Re: Sort Numerically within Dimension/Subset

Thanks for the vote Alan - will check this functionality on CAFE as I am sure between this and PM, developers are hard at work adding features - get an RFE in on these products early enough and who knows (will be clinging to old school TM1 for as long as I have strength though)