Search found 40 matches

by AnthonyT
Tue Oct 18, 2016 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Another API question
Replies: 0
Views: 274

Another API question

Running TM1 10.2.2 on a local machine Have Planning Sample and SData up an running, configured to have my machine name as Admin Host (though have also left these blank to use localhost) Using Visual Studio 2015, and a VB Windows Form Application Copied the VB BAS file into a new module, and update t...
by AnthonyT
Tue Sep 23, 2014 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question on ODBC Output
Replies: 9
Views: 1769

Re: Question on ODBC Output

Same as Tomok for me
by AnthonyT
Fri May 30, 2014 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Formatting error in TM1 Application Web
Replies: 3
Views: 1471

Re: Formatting error in TM1 Application Web

Double check what you are pasting - it might not be the format that is expected i.e. it might be 9562.235689, but masked in Excel to look like 9562 I've had an issue with copying from formatted Excel sheets into TM1Web, and the users had to use a hidden, linked, unformatted sheet as a workaround dur...
by AnthonyT
Tue Jan 08, 2013 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rollup Button failing?
Replies: 10
Views: 1881

Re: Rollup Button failing?

Has UserDefinedCalculations been set to False in the cfg file?
by AnthonyT
Tue Jan 08, 2013 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PMT supported function in TM1 web
Replies: 5
Views: 1319

Re: PMT supported function in TM1 web

From the reference documentation This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes. PAYMT returns the payment amount of an annuity based on a given initial value or principal, an interest rate, and a number of periods. An annuity is a series of payments made at equ...
by AnthonyT
Tue Jan 08, 2013 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PMT supported function in TM1 web
Replies: 5
Views: 1319

Re: PMT supported function in TM1 web

Is this the same as PAYMT ?
by AnthonyT
Fri Oct 19, 2012 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension with multiple levels hierarchy
Replies: 13
Views: 4325

Re: Dimension with multiple levels hierarchy

Hi Roasanero Not sure if this is the problem, as my grasp of Italian doesn't much go past the names of football teams! It looks like the consolidations are not unique so get rolled up into multiple places! For example, October is not unique to 2012 - there is one in 2011, 2010 etc. The same for week...
by AnthonyT
Thu Aug 02, 2012 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to Publish Data from cubes to Orcale database
Replies: 3
Views: 487

Re: Unable to Publish Data from cubes to Orcale database

I would try checking your variables first - are V1, V2 what you expect? Are they the correct format for where they are going to end up?

Also, try using the existing SQL statement but get rid of the EXPAND, and hardcode the variables - just to check that what you have written works
by AnthonyT
Tue May 15, 2012 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 3191

Re: TM1 10.1 - Trace Calculation behaviour

So I wasn't going crazy then :lol:
by AnthonyT
Fri Mar 16, 2012 4:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UK TM1 User Group
Replies: 15
Views: 1761

Re: UK TM1 User Group

Looks good
by AnthonyT
Fri Mar 16, 2012 11:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web 9.5.2 FP1 + IE9
Replies: 10
Views: 1551

Re: TM1web 9.5.2 FP1 + IE9

It would be boring if everything worked first time.....especially for a demo!
by AnthonyT
Fri Mar 16, 2012 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UK TM1 User Group
Replies: 15
Views: 1761

Re: UK TM1 User Group

To save most of the people travelling, hold it in the restaurant in HSBC, Canary Wharf

:D
by AnthonyT
Fri Mar 09, 2012 1:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 3191

Re: TM1 10.1 - Trace Calculation behaviour

Hey Sander

Great - look forward to hearing the outcome
by AnthonyT
Fri Mar 09, 2012 1:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process which last long time and TM1Web = error
Replies: 4
Views: 998

Re: TI process which last long time and TM1Web = error

Just checking - the button you added and use to run the TI process, is it an Action Button or an Object with VBA code behind it

As far as I know VBA doesn't work with TM1Web
by AnthonyT
Thu Mar 08, 2012 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a Dev and Prod Environment in the same server
Replies: 7
Views: 1251

Re: Create a Dev and Prod Environment in the same server

Jorge

Can't you create DEV cubes and processes on the same instance - using TIs pointing at a DEV source system? You could prefix these with 'DEV_'. This would "sort of" give you two instances in one

Just an idea
by AnthonyT
Thu Mar 08, 2012 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 3191

Re: TM1 10.1 - Trace Calculation behaviour

Hi Sander I haven't had the chance to yet I still have the same problem and although I can work around the Trace Calculation problem by going in at a consolidated level, I can't do that with the Check Feeders option I will see if I can log it next week, when I get back to the office Thanks for letti...
by AnthonyT
Tue Feb 28, 2012 4:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: About memory stacks and executeprocess
Replies: 3
Views: 467

Re: About memory stacks and executeprocess

Not sure if I am off beam here, but I had a problem with memory when I ran a process that was running a loop that created a new view with each pass Each view was destroyed after use, but the memory consumption went up I added the following to the cfg file and all has been well since MaximumViewSize=...
by AnthonyT
Tue Feb 28, 2012 7:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 3191

Re: TM1 10.1 - Trace Calculation behaviour

Thanks for the replies I've double / triple ( and all the other 'le's' ) checked that I am only tracing from one cell. The "feature" seems to work on some calculated results that are zeros, but not all - and I have tried different dimension combinations within the same cube, different cubes, and dif...
by AnthonyT
Thu Feb 23, 2012 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 3191

TM1 10.1 - Trace Calculation behaviour

Afternoon all I am doing some parallel testing of TM1 version 10.1 against 9.4 (both 64bit) I have found some calculation differences, and fully expected them to be down to the volumes of data that I am working through, but I have stumbled upon something odd When I try to right-click on a calculated...
by AnthonyT
Thu Jan 19, 2012 7:53 am
Forum: Enhancements
Topic: Client last log-in date
Replies: 9
Views: 7436

Re: Client last log-in date

You can find this out by importing the Audit log file (provided that you have them enabled), and you can see what has happened by day With some TI manipulation you see when a client logged in last, changed passwords, changed groups, as well as server shutdowns / restarts, and process / dim / cube ch...