Search found 2440 matches

by tomok
Tue Jun 19, 2018 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewRowDimensionSet
Replies: 2
Views: 314

Re: ViewRowDimensionSet

kenship wrote:
Tue Jun 19, 2018 5:45 pm
I have never used this and wonder what benefit it brings
None whatsoever if the purpose of the view is to serve as a data source in a TI process. This function is only useful when creating views to be consumed in the cube viewer.
by tomok
Fri Jun 15, 2018 7:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - Refresh Attribute Hierarchies
Replies: 3
Views: 535

Re: Planning Analytics - Refresh Attribute Hierarchies

You would have thought IBM would have considered making this a bit easier Having an automated process for this doesn't sell software. Having the attribute-based hierarchies in an easy to demo web tool does. Simple as that. I'm sure they'll eventually get around to it if they can focus on day-to-day...
by tomok
Thu Jun 14, 2018 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Service Error
Replies: 8
Views: 1422

Re: TM1 Service Error

You're asking for updated SSL keys for a piece of software that was released 11 years ago. I'm pretty sure you won't be able to get that from IBM since it's been out of support for years. I certainly don't have it and even if I did, it is against the policy of this board to share those types of files.
by tomok
Tue Jun 12, 2018 6:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 375

Re: How to reference data lines as variables in TI?

Aren't using expand to translate values from an input field into a variable name so you can update a cube. Why would you ever have a variable name with decimal places in it like "0.123456789"? The only thing I would see this being a problem is if you were using EXPAND to create an SQL string for ins...
by tomok
Tue Jun 12, 2018 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Service Error
Replies: 8
Views: 1422

Re: TM1 Service Error

I'm attaching the SSLs in case this is the problem. Place them at C:\Program Files\Applix\bin\ssl thanks in advance where is the attchment armas ??? can i have them? I'm sorry but I got a good chuckle out of this post. You're really expecting a reply from a guy who posted this almost 10 years ago??...
by tomok
Tue Jun 12, 2018 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 375

Re: How to reference data lines as variables in TI?

Any suggestions on how to get around the truncation issue? my values are all decimal places eg 0.00123456, the process requires a higher degree of accuracy :D What truncation issue would you be referring to? I didn't see anything in your post about a truncation issue. TM1 is going to load whatever ...
by tomok
Tue Jun 12, 2018 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues with new instance
Replies: 9
Views: 208

Re: Issues with new instance

The data that I'm trying to get into the dev instance is around 40gb so I tried to copy this in and wait for the service in task manager to drop down as it was using high memory usage, but it just times out after around 10 mins :-/ In your first post you said the server started successfully and now...
by tomok
Fri Jun 08, 2018 8:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saved cube views with extremely large width
Replies: 2
Views: 588

Re: Saved cube views with extremely large width

Exit Perspectives and delete the tm1p.ini file on that machine and let TM1 re-create it the next time you run Perspectives. You may have to search for it but it is usually at %USERPROFILE%\user name\AppData\Roaming\Applix\TM1\.
by tomok
Thu Jun 07, 2018 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracing cube load after unload
Replies: 6
Views: 127

Re: Tracing cube load after unload

Have you looked in the tm1server.log file?
by tomok
Wed Jun 06, 2018 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 260

Re: GetProcessErrorFileName()

It didn't work because there's a bug in your logic; when you execute the ItemReject the Prolog stops executing and moves on, exactly as it does if you That makes sense. I changed the logic to this and it works like I want it to now: Prolog: IF(FILEEXISTS(sFile) = 0); PrologError = 1; ITEMREJECT('Hi...
by tomok
Wed Jun 06, 2018 5:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 260

Re: GetProcessErrorFileName()

Try this: sPath = CELLGETS('Global Variables', 'Value', 'Path to Hierarchy Files'); IF(FILEEXISTS(sPath | pFileName) = 0); DATASOURCETYPE= 'NULL'; ITEMREJECT('File is missing'); PROCESSBREAK; ELSE; DATASOURCENAMEFORSERVER= sPath | pFileName; ENDIF; That doesn't work, the process still tries to open...
by tomok
Wed Jun 06, 2018 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 260

Re: GetProcessErrorFileName()

How do I set the DataSourceType to null? NULL doesn't exist in TM1. I tried setting it to an empty string and the process just tries to use the file I have specified in the data source tab instead of not trying to open anything. Here is my code: sPath = CELLGETS('Global Variables', 'Value', 'Path to...
by tomok
Wed Jun 06, 2018 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 260

Re: GetProcessErrorFileName()

Can't you just avoid the fatal error? Test for the existence of the source file and if it isn't there set datasource type to null and itemreject to create the error file. Then on the epilog pick up the error file name ... Thanks for the idea. That's what i was thinking I was going to have to do, I ...
by tomok
Wed Jun 06, 2018 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 260

GetProcessErrorFileName()

I've got a process that uses a text file as a data source, with the name of the file to be processed one of the input parameters. If a user provides an incorrect file name the process obviously bombs and produces an error log file. I would like to get the name of that error log file using GetProcess...
by tomok
Tue Jun 05, 2018 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Usage of more Memory each time a Process is used
Replies: 3
Views: 142

Re: TM1 Usage of more Memory each time a Process is used

I don't read or speak German so your TI code doesn't help any but is it possible one of these dimensions is for time, more specifically, days? You say you are reloading the same data every day but are you loading the data to different intersections in the cube? For example, yesterdays data would hav...
by tomok
Wed May 30, 2018 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rules file and sparsity alogrithm
Replies: 3
Views: 269

Re: Empty rules file and sparsity alogrithm

I have come across interesting comment " Even an empty rule file switches sparsity algorithm off?" and it is emphatically written as Yes.But on the similar vein when although feeders are written but skip check is forgotten, the feeders are ignored silently and rules are being evaluated for every ce...
by tomok
Tue May 29, 2018 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 14
Views: 1418

Re: Server Locked after save data process and save data is running for a long time .

So please Tomok don't just point fingers and throw mud, any old hack can do that. I just did it above, it's not nice and it achieves nothing. As you'll have heard many times, if you don't have anything good to say, don't say it. [hack in]Wow! I'm sorry that I made you feel it necessary to raise the...
by tomok
Fri May 25, 2018 5:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 14
Views: 1418

Re: Server Locked after save data process and save data is running for a long time .

Next you'll be telling me industrial espionage is just a myth? Oh let's not forget about hackers. If somebody hacks in to IBM and steals the info from them who do you think within the original company would get the blame. I guess if your model and data is "espionage-worthy" then this would be a val...
by tomok
Fri May 25, 2018 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 14
Views: 1418

Re: Server Locked after save data process and save data is running for a long time .

IBM refuses to do anything more unless we hand over our entire model and data, which we do not do. Why would you not? "Hand over" is probably not good wording. You do know that their license agreement with you precludes them from disclosing any of your data, anywhere, for any reason? I guess your m...
by tomok
Tue May 22, 2018 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Query Help
Replies: 2
Views: 154

Re: Query Help

It might be due to the question mark (?) in the query. TM1 could be thinking you are trying to insert a parameter.