Search found 42 matches

by AnthonyT
Tue Feb 27, 2018 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW connection to two same named instances, on different servers
Replies: 4
Views: 644

Re: DBRW connection to two same named instances, on different servers

Thanks Paul

I've tried every way possible to connect to theses instances - to compare objects relationship / size / existence etc - without success. Just wondered if someone had managed it using an Admin Host prefix or something

I guess not
by AnthonyT
Mon Feb 26, 2018 9:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW connection to two same named instances, on different servers
Replies: 4
Views: 644

DBRW connection to two same named instances, on different servers

I may be having a mental block, but I am struggling I am using Excel to connect to two different servers - both having the same name - but on two different servers I have an instance called Fred - one on a Pre Prod box, the other on a Prod box. There is no chance of changing the name Normally, on th...
by AnthonyT
Tue Oct 18, 2016 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Another API question
Replies: 0
Views: 394

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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