Search found 109 matches
- 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...
- 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 ...
- 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...
- 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?)
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?)
- 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.
- 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!
- 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...
- 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
Regards, Ian
- 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
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
- 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...
- 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.
Thank you.
- 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
Regards, Ian
- 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
You are of course quite right: it has nothing to do with feeders! Muddled Monday thinking.
Thanks again, Ian
- 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: ['...
- 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...
- 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
Ian
- 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...
- 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...
- 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...
- 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...