Search found 109 matches

by iansdigby
Tue Dec 11, 2012 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Relative Proportional Spread Codes
Replies: 2
Views: 2878

Relative Proportional Spread Codes

Greetings! I am exploring data spreading in TM1 and finding what a powerful set of tools it is. One question I have concerns relative proportional spreading. I understand how to apply 'RPS' manually but it appears there is a shortcut for it, in the form RP.. As there are logically many parameters to...
by iansdigby
Thu Dec 06, 2012 8:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web logout
Replies: 4
Views: 3308

Re: TM1Web logout

Yes, you are right of course that it's a security issue. I thought that since it's all happening within our intranet with its good firewall systems (we do supply the military among others and have to meet very stringent requirements), that the risk was not so great. Anyway, I did wonder if it would ...
by iansdigby
Wed Dec 05, 2012 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web logout
Replies: 4
Views: 3308

Re: TM1Web logout

rmackenzie, This is really helpful and inventive, using the IE document properties to locate TM1-related info and then logging out of those browser sessions. However it didn't work for me, perhaps because of a bug in TM1Web. One of the IE document properties is 'cookie'. TM1 apparently dumps a cooki...
by iansdigby
Tue Dec 04, 2012 10:37 am
Forum: Useful code, tips and tricks
Topic: Cryptic TM1 Messages Decoded
Replies: 71
Views: 368958

Re: Cryptic TM1 Messages Decoded

On running any TI process that, inter alia, populates a cube:

TM1speak (in message log) : "Cell type is real"

Human speak: "You specified that a data variable was of type Numeric but the cube cell you are sending it to is a string cell".

(or vice versa?)
by iansdigby
Tue Dec 04, 2012 9:35 am
Forum: Useful code, tips and tricks
Topic: Restart Services using a TM1 Process
Replies: 9
Views: 14668

Re: Restart Services using a TM1 Process

It makes me chuckle but also feel good, that I am not the only one who has to dance around the chinese walls.
by iansdigby
Tue Dec 04, 2012 8:21 am
Forum: Useful code, tips and tricks
Topic: TM1 Simple Replicate
Replies: 21
Views: 25480

Re: TM1 Simple Replicate

How does he do it? I didn't even realise that processes could be copied/replicated in that way. A masterful performance Mr Marwan!
by iansdigby
Mon Dec 03, 2012 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web logout
Replies: 4
Views: 3308

TM1Web logout

Morning all. Or evening/afternoon. Am having great fun exploring the TM1Web URL API and have been able to create some excellent results. One thing is scuppering me though and that is logging out of browser sessions with the 'logout' Action parameter. Here's the scenario (I know a similar one has cro...
by iansdigby
Fri Nov 30, 2012 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 logout for websheet launched via URL API
Replies: 8
Views: 11809

Re: Tm1 logout for websheet launched via URL API

Just wondering if lewis ever found a resolution to this problem as it is one I am now facing.
Regards, Ian
by iansdigby
Thu Nov 29, 2012 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get started TM1 Web programming
Replies: 3
Views: 3130

Re: How to get started TM1 Web programming

To rmackenzie,

Thank you profusely for this most helpful guide - at the risk of being boring, this is just what's lacking in the development world: basic training that gives a simple but satisfying result. Now I can get going and figure the rest out for myself!

Thanks again,

Ian
by iansdigby
Fri Nov 23, 2012 10:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get started TM1 Web programming
Replies: 3
Views: 3130

How to get started TM1 Web programming

Hello esteemed TM1 programmers. I see that TM1 Web has a URL API that I am guessing would let me create dashboards etc. Not being a web programmer at all, my question is - how to get started? What I would really be grateful for is an ultra-simple idiot's guide in a few lines that tells me what the b...
by iansdigby
Wed Nov 07, 2012 4:11 pm
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66687

Re: Another TM1 TOP

Probably the best thing since sliced bread.

Thank you.
by iansdigby
Wed Oct 10, 2012 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel calculation puzzle
Replies: 5
Views: 3303

Re: Excel calculation puzzle

Alan Kirk's suggestion about circularity within DBRW formulae was indeed the problem and it has now been resolved, wth many thanks.

Regards, Ian
by iansdigby
Mon Oct 08, 2012 10:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder apparently not firing
Replies: 2
Views: 1575

Re: Feeder apparently not firing

qml, many thanks for resolving the problem for me.

You are of course quite right: it has nothing to do with feeders! Muddled Monday thinking.

Thanks again, Ian
by iansdigby
Mon Oct 08, 2012 8:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder apparently not firing
Replies: 2
Views: 1575

Feeder apparently not firing

Hello all. I have searched the forum for an answer to this and am generally familiar with the concepts of feeder precedence etc. However, I have a rule which restricts a calculation in one specific area then applies a more general one, viz.: Line 1: ['Gross Margin %','Cut1vsCut2']=N:STET; Line 2: ['...
by iansdigby
Fri Sep 28, 2012 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel calculation puzzle
Replies: 5
Views: 3303

Re: Excel calculation puzzle

Alan, Truly you are a master TM1-er. If I wasn't nearly 60 I would fly to Oz and beg to be your apprentice. Many thanks for this reply which, even if it is not the answer to my problem (it probably is: I will investigate soon and advise here), is most educational and helpful both to me and I am sure...
by iansdigby
Fri Sep 28, 2012 10:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel calculation puzzle
Replies: 5
Views: 3303

Re: Excel calculation puzzle

Thank you veru much for that Matyas. Using a macro seems a good workaround.

Ian
by iansdigby
Fri Sep 28, 2012 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel calculation puzzle
Replies: 5
Views: 3303

Excel calculation puzzle

Greetings to the honoured TM1 community. Salam Alaykum, '您好' [nín hǎo] and Guten Tag. I have a puzzling problem wth an Excel spreadsheet full of DBR's and DBS's. It goes like this: 1. I open the spreadsheet with Excel calculation on Automatic. Everything calculates correctly. 2. I press F9 and all t...
by iansdigby
Tue Aug 28, 2012 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fixpack 2 install
Replies: 13
Views: 7526

Re: Fixpack 2 install

Thought I would post my sixpennorth as we just installed 9.5.2 FP2 (64-bit) on our TM1 servers. The install went non-smoothly (euphemism). Here is what we experienced. The domain account, under which original 9.5.2 had been installed, had been set up by someone who had left and IT didn't have the pa...
by iansdigby
Mon Jul 30, 2012 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Imputed elements in RHS of Feeder
Replies: 2
Views: 1651

Re: Imputed elements in RHS of Feeder

lotsaram (indeed the computer in your brain has), Many thanks for this illuminating contribution. Indeed we have already been "done in" on the feeder scenario you describe, i.e. referencing consolidated elements in mismatched cubes. Watching live the consumption of RAM increasing rapidly a...
by iansdigby
Mon Jul 30, 2012 7:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Imputed elements in RHS of Feeder
Replies: 2
Views: 1651

Imputed elements in RHS of Feeder

Apologies if this has already appeared somewhere and my searching failed to find it. I understand that when writing a rule, elements on the RHS of the rule are imputed from the LHS. For example, there is no need to write: ['Profit','UK']= N:['Sales','UK']-['Expenditure','UK']; because 'UK' is inferr...